Import / Export Configuration Files
Importing and exporting configuration files for the API Connector add-on for Google Sheets allows you to share or duplicate your requests by copying request configurations from one sheet to another. The request configuration includes API URLs, headers, and output options. You may also import cURL snippets.
Please note: importing is available on all plans, but exporting is a pro feature; please upgrade to access.
To import a configuration file, please click on Add-ons > API Connector > Import/Export > Import File
You will be prompted to select a configuration file to import. Note that this file must be a valid API Connector export file.
To export a configuration file, please click Add-ons > API Connector > Import/Export > Export File.
This will produce an export file modal. Click the “Download export file” link to download all your requests as a JSON file to your desktop.
In some cases, Chrome may block the JSON file download as described here. Therefore, the export file will also be saved into the first tab of your sheet. To use that export file instead, open that tab and click File > Download > Tab Separated Values (the file will only be recognized if it uses tab-separated values).
Either way, you can then import your request file into other Sheets to re-create your requests.
Tips and Troubleshooting
- If you want to create an exact duplicate of an existing sheet, click File > Make a copy in your existing sheet, and then import the request file into the copy. If you instead want to duplicate only the request configurations without existing data, start with a fresh, empty worksheet.
- If your sheet already has a request with the same name, new requests will be imported in with a ‘_2’ appended to the name.