Google WorkspaceGoogle Sheets WhatsApp Integration
Read a row to answer a question, write a row when something happens.
For a lot of teams the spreadsheet is the system of record, and that is fine. Libromi Connect treats a Google Sheet as a two-way database: a chatbot can look up a row and answer from it, and it can append or update a row when a conversation, order or form is completed. There is also a Google Sheet CRM mini app, so the same sheet can sit beside the conversation in the inbox.
Libromi Connect
WhatsApp Business Platform
Google Sheets
Two-way connection
Where it shows up
- Chatbot builder node
- Inbox sidebar mini app
- AI agent tool
- Webhooks & REST API
The data exists, in a sheet nobody can query from chat
Stock levels, price lists, order references, delivery slots, class timetables — the answer to most repeat questions is already in a spreadsheet somebody maintains. Without a way to read it, an agent alt-tabs to find a value that a chatbot could have returned instantly, and the same question gets asked three hundred times a month.
What moves, and which way
Google Sheets to WhatsApp
Row lookup
Find the row matching an order number, a phone number or a code, and answer the customer from its values.
Values into variables
Columns from the matched row become chatbot variables you can use in messages or branch on.
Dynamic content
Drive lists, prices or availability in a message from the sheet rather than hard-coding them in the flow.
WhatsApp to Google Sheets
New rows
Append a row when a conversation completes, a form is submitted or an order is confirmed.
Row updates
Update an existing row as a request moves through its stages.
Structured captures
WhatsApp Flow form answers and chatbot variables land in the columns you mapped them to.
Because the sheet is shared, non-technical staff can maintain the data the chatbot answers from.
What you get
A spreadsheet as a database
Read and write rows from a chatbot flow, with no server, no schema migration and no developer.
Answer from real data
Order status, stock, timetable, price — return the current value instead of a canned reply.
Google Sheet CRM mini app
The same sheet can dock beside the conversation in the inbox, so an agent sees and edits the row while chatting.
Maintained by anyone
The people who own the data update the sheet directly. Nothing needs re-publishing for the change to take effect.
What you can build with it
Order tracking without an agent
The customer sends a reference, the flow finds the row, and replies with status and expected date.
Lead capture your team can actually see
Every qualified enquiry appends a row, so sales work from a live sheet instead of a chat export.
Availability lookups
Slots, seats or stock held in a sheet decide what the chatbot offers, and the row updates when one is taken.
A distributor answering stock questions all day
Retail customers ask whether a part is available and what it costs. The stock sheet was updated daily by the warehouse, but the only way to consult it was to ask an agent who had it open.
The result
The most common question in the business is answered instantly from data the warehouse already maintains, with no new system to run.
- 1
The customer sends a part number to the WhatsApp number.
- 2
The chatbot looks up the row in the stock sheet and reads quantity and price into variables.
- 3
It answers with availability and price, and offers to reserve the item.
- 4
If the customer reserves, the flow writes a row to the reservations tab that the warehouse works from.
How to connect it
- 1
Connect your Google account
Authorise Google Sheets from Libromi Connect and pick the spreadsheet and tab to work with.
- 2
Map the columns
Decide which columns are read into variables and which chatbot variables are written back to which columns.
- 3
Add the block to a flow
Place the read or write step where it belongs in the conversation, and branch on what comes back.
Frequently asked questions
Related integrations
Teams that connect this one usually connect these too.
Use the sheet you already maintain
Connect Google Sheets and let the chatbot answer from real data.