Chat Assistant Beta
DM the Water LLM bot in Google Chat to look up contacts, update your CRM, and log notes — without opening the spreadsheet. Available in Settings → Experiments.
The Chat Assistant is in the Experiments section of Settings because it's still new. Core read and write functions work, but you may encounter rough edges. Share feedback via the Water LLM Updates group.
What You Can Do With It
The Chat Assistant connects directly to your Water LLM spreadsheet. Send it a plain English message and it reads or writes your CRM — using the same data you see in the sheet, in real time.
| What You Can Ask | Example |
|---|---|
| Look up a contact | "Find Sarah Johnson" / "What's the status of my contact at Acme?" |
| Get contact details | "What's Marcus's email?" / "When did I last talk to the team at Brightside?" |
| Search contacts | "Show me all contacts at Google" / "Who haven't I spoken to in 60 days?" |
| What You Can Do | Example |
|---|---|
| Append a note | "Add a note to Sarah: she's interested in the executive coaching program" |
| Update CRM status | "Set Marcus's status to Active Client" |
Before any change is applied to your spreadsheet, the bot shows you exactly what it's about to write — the contact, the field, the current value, and the new value. You confirm or cancel. Nothing changes without your explicit approval.
| Command | What It Does |
|---|---|
/note | Append a note to a contact |
/find | Look up a contact by name, email, or company |
/status | Update a contact's CRM status |
/invoice | Look up invoice details for a contact |
/help | Show what the bot can do |
Getting Set Up
-
1Open Chat Assistant settingsIn your spreadsheet:
-
2Connect your sheetClick Connect Chat Assistant. This links the bot to your specific spreadsheet so it knows where to read from and write to.
-
3Find the bot in Google ChatOpen Google Chat, go to New Chat, and search for Water LLM. Start a direct message with it.
-
4Send your first messageTry "Hi" or "/help" — the bot will introduce itself and show what it can do.
When the Bot Asks You to Clarify
If your query matches more than one contact (e.g., two people named "Sarah"), the bot shows a disambiguation card listing the matches. Tap the one you mean to continue.
If it can't find a confident match at all, it'll say so and ask you to try a more specific query — full name, email address, or company name.
Saying "Sarah Johnson at Acme" is more reliable than just "Sarah." The bot uses fuzzy matching, but a unique identifier (email address, full name, or company) produces unambiguous results every time.
Current Limitations
| Limitation | Details |
|---|---|
| Read-only for most fields | Currently supports note appending and status updates. Creating new contacts, editing invoices, or managing deals via chat is not yet supported. |
| Rate limits | 30 messages per minute, 60 write operations per hour. If you hit the limit, the bot will let you know and you can try again shortly. |
| Confirmation window | Write confirmations expire after 15 minutes. If you don't confirm within that window, the proposed change is discarded and you'll need to re-request it. |
| Session memory | The bot remembers the last 8 turns of conversation (4 messages from you, 4 responses). Older context is dropped. |
| One sheet per Google account | The bot connects to one Water LLM spreadsheet per account. If you have multiple sheets, you'll need to reconnect to switch. |
Reconnecting the Bot to Your Sheet
If the bot says it can't find your sheet, or if you've moved your spreadsheet, you need to reconnect it:
-
1Open your spreadsheet
-
2Go to
-
3Click Reconnect Chat Assistant
-
4Go back to Google Chat and send a message to confirm the connection is live