Connecting your KPI to Google Sheets will keep it in sync with a single cell in your spreadsheet. It will check the spreadsheet once an hour, and create a new measurement if the value in the cell has changed.
Start by creating a new KPI or editing an existing KPI and scroll down to the Integration section, then select the Google Sheet option from the dropdown. If this is your first time using the Google Sheet integration, you will be prompted to give Topicflow access to Google Sheets. Topicflow only needs "read" access to your spreadsheets, it will not have permission to edit/change the data.
Once you have authorized Topicflow, you will see a form where you can enter the spreadsheet id and choose which cell to sync with your KPI. To find the spreadsheet id, look at the URL of your spreadsheet and select the series of random letters and characters near the end. For example, the id in the URL
To select a cell to sync, there are three options: