If you want to manipulate Spreadsheet via App Script then you are on the right place.
I'll write a professional GAS to help you automate all your tasks using technologies like:
Html form that will be bound to a spreadsheet a database
Data fetch using external APIs
The scope of the tasks that can be done with GAS is very broad, it
can include data processing in a spreadsheet or generating a report to
send via email and many more actions across the suite of applications
offered by Google
Examples of some tasks that I have completed Data processing
Copy data from one to another sheet(s) on the basis of some conditions,Creating new Spreadsheets or sheets
Finding Duplicate values in a sheet or another sheet(s).
Highlight rows, columns on the basis of some condition
Delete column/rows, Add column/rows, set formatting of some cells
Manipulate Data 1. Making calculations and formalizing the template 2. Send automatic emails/sms and read emails from Gmail account 3. Manipulation with Spreadsheet events
Maintain Inventory 1. Google Form / HTML web form to enter data into sheet 2. Convert sheets to Excel, PDF and CSV formats