How to transfer saved API settings to another Google Sheet

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.

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:

How to transfer saved API requests to a different Google Sheet

To transfer 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.

Step 1. Open Google Sheets and open the Configuration tab

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:

Open Google Sheets and open the Configuration tab
Apipheny Configuration tab open in Google Sheets

Step 2. Copy the export code from the JSON Export box

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.

Copy the data contained inside the JSON Export box

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.

Step 3. Paste the export code into the JSON Import box of the destination 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.

Paste the code into the JSON Import box of the destination Google Sheetd
Paste the export code into the JSON Import box

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.

Click “Import JSON Configuration” to finish importing.
Click the Import JSON Configuration button to finish the process

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.


More API Tutorials

Related Posts