Connecting Google Sheets
Connect your Google Sheets for lead storage and offline conversion tracking in WAConversionTracking.
Connecting Google Sheets to WAConversionTracking
WAConversionTracking integrates with Google Sheet to provide access to the following data:
- Click Data (An entry for each button click with, status on if the click converted, GCLID and UTM Parameters.
- Lead Data (An entry for chat conversion from a click with all relevant information such as GCLID and UTM Parameters)
- Conversion Actions (used for offline conversion uploads to Google Ads)
You can connect both from the Data Connections section in your dashboard.
🧰 Prerequisites
Before connecting your Google Sheet, you need:
- A Google Cloud Project
- A Service Account with “Editor” permissions
- The Google Sheets API enabled
- Your JSON Key File downloaded
- Your Sheet shared with the Service Account Email
📁 Sheet Types
Sheet Type | Purpose | Notes |
Conversion Actions | Upload leads to Google Ads | Only one tab allowed |
Leads | Stores detailed message data | Can include multiple tabs |
Clicks (optional) | Tracks button clicks even if no message | Used for advanced attribution |
🔧 Setup Steps
- Go to Google Cloud Console
- Create a new project
- Enable the Google Sheets API
- Create a Service Account
- Assign Editor role
- Download the JSON key
- Go to your Google Sheet(s)
- Share with the service account email
- Give Editor access
📂 Inside WAConversionTracking
- Navigate to Data Connections in the sidebar
- Under the correct workflow, click Add Google Sheet
- Upload your JSON key
- Paste the Sheet ID (found in the Sheet’s URL)
- Click Sync Now to confirm connection
- You’ll see last updated timestamps and can manually resync as needed
🧪 Testing
After setup:
- Create a test lead using a test UID & GCLID
- Trigger a WhatsApp message
- Check if the Leads sheet logs the new entry
- Check if the Conversion sheet shows the correct GCLID + timestamp
🔁 Need to Replace a Sheet?
- Click Remove next to the connected sheet
- Add a new sheet using the same process
- You can only have one active sheet per data type, per workflow