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:
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 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).
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.
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.
If your scheduled requests are not executing, try these steps to troubleshoot it:
Please note that Google has limits when using APIs and other services such as formulas and scripts:
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.
Make a GET request
Make a POST request
PUT, PATCH, & DELETE Requests
Save requests for later
Schedule requests for automatic updates
Reference cell values in requests
=APIPHENY custom function
Stack multiple URLs in a single request
Run all saved requests at once
Modify your request settings
Import & export saved API settings
Crypto API tutorials and more:
Alpha Vantage API
Constant Contact API
Facebook Graph API
Facebook Ads API
Google SERP API
Linkedin Ads API
Product Hunt API
Reddit Ads API
Riot Games API