Funnelish Docs
FunnelishPricingBlogCommunity
  • Overview
  • Getting Started
    • Quick start
    • 1️⃣Creating a funnel
      • Funnel steps
      • Products
    • 2️⃣Customize design
      • General Settings
      • Layout
      • Containers
      • Compositions
      • Saving assets
      • Payment Forms
        • 2 Step Form
        • Payment Form
      • Express Checkout
      • Product List
      • Text Elements
      • Media
      • Loox Reviews
      • CTA
      • Order Bump
      • Popups
      • Form element
      • Timer
      • Progress Bar
      • Social Network Buttons
      • Order Summary
      • FAQs
    • 3️⃣Collecting payments
      • Payment Methods Supported
      • Add payment methods
      • Card payments
        • Stripe
        • NMI
        • Checkout.com
        • Airwallex
      • PayPal
      • Express Checkout (Google & Apple Pay)
      • iDEAL payments
        • iDEAL through Stripe
        • iDEAL through Airwallex
      • P24 (Poland)
      • Cash On Delivery
      • Buy Now, Pay Later
        • Klarna through merchant account
        • Klarna through Stripe
        • Klarna through Airwallex
      • Bancontact payments
        • Bancontact through Stripe
        • Bancontact through Airwallex
      • SEPA Direct Debit
      • RazorPay (India)
      • EPS (Austria)
    • 4️⃣Connect your domain
      • Introduction
      • GoDaddy
      • Namecheap
      • Shopify
      • Cloudflare
  • ADVANCED FEATURES
    • Funnel analytics
    • Send SMS
    • A/B Testing
    • Geo-funnels
    • Responsive design
    • Discounts
  • Integrations
    • Integrations Overview
    • Shopify
      • Connect Your Shopify Store
        • Shopify custom app
      • Send Orders to Shopify
      • Set Up Order Bundling
      • Set Up Dynamic Variants
      • Set Up Order Notes
    • Connect to Google Sheets
      • Connect Your Google Account
      • Send Data to a Google Sheet
    • Get Started with Klaviyo
      • Connect With Klaviyo
      • Send Data to Klaviyo
    • ShipStation
      • Connect to ShipStation
      • Send Orders to ShipStation
    • ActiveCampaign
      • Connect with ActiveCampaign
      • Create an ActiveCampaign Automation
    • Hyros
      • Connect With Hyros
      • Create a Hyros Automation
    • MailChimp
      • Connect with MailChimp
      • Automate With MailChimp
    • SendGrid
    • Mailgun
    • Zapier
  • Apps
    • Funnelish Apps Overview
    • Facebook Pixel
    • Pinterest Tag
    • Proofy
    • Google Analytics
    • TaxJar
    • TikTok Pixel
  • Automations
    • Overview
      • Set up automations
    • Triggers
    • Actions
      • Sending Emails
        • Text Only
        • Templates
      • Send a Notification
      • Delays
      • Conditions
      • Webhooks
      • Jumps
      • Integrations
  • Resources
    • Multi-Users Access
    • Send Emails From Funnelish
    • Manage Your Orders
    • Manage Your Customers
  • FAQ
    • Funnel Launch Checklist for Funnelish
    • Profile Information
    • Frequently Asked Questions
    • Troubleshooting Issues
    • Ordering Without an Address
    • How to change a page title?
    • Set a Default Landing Page
    • How to Charge a Shipping Fee
  • Connect to Click Funnels (Legacy)
    • Your First ClickFunnels Funnel
      • 1 Add Your Funnel
      • 2 Copy Your Tracking Code
      • 3 Turn On Your Apps
    • ClickFunnels Apps
      • Smart Optin
        • Facebook Client ID
        • Google Client ID
      • Smart Currency Converter
      • Programmable
      • Fancify
        • Product Variant Set Up
      • Paypal Plugin
        • Testing Purchases
      • Smart Address Plugin
    • Tracking Orders
      • Track Paypal Orders In ClickFunnels
      • Track ClickFunnels Orders In Funnelish
Powered by GitBook
On this page
  • Creating an automation
  • Adding Google details
  • Select a sheet
  • Mapping data
  • Adding fields
  • UTM tags and metadata

Was this helpful?

  1. Integrations
  2. Connect to Google Sheets

Send Data to a Google Sheet

Create a product automation and push data to your sheet

PreviousConnect Your Google AccountNextGet Started with Klaviyo

Last updated 2 years ago

Was this helpful?

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

To complete these steps, you must first connect the Funnelish app to your Google account. We showed you how to do that in a .

Creating an automation

  1. Log in to your Funnelish account.

  2. Open a funnel.

  3. Click the step which has your product or products.

  4. Click one product. A side panel opens.

  5. Scroll down to the bottom and click the Create new automation button.

You can add Google integration to an existing automation or create a new one. In this example, we create a new automation.

Adding Google details

In the next window:

  1. Choose the event that you want to track on your Google sheet with a new row. In this example, we select On purchase.

  2. Click Save changes.

Select a sheet

On the next window:

  1. Click Google Sheets.

  2. Click the Action field and select Add new row.

  3. Click the Spreadsheet field and select a file name.

  4. 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:

  1. 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

  1. Click the Add field mapping link and repeat the steps for each type of data you want to save on the Google sheet.

  2. To save time, click the Auto-match fields button. (optional)

  3. 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.

Funnelish will not replace data on your sheet, only append it.

You can map to your Google sheet!

UTM tags and metadata
different article
Create an automation