Run Multiple Queries in a Single Request
This advanced feature of the API Connector add-on for Google Sheets allows you to stack multiple requests together and run them all at once. This enables great efficiency when you need to query the same API endpoint multiple times, e.g. for different user IDs or different time periods, or for cases where the API limits the number of records returned in each response. This also allows you to retrieve multiple API responses to a single sheet, since each subsequent request will be appended to the first empty row of the selected sheet.
(This is a paid feature, please upgrade to access).
There are a few methods for accessing this feature:
Note: when running multiple queries, a 1.1 second delay is automatically inserted between requests to help avoid rate limits.
To run multiple requests, list your URLs on separate lines. When you Run the request, each subsequent response will be appended to the first empty row.
As an alternative to the above, you can list your URLs in a single cell. Just make sure they are on separate lines, like this:
Now you can reference the cell (info) like this, with the same results as above:
You can also combine the two methods if you like, for example by listing out references to cells in the input box. Again, make sure each separate request is on a new line, to ensure API Connector recognizes it as a new request: