Import Configuration Files
Importing configuration files for the API Connector add-on for Google Sheets allows you to make use of pre-set request configurations rather than starting from scratch. The request configuration includes API URLs, headers, and output options. You may also import cURL snippets.
Contents
Import File
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.
Export File
Please note: importing is available on all plans, but exporting is a paid feature.
To export a configuration file, please click Add-ons > API Connector > Import/Export > Export File. This will produce both a JSON and a TSV file, either of which can then be imported into other sheets running API Connector. For more detailed information please consult the knowledge base article on exporting configuration files.
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.