Sync WhatsApp data to Google Sheets in real time — append every lead, order, KYC submission, support ticket, or campaign response to a shared sheet your team already lives in. Zero-code OAuth, dynamic column mapping with variable interpolation, automatic token refresh, audit log per row.
What the Google Sheets integration does
Connect any Google account via OAuth (one-click), pick a spreadsheet + tab, map column values with placeholders like {{contact.name}}, {{response.email}}, {{attr.city}}, {{now}}. The Google Sheets node appends a row at flow runtime, branches Success / Failure / Next based on result, and refreshes the access token automatically on 401.
Real Indian cohort numbers
| Metric | Manual export | RichAutomate Sheets sync |
|---|---|---|
| Lag from WA reply → sheet | 3-7 days | 0 (real-time) |
| Rows lost in CSV exports | 4-8% | 0% |
| Sales-team response SLA | 11h | 2h |
| Engineering hours / month | 24 (manual exports) | 0 |
Common use cases
- Lead capture — every Click-to-WhatsApp ad reply → Sheet → SDR pickup.
- Order tracking — D2C support replies → orders sheet for ops.
- KYC submissions — fintech doc-collection flows → audit sheet.
- NPS + survey data — campaign replies → analytics sheet.
- RSVP + event registration — appointment + event flows → guest list.
How it works (3 steps)
- Connect Google account via OAuth at Integrations → Google. Tokens encrypted with Laravel Crypt.
- Drag the Google Sheets node into a flow, pick spreadsheet ID + tab.
- Map columns with placeholders like
{{contact.name}},{{response.email}},{{now}}. Save + publish.
vs alternatives
| Capability | RichAutomate | Zapier | Pabbly | n8n |
|---|---|---|---|---|
| Built-in flow node | Native | External step | External step | External step |
| Auto token refresh | Yes (401 retry) | Yes | Manual reconnect | Yes |
| Variable interpolation | {{contact.x}} {{response.x}} {{attr.x}} {{now}} | Mapping UI | Mapping UI | JS expression |
| Latency / row | 200-400ms | 2-5s (task delay) | 3-8s | 500ms-2s |
| Cost / 10k rows | Included | $20+ (Zaps) | $15 | Self-hosted only |
Security + compliance
OAuth tokens encrypted at rest with Laravel Crypt. Tenant-scoped — no cross-tenant access. Token revoke flow on disconnect. DPDP-compliant audit log per append (tenant_id, contact_id, sheet_id, timestamp). User can disconnect anytime.
Pricing
Google Sheets integration is included in every RichAutomate plan starting ₹999/month. No per-row charge.