Google sheets
How to connect your tukan query to Google Sheets?
Last updated
Was this helpful?
How to connect your tukan query to Google Sheets?
Last updated
Was this helpful?
Once you've created your query, head over to the , and click on the export button for the query you wish to connect.
Next, select the Google sheets tab and click the Copy link button to copy the query's "connection string" to your clipboard.
This "connection string" is what will allow Sheets to connect directly to our database and ensure you always have the latest data available in your spreadsheet.
Please note that this is only done the first time you connect a query. Once you've established the connection, you only need to refresh the feed to get the latest data...
Open a Google sheets spreadhseet, and perform the following instructions:
Select the cell where you wish the data to be imported.
Paste the "connection string" directly into the cell.
Wait a few seconds for the connection to establish. If a warning message appears, approve your spreadhseet to connect to external data.
Playing around with the data.
In most cases, Google Sheets will refresh external connections by default every hour.
That's it. Your query should appear within a few seconds on your spreadsheet .
The process we followed imports your data as a in Google Sheets. In case you modify your query, or wish to extract the latest data; simply delete the formula and paste it again.