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.
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.
All requests must have an output sheet, or they won’t be imported. If you’d like to automatically create these sheets during the import process, check the box saying ‘Automatically create new destination sheets’.
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.
- As noted above, all requests must have an associated sheet. Requests without a sheet will not be imported. This means that you can restrict which requests get imported by not creating sheets for them.
- 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, and tick the ‘Automatically create new destination sheets’ checkbox before importing.
- If your sheet already has a request with the same name, new requests will be imported in with a ‘_2’ appended to the name.