Import / Export Configuration Files

Import / Export Configuration Files

Last Updated On November 06, 2019

Importing and exporting configuration files for the API Connector add-on for Google Sheets allows you to copy or transfer request configurations from one sheet to another. The request configuration includes API URLs, headers, and output options. This is a pro feature; please upgrade to access.

Import File

To import a configuration file, please click on Add-ons > API Connector > 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’.

Export File

To export a configuration file, please click on Add-ons > API Connector > Export File.

Clicking ‘Download exported file’ will produce a JSON-formatted API Connector export file of all the requests in your sheet. You can import this file into other Sheets to re-create your requests.

Tips and Troubleshooting

  • 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, 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.


Leave a Reply

Your email address will not be published.