Connection health and troubleshooting
What each Google Sheets connection status means — Checking normally, Retrying, Checks delayed, Needs attention, Paused, Disconnected — and what to do.
Open Settings → Lead Capture and select a connection. Health now describes the latest checks only — it shows the last successful check, the last attempt, the next scheduled check and the checking interval. Results are past outcomes (rows accepted, last lead created); they don’t mean the sheet is being read now.
Statuses
| Health now | What it means | What to do |
|---|---|---|
| Checking normally | TatvaCRM is reading this sheet on schedule. An empty sheet, or one with no new rows, is healthy. If there are more new rows than one check reads, they are read over the next few checks — nothing is skipped. | Nothing. |
| Waiting for first check | Capture is turned on and the first check is scheduled. | Nothing — it changes to Checking normally after the first successful read. |
| Retrying | Google is busy or the last check hit a temporary problem. TatvaCRM retries automatically and no rows are lost. | Nothing. |
| Checks delayed | The delay is on our side, not your sheet, or checking is paused for your workspace (for example your plan no longer includes Google Sheets, or your workspace isn’t active). Your rows stay in your sheet and are read once checking resumes; nothing is imported twice. | Usually nothing. If the message asks you to, contact TatvaCRM support. |
| Needs attention | Something about the sheet or access stopped checking. The page says what — see below. | Follow the message, then choose Check again. |
| Paused | Nothing is read while paused. When you resume, rows added in the meantime are picked up as new. | Choose Resume when you’re ready. |
| Disconnected | TatvaCRM no longer has access to this spreadsheet and isn’t checking it. Leads already created are kept. | Reconnect Google to resume. |
| Setup not finished | Setup isn’t finished yet, so nothing is being captured. | Choose Continue setup. |
Needs attention — common causes
| Message | Fix |
|---|---|
| Google access was removed or expired | Choose Reconnect Google and sign in with a Google account that can open the spreadsheet. Rows added meanwhile are captured after you reconnect — none are imported twice. |
| We can’t find the tab | The tab may have been deleted or renamed. Rename it back and choose Check again, or choose the spreadsheet and tab again. |
| We can’t open the spreadsheet | It may have been deleted, or the Google account that connected it lost access. Restore access, or choose the spreadsheet again. |
| The unique ID column is missing | Rename the column back in your sheet, then choose Check again. TatvaCRM never changes your sheet, so it can’t rename it for you. |
| A column your setup needs is missing | Rename it back in your sheet or update the field mapping, then choose Check again. |
| This tab has more rows than TatvaCRM can check | Contact TatvaCRM support — or move older rows to another tab. |
| Several checks in a row failed | Usually Google being unavailable. TatvaCRM keeps retrying; check the spreadsheet still opens in Google Sheets, and choose Check again to try right now. |
Your rows stay in your sheet. When the problem is fixed, rows waiting in the sheet are read and each becomes exactly one lead.
Results notes you may see
- Rows without an ID yet — not leads until the ID is filled in.
- A row has an ID used by an earlier row — only the first row with each ID becomes a lead.
- Rows waiting for details — missing a first name or company name; they’re re-checked and become leads once filled in.
- Mapped columns no longer in the sheet — rows still import from the remaining columns.
- Record limit reached — rows that couldn’t become leads while your workspace was at its plan’s record limit are read again automatically once there is space.
Checking individual rows
The connection’s Submissions tab lists one entry per row TatvaCRM has accepted, with its outcome and owner and an Open lead link. Sheet contents aren’t shown there — open the lead to see its details.