Import Google Sheets
How to bring in data from a Google Sheet into Count using BigQuery
If you have data in Google Sheets that you'd like to analyze in Count, follow these steps
NB: if your Google Sheet has a header row, remember under to select to skip 1 header row under "Advanced options"
You can do this by executing SQL query in your editor:
create table [new table] as (select * from [gsheet connected table])
If you'd like the data you use in Count to be up to date, set up a scheduled query at your desired interval (hourly is the most frequent).
This determines how frequently data from your Google Sheet is refreshed in Count. Be sure that the refresh frequency aligns with how often you expect edits to occur.
If you haven't yet connected BigQuery to Count, then you'll have to do that first. The following page contains the step-by-step instructions for connecting BigQuery to Count: