Send Data to a Google Sheet
Create a product automation and push data to your sheet
In this article, we show you how to automatically send funnel event data to a Google sheet. It's a two-step process:
create an automation
customize the product
Creating an automation
Log in to your Funnelish account.
Open a funnel.
Click the step which has your product or products.
Click one product. A side panel opens.
Scroll down to the bottom and click the Create new automation button.

Adding Google details
In the next window:
Choose the event that you want to track on your Google sheet with a new row. In this example, we select On purchase.
Click Save changes.

Select a sheet
On the next window:
Click Google Sheets.
Click the Action field and select Add new row.
Click the Spreadsheet field and select a file name.
Click the Sheet field and select the correct sheet name.

Mapping data
Now it’s time to map data. That means you create a digital link between data fields on your funnel and data columns on your Google sheet.
To map data:
Click the Add field mapping link.

2. Click the box on the left. A drop-down menu displays.
The drop-down menu shows the labels of data fields in the funnel. If you want to add any of this information to your Google sheet, add column names that match up with the labels.

3. Click a label in the drop-down menu. In this example, we select Email.
4. Click the box on the right side.
5. Choose the column that collects this data. In this example, we select Email.

Adding fields
Click the Add field mapping link and repeat the steps for each type of data you want to save on the Google sheet.
To save time, click the Auto-match fields button. (optional)
Review each data set line by line to confirm the mapping is correct. If something doesn't look right, click a box and change the mapping.

4. Click Save changes on this page.
5. Click Save changes on the next page.
UTM tags and metadata
To add a UTM tag or metadata, scroll down to the bottom of the drop-down menu and select an option.

There are five UTM tag options (UTM Source, Medium, Campaign, Content, and Term) and four metadata options (fbp, referrer, session_id, and user_agent).
Now you’re done.
Last updated
Was this helpful?