Last Updated On September 06, 2019
You are here:
< Back

Automated scheduling for the API Connector add-on for Google Sheets is available at hourly, daily, weekly, and monthly intervals. This is a pro feature; please upgrade to access.

To create an automatic trigger, click Add-ons > API Connector > Schedule Triggers > Add New.

Here you can choose specific API request names from the drop-down menu, or choose the ‘All’ option to run all of them at once. You can also select the refresh frequency for each trigger.


As you can have multiple triggers in a sheet, give them clear names to differentiate (e.g. VWO – daily).

Note that all triggers will use the spreadsheet timezone, which you can view by clicking File > Spreadsheet Settings.


    1. Hi Mathias, the hourly update limit is because Google doesn’t let add-ons use triggers more than once an hour (documentation). If that ever changes, I’ll add in triggers for more frequent updates.

Leave a Reply

Your email address will not be published.