Queries in current spreadsheet
The "In this spreadsheet" tab in Uniquery allows users to view and manage all queries that run in the current Google Sheets file. This includes both generated reports and API queries. The tab provides detailed information about each query, making it easier to monitor and maintain data connections.

Viewing Queries
To access the "In this spreadsheet" tab:
Open your Google Sheets file and navigate to
Extensions > Uniquery
to open the addon.In the Uniquery sidebar, click on the
In this spreadsheet
tab.
Information Available
In the "In this spreadsheet" tab, you can check the following information for each query:
Data sheet
The tab displays the specific sheet within the Google Sheets file where each query runs. This helps users identify the location of the data imported by the query.
Last Refreshed
For each query, the tab shows the timestamp of the last data refresh. This information is useful for ensuring that the data is up-to-date and determining when the last update occurred.
Auth Refresh Setting
The tab provides details about the authentication refresh setting for each query. This setting indicates whether the query is configured to automatically refresh its authentication tokens, ensuring continuous access to the data source.
Adding or Removing Auth Refresh
Users can add or remove authentication refresh settings for each query directly from the "In this spreadsheet" tab. This feature allows users to enable or disable automatic authentication refresh based on their requirements.
To add or remove auth refresh for a query:
Locate the query in the "In this spreadsheet" tab.
Click on the relevant option to add or remove the auth refresh setting.
Save the changes to update the configuration.
The "In this spreadsheet" tab in Uniquery provides a comprehensive overview of all queries running in the current Google Sheets file. By offering detailed information about each query, including sheet location, last refreshed timestamp, and authentication refresh settings, users can efficiently monitor and manage their data connections. The ability to add or remove auth refresh settings further enhances the flexibility and control over data import processes within Google Sheets.
Last updated