Sheet Automation API

Sheet Automation API is a Google Sheets add-on to help you create API webhooks without writing script.

Once API is created, it will be avaialbe for other apps to consume the service via HTTP GET/POST.

We are adding more actions including but not limited to:

• Update row data
• Create new row
• Format row
• Sort sheet
• Send email
• Many more

Installation

Install the add-on from Google Marketplace.

Start the add-on by clicking menu Extensions - Sheet Automation API - Open…

You should see the sidebar showing up shortly.

Getting started

0. Enable Google Apps Script API

The add-on will create apps script behind the scene. It requires Google Apps Script API setting to be enabled in your account, otherwise API can not be created successfully.

Please go to https://script.google.com/home/usersettings and make sure the Google Apps Script API setting is on.

1. Create a new API.

Click “+API” to start creating a new API.

2. Configure trigger

Click the grey area under Trigger to specify the trigger for API.

3. Configure condition

Click the grey area under Condition to add a condition. This is optional.

4. Configure action

Click the grey area under Action to add an action. We create a Send Email action in this case.

5. Save the API

After action is created, you can save the API.

5. Test the API

It may take a few seconds for the API to be complete deployment. Once it is done, you can test the API.

If you see an error message “Authorization is required”, that means you need to authorize the API script.

Please refresh the sheet. Permission menu will appear and click it to complete authorization.

Once this is done, you should be able to test the API.

Contact