When you save your API requests in Apipheny, they exist only in the Google Sheet where you saved them.
If you want to transfer your saved API requests to a different Google Sheet, Apipheny comes with a feature that lets you export and import your saved API settings from one Google Sheet to another.
Before transferring saved API requests, they have to be saved first. To first learn how to save your API requests, click here.
The purpose of this feature is to allow you and your team to reuse your custom API requests throughout separate Google Sheets.
This way, you and your colleagues can use the same API requests without having to input them all manually for each new Google Sheet.
Here’s a quick video tutorial to get you started:
To transfer your saved API requests to a different Google Sheet, first open the Google Sheet that has your saved API requests.
Then open Apipheny by clicking on Add-ons > Apipheny > Configure. This will open up the Import/Export Configuration tab. Next, copy the data contained in the JSON Export box. This data represents your saved API requests.
Once you’ve copied the data, open the destination Google Sheet. Open up the destination sheet’s Import/Export Configuration tab and paste the data into the JSON Import box. Press Import JSON Configuration to finish the transfer.
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, open your Google Sheet that has your saved API requests, then click Add-ons > Apipheny > Configure.
Here’s what Apipheny will look like with the “Configure” tab open:
After you open Apipheny > Configure, you’ll see some code inside the JSON Export box.
This export code represents your saved API requests. It is what the destination account will use to import your requests into their account. Copy the export code.
If you don’t see anything inside the JSON Export box, then the Google Sheet does not have any saved API requests. You can open the Manage tab in Apipheny to confirm whether there are any saved requests tied to that Google Sheet.
Open the Sheet you want to transfer the saved requests to.
In the destination Google Sheet, open the Configuration tab and paste in the export code from the first Sheet. Click Import JSON Configuration to finish the process. You should now see your saved requests in the Manage tab.
Warning: if your saved API requests contain any API keys, this information will also be included in the export code. Be careful with this sensitive information.
If you want to send your saved API requests to a different Apipheny user, you can send the export code to them using a secure method of communication. They can then paste the code into their own JSON Import box and the saved requests will work just as well.
And that’s it!
Congratulations, you have now transferred your saved API requests to a different Google Sheet.
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
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