Google sheets
How to connect your tukan query to Google Sheets?
Last updated
How to connect your tukan query to Google Sheets?
Last updated
Once you've created your query, head over to the queries module, 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.
That's it. Your query should appear within a few seconds on your spreadsheet 🥳.
Playing around with the data.
The process we followed imports your data as a Table in Google Sheets. In case you modify your query, or wish to extract the latest data; simply delete the formula and paste it again.
In most cases, Google Sheets will refresh external connections by default every hour.
