There are two ways of setting up a scheduled Google Sheets export in Funnel.
From Data Explorer
If you're already looking at your data inside Data Explorer, you can easily make a one-off export which can later be scheduled.
See this article for step-by-step instructions: https://help.funnel.io/en/articles/1074118-how-to-export-data-to-google-sheets-from-data-explorer
From Google Sheets page
You can also create a scheduled export configuration from the Google Sheets page, explained below.
To create a scheduled Google Sheets export, go to the "Google Sheets" page and then click the "New Export" button.
On the top of the page, change "My Sheets Export" to your sheet name.
Next, press the "Sign in with Google" button to give Funnel access to upload data with your selected account.
Use an existing Spreadsheet
If you want Funnel to upload data to an existing spreadsheet, you can paste it's URL into the "Sheets URL" textbox.
By default, Funnel will select a couple of common dimensions and metrics. You can select more/fewer by pressing the "Choose fields..." button.
By default, all data is exported but you can reduce the amount of data by adding filters.
- Dimension filters will filter data on dimensions, such as data from a specific Datasource.
- Metric filters will filter data on metrics, such as "only include rows with clicks above 200"
If you want currency conversion, select "Choose currency" and then select a currency you want all monetary metrics to be exported as.
There are two date range options.
- Preset date range will use a rolling range such as "Last 30 days" or "Last 7 days". If you don't want to include the current day, you can also select the "Full" option such as "Last full 7 days".
- Fixed date range lets you select a static date range.
Last, you can select when you want the export to run. Either choose a specific time of the day or a interval such as "Every 6 hours"