Google Sheets CRM app
The Google Sheets CRM app turns your own Google Sheet into a CRM beside every conversation.
- Plan
- Depends on your plan · Which plan do I need?
- Who can use this
- Account owner, Manager, Agent
The Google Sheets CRM app turns your own Google Sheet into a CRM beside every conversation.
The Google Sheets CRM app (listed in the catalog as Gsheet CRM) turns your own Google Sheet into a CRM beside every conversation. Agents see and edit the matching row next to the chat. A full-page workspace adds a board, a list, follow-ups and reports. Your records stay in your spreadsheet: the app keeps no copy of them.
Install it from Settings → Integration → Mini Apps → Browse. Once installed it shows:
Start from a ready-made CRM, or pick a sheet you already use.
Confirm what each column means. The phone column is the one used to match conversations.
The app finds the row by the customer's phone number.
Follow-ups set from a conversation or from a lead appear on the full page's Follow-ups tab, grouped by when they are due. The tab name shows how many are overdue.
All, Overdue, Today, Tomorrow, This week, Later or Done, each with a count. If you can see other people's follow-ups, Mine shows only yours.
Click the lead's name to open the lead, Open chat to jump to the conversation ("No chat linked" when it was set from the board), or Snooze to move it (Later today, Tomorrow morning, Tomorrow evening, Early next week, Mid next week, Start of next month).
Click it again to reopen.
Who sees which follow-ups follows their role: managers see everyone's, team leads their team's, and agents their own. Days are counted from midnight in your own browser's time zone.
miniapps) and any add-on the app lists. Check Billing → Current Plan.drive.file), not your whole Drive._id and _order) on first use. Do not delete them.Changes tab inside your own spreadsheet.Do it with Copilot
Do it with Copilot
(needs approval)
| What you see | Why | What to do |
|---|---|---|
| "Google access expired" | Google sign-in was revoked or expired | Click Connect Google again |
| "Could not read that sheet." | The sheet was moved, deleted, or the Google account lost access | Share it with the connected account, or choose another sheet |
| No row shows for a conversation | The phone number does not match any row | Check the phone column and number format |
| "Could not reach the app. Check your connection and try again." | Network or app outage | Try again later |
| "Nothing to chase" on Follow-ups | No follow-ups have been set yet | Set one from a conversation or a lead |
| "Lead removed from sheet" on a follow-up | The lead's row is no longer in the sheet | Mark the follow-up done, or restore the row |