Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.elasticfunnels.io/llms.txt

Use this file to discover all available pages before exploring further.

​
Overview

The Google Sheets integration gives ElasticFunnels automations full read/write access to a spreadsheet. Use it for ad-hoc lead tracking, data offload to ops teams who live in spreadsheets, or as a temporary store before more permanent reporting is built.

​
What you can do

ActionWhat it does
Append rowAdds a row to the bottom of a sheet
Batch updateUpdates multiple cells in a single API call
Read valuesReads a range of cells (single sheet or multiple)
Find rowLooks up a row by a search value, returns the row data and index
Update row by searchUpdates a row matched by a search value (upsert-style)
Create sheetAdds a new tab to an existing spreadsheet
Clear rangeEmpties a range without removing formatting
The integration uses Google Sheets API v4 and respects the published 300-requests-per-minute quota with built-in throttling and retry.

​
Setup

You can authenticate two ways. Pick whichever matches how your team manages Google access.

​
Option A — OAuth (one user)

1

Connect your Google account

Go to Integrations → Storage → Google Sheets → Connect with Google. EF redirects you to Google’s OAuth screen.
2

Grant Sheets access

Tick the See, edit, create, and delete your spreadsheets scope. EF stores an OAuth refresh token so it can keep accessing your sheets without re-prompting you.
3

Pick a default spreadsheet (optional)

The form lets you pre-pick a spreadsheet so you don’t have to paste the ID every time you build an automation.
1

Create a service account

In the Google Cloud Console, create a project, enable the Google Sheets API, and create a service account with no roles. Generate a JSON key and download it.
2

Share your spreadsheet with the service account

Open each spreadsheet you want EF to access and Share it with the service account’s email (looks like xxx@xxx.iam.gserviceaccount.com) as Editor.
3

Paste the JSON in EF

Paste the full JSON key contents into the Service Account JSON field of the EF integration form. Save.
Use a service account in production. OAuth tokens are tied to a specific Google user — if that person leaves your org, the integration breaks. A service account belongs to your project, not a person.

​
Patterns

​
Lead handoff to sales

Trigger: Form: submitted → Action: Google Sheets: Append row to a “New Leads” tab with email, name, phone, source, submitted_at. The sales team works the sheet directly without logging into EF.

​
Order export for fulfillment ops

Trigger: Conversion: purchase → Action: Google Sheets: Append row to an “Orders” tab with one row per line item.

​
Inventory check before purchase

Trigger: Form: submitted (pre-checkout) → Action: Google Sheets: Find row matching the SKU on an “Inventory” tab → Condition: available > 0 → continue or redirect to a backorder page.

​
Limits

  • 300 requests / minute per integration (Google’s quota; throttle is built-in).
  • 5 million cells per spreadsheet (Google’s hard limit). Move to a database before you get close.
  • Cell values are coerced to strings on write unless the sheet column is pre-formatted as date / number / currency.

​
Troubleshooting

The service account hasn’t been added to the spreadsheet, or the OAuth account no longer has access. Re-share the file or re-authenticate.
You’re sending more than 300 requests / minute. Spread writes out (e.g. batch them with Batch update instead of one append per row), or split traffic across multiple spreadsheets.
Pre-format the destination column in the spreadsheet (Format → Number) so Google Sheets knows to interpret the value correctly.