Jump to:
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.
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
Ahrefs API
Airtable API
Alpha Vantage API
Asana API
Binance API
Clickup API
Coingecko API
Coinmarketcap API
Coinbase API
Constant Contact API
Discord API
Drift API
Etsy API
Eventbrite API
Facebook Graph API
Facebook Ads API
Figma API
Github API
Google SERP API
Hubspot API
Hunter API
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?