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 already have BigQuery set up, you'll only need to refresh your schema to see your Google Sheet in your list of tables.
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: