The Apipheny add-on for Google Sheets comes with a built-in feature that lets you save your API requests for future use.
This is a very basic feature, but it’s also one of the most important, and we recommend learning it as soon as possible. It’ll save you a ton of time by letting you re-run your saved API requests instead of manually inputting them every time you do your work.
The Save feature is also a prerequisite to using the Schedule feature. If you want to learn how to Save your API requests so you can start Scheduling them, follow the steps below.
Here’s a quick video tutorial to get you started:
To save your API request, go to Apipheny’s Import tab, fill out all of the necessary fields (API URL Path, Headers, etc.), then press Save.
If you’re new to Apipheny, just follow the steps below and you’ll be ready to use this feature in no time.
To begin, go to your spreadsheet then click Add-ons > Apipheny – API Tool > Import API. If you don’t already have the add-on installed, you can install it here.
Input your API URL Path containing the endpoint you want to use, any headers, which sheet you want the request to run on, and customize your API request as necessary.
Once you’re done customizing your request, click Run to test it out then click Save once you’re satisfied to save your request. Apipheny will ask you to name your saved request. Choose an appropriate name that’s easy to remember and click Save to finish the process.
To view your saved API requests, go to the Manage tab. There, you’ll see a complete list of all your saved requests.
To instantly run a request, click Run. To refresh all of the API data in the entire spreadsheet, you can run all saved requests simultaneously by clicking Refresh All APIs.
To edit, duplicate, or delete a saved request, go to the Manage tab to see a complete list of all your saved requests.
Then click on the name of the saved request that you want to modify. After you click on the Name, you will be taken to the edit page where you can modify the saved request as you like.
When editing a saved request in the Manage tab, you’ll notice two new fields that were not available/visible in the Import tab.
The Request Name is the name of your request. This name is visible in the Manage tab and also when creating a scheduled request. Choose an appropriate name that’s easy to remember.
The Sheet Name is the name of the sheet you wish to import data into.
After you save your API request, you can then head over to the Schedule tab in Apipheny to schedule your saved request to automatically run every hour, day, week, or month.
Schedule requests for automatic updates
Reference cell values in requests
Stack multiple URLs in a single request
Run all saved requests at once
Crypto API tutorials and more: