Print Request URL in Response
The API Connector add-on for Google Sheets provides an option to include your request URL in your sheet each time your data refreshes. To access, click on the ‘Output options’ button and check the ‘Add request URL’ box.
BEFORE YOU BEGIN
If you haven’t already, click here to install the API Connector add-on from the Google Marketplace.
WHY ADD REQUEST URLS?
This feature lets you print your request URL into your response sheet. This is useful in cases where the request URL itself contains some important metadata that isn’t available from the API response.
For example, imagine you’re fetching YouTube data for various search terms. YouTube’s API sends back a list of statistics, but doesn’t include the search term in their response. If you are searching for data on multiple search terms, adding in the request URL tells you which statistics correspond to which term.
EACH ROW OPTION
By default, the request URL will be printed on the first line of the data set (in either the first or second column, depending on whether or not you have enabled timestamps). If you prefer to see the request URL on every row, click the “Each row?” option to enable it.