Apipheny is an API integrator for Google Sheets.

The Apipheny add-on lets you save your API requests for future use.

Depending on the scale of your data operations, you could have anywhere from just one to dozens of different saved requests. Thanks to the Schedule feature, you can automate these requests.

Below, we’ll show you how to schedule automatic requests in Apipheny.

Here’s a quick video tutorial to get you started:

How to create a scheduled request

To create a saved request, head over to the Schedule tab. Begin by clicking the Create Scheduled Request button.

You’ll then see 3 fields:

  • Scheduled Request Name – the name you wish to assign to your scheduled request
  • Saved Request – a drop-down list that lets you choose from all your saved requests
  • Frequency – the rate at which you want your scheduled request to run

Scheduled requests are merely saved requests that run regularly based on the frequency you choose. To create a scheduled request, you must first create a saved request. Click here to learn how.

Once you’ve chosen your saved request from the drop-down, choose the frequency you’d like it use. You can schedule a saved request to run every hour, day, week, or month.

Once you’ve finalized your settings, give it an appropriate name that’s easy to remember and click Save to save it.

Once you click Save, your scheduled saved request will automatically trigger according to the frequency you’ve chosen (hourly, daily, weekly, or monthly).

Time zone & timing of requests

Currently Apipheny uses US/New_York time zone for scheduled requests. We will add more time zone options for users in the future.

Also, the exact times of requests are randomly assigned by Google within an hour from the selected time. If you schedule a request to trigger at 9AM, Google will choose a time between 9AM and 10AM and keep that timing consistent. Learn more. 

Frequency of requests

You may be wondering why Apipheny doesn’t offer faster frequencies than once per hour, and that’s because Google limits add-ons to update only once an hour at most, which is why the fastest frequency you can choose is hourly. Learn more.

Troubleshooting failed scheduled requests

If your scheduled requests are not executing, try these steps to troubleshoot it:

  • Try deleting the scheduled request(s) and creating the scheduled request(s) again
  • Try signing out of your account and signing back in
  • Install Apipheny in a different Google account and create a scheduled request; this will help you determine if the issue is isolated to your first account or not

Google API Usage Limits

Please note that Google has limits when using APIs and other services such as formulas and scripts:

  • 20,000 API calls per day
  • 6 mins processing time per hour
  • 90 mins processing time per day
  • 50 mb per call

Click here for info on Google service quotas.

A google user’s quota can be limited based on the combined amount of activity from things such as scripts, addons, and formulas (eg. GOOGLEFINANCE).

These quotas, when maxed out, can interfere with Apipheny and cause scheduled requests to fail.

Popular API Tutorials

API Knowledge

What is an API?

What is an API URL?

What are parameters?

What is an endpoint?

What is an API key/token?

What is basic authentication?

What are headers?

What is a GET request?

What is a POST request?

Import JSON to Google Sheets

SEO by SearchCyrus