Tuesday, March 31, 2020

Manipulate Google Spreadsheet With App Script











About:

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:

  • Spreadsheet
  • Twilio Send/Receive SMS, Call.
  • Html Services bound to a spreadsheet

  • GDocs
  • G Calendar
  • G Forms
  • Gmail
  • 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

  1. Copy data from one to another sheet(s) on the basis of some conditions,Creating new Spreadsheets or sheets
  2. Finding Duplicate values in a sheet or another sheet(s).

  3. Highlight rows, columns on the basis of some condition
  4. 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



Reviews


Seller's Response:

Seller is very accommodating an very professional.

Seller's Response:

Looking forward

Seller's Response:

he was super fast and communicative

Seller's Response:

Thank you. Looking forward

Seller's Response:

Awesome as always. Hamad is a Google Sheet wizard




No comments:

Post a Comment