A spreadsheet is still where many small businesses keep leads and requests. To integrate WhatsApp with Google Sheets you need the WhatsApp side readable by a machine first; after that, writing rows is the easy part.
Checked on November 16, 2026.
The WhatsApp side
WACrew runs on your own server, linked to your existing number, and keeps every group and direct chat with transcribed voice notes. It exposes that history two ways: an MCP server for AI agents and a documented API v1 for scripts and automation tools.
Route 1: an AI agent (for messy text)
Good when the rows need judgment: "is this a new request or a follow-up?", "what is the budget mentioned in this voice note?".
- WACrew's MCP gives the agent your chats.
- For the sheet, Google documents an MCP server for Sheets (Sheets MCP reference); check its current status and setup in Google's guide. Community Google Workspace MCP servers also exist.
Read every chat from the last 7 days. For each new lead (someone who wrote for the
first time), add a row to the "Leads" sheet: name, chat, date, what they want, budget
if mentioned. Show me the rows before writing.
Route 2: n8n (for structured exports)
Good for fixed columns on a schedule, with no model involved.
- On the WACrew server:
node scripts/api-token.mjs criar sheets --escopos read. - In n8n: Schedule trigger, then HTTP Request to
/api/v1/radar(who is waiting) or/api/v1/chats/{slug}/messages, withAuthorization: Bearer <token>. - Google Sheets node: append one row per item.
Useful sheets this produces: a daily "waiting clients" log, a weekly response-time report, an archive of one client group.
Limits
- Route 1 runs when you ask; Route 2 on n8n's schedule.
- A spreadsheet full of chat text is a privacy liability. Store the summary and the link to the chat, not whole conversations.
- WACrew is not the official WhatsApp Business API; it links as a device on your number.
Questions
Can I export a WhatsApp group to Google Sheets? Yes. With Route 2, read /api/v1/chats/{slug}/messages page by page and append rows (date, author, text, transcript).
Can it read the voice notes? WACrew transcribes them, and the API returns a transcript field per message.
Do I need to code? Route 1 is plain language to an agent. Route 2 is an n8n workflow with three nodes.
Can a sheet send WhatsApp messages? Technically a write token can send, but bulk sending from a list is the fastest way to get a number banned. Keep this for logging and reports.


