# Google sheets ### Getting the connection URL Once you've created your query, head over to the [queries module](https://app.tukanmx.com/visualizations/queries), 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. *** ### Connecting to Google Sheets {% hint style="success" %} 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... {% endhint %} Open a Google sheets spreadhseet, and perform the following instructions: 1. Select the cell where you wish the data to be imported. 2. Paste the "connection string" directly into the cell. 3. 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 :partying\_face:. *** ### What's next? Playing around with the data. The process we followed imports your data as a [Table](https://www.ablebits.com/office-addins-blog/excel-table-tutorial/) 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.