Limits, privacy and FAQ
Google Sheets lead capture limits (connections, checking interval, rows), what Google data TatvaCRM can access, and answers to common questions.
Limits
| Limit | Value |
|---|---|
| Connections per workspace | 3 — each spreadsheet tab counts as one, including paused, disconnected and unfinished connections |
| Checking interval | 5 minutes (default and shortest), or 15 minutes, 30 minutes, 1 hour |
| Speed | Scheduled, not instant: a new row usually becomes a lead within about one interval plus a couple of minutes — a target, not a guarantee |
| Very busy sheets | If many rows arrive at once, they are read over the next few checks — nothing is skipped |
| Rows per tab | Very large tabs can’t be checked; the connection says so. Move older rows to another tab or contact support |
| Leads | Count towards your plan’s record limit |
What TatvaCRM can access in Google
- Only the files you pick. TatvaCRM asks Google for the narrowest permission available — access to the specific files you choose in Google’s picker — not the rest of your Google Drive.
- No Google account data. We don’t request your name, email address or other account details.
- Read-only. TatvaCRM reads the spreadsheet’s name, its tab names, the header row, your chosen ID column and the rows needed to create leads. It never writes to your sheet.
- New-rows-only setups keep only a one-way fingerprint of the existing rows’ IDs, never their contents.
- Access is stored encrypted, and is revoked and deleted when you disconnect or delete the connection. You can also remove access from your Google Account’s Third-party apps & services page.
Full details: Privacy Policy — Google Sheets lead capture.
FAQ
Why isn’t my new row a lead yet?
Checks are scheduled. Wait one interval plus a couple of minutes, then look at Health now and Results. Common reasons a row waits: no ID yet, an ID already used by an earlier row, or no first name or company name.
If I edit a row after it became a lead, does the lead change?
No. A row becomes a lead once; later edits in the sheet don’t update or duplicate the lead. Update the lead in TatvaCRM.
If I delete a row in the sheet, is the lead deleted?
No. Leads stay in TatvaCRM.
Can one spreadsheet feed several connections?
Yes — one connection per tab, up to your connection limit. The same tab can’t be connected twice.
Does this work with Google Forms?
Yes: connect the tab where your form’s responses are saved. Use a column that’s unique per response as the ID — for example a timestamp if two responses can’t arrive in the same second, or an ID column your form tool adds.
Google says my organisation blocks the app
Your Google Workspace admin controls which third-party apps may be used. Ask them to allow TatvaCRM, then connect again.
Will the same person become two leads?
Yes, if they appear in two rows with different IDs. Each new row creates a new lead; TatvaCRM doesn’t merge or flag these automatically.
Contact TatvaCRM support with the connection’s name and what Health now shows. Please don’t send us your sheet’s contents.