Save every new message received on WhatsApp (via Whapi) to Google Sheets
Stop copying, pasting, and missing key info! Let every new WhatsApp message organize itself into Google Sheets, just how you want it.
Manually sorting through every WhatsApp message and copying its details into a Google Sheet isn’t just tedious—it’s a massive drain on your time and a constant source of error. When messages arrive day and night, missing even a single item can mean lost leads, delayed support follow-ups, or incomplete records that undermine your decision-making. Without automation, you risk poor team coordination, missed opportunities, and chaotic reporting that could impact your business growth and reputation.
This formula from Botize connects your WhatsApp account (via Whapi) directly to Google Sheets, capturing every incoming message and logging important details—chat ID, sender’s number and name, message ID, timestamp, and the message itself—instantly in a sheet you define. Everything happens in real time with no manual work or risk of missing vital info. Plus, you control exactly what data is stored and can adjust how often data is synced, or set specific filters to match your business workflow. Suddenly, every message is organized, traceable, and ready for analysis or follow-up.
Ready to turn your WhatsApp inbox into a reliable, actionable database? Jump into the step-by-step guide and see how easy it is to set up with Botize, or use this formula pre-configured and customizable to your needs. In just a few minutes you'll go from overwhelmed to automated—let’s make it happen!
Start using this automation
It's ready to go. Choose how to set it up in your account.
Open it in the Botize editor
Load it into your account and customize it in the visual panel, with everything in view.
Open it in Claude or ChatGPT
Copy this and paste it into ChatGPT or Claude (with the free Botize connector): it'll load the automation, tailor it with you and save it to your account.
Not connected yet? Claude guide · ChatGPT guide
Turn Every WhatsApp Message into Smart Data — Instantly in Google Sheets
Every time someone sends you a WhatsApp message, BOOM: it’s neatly logged into your chosen Google Sheet, exactly the way you need. Decide what bits to store (names? message? number?), and you’re set. Setting it up is easier than making instant noodles—and a lot more useful.
| Manual | Botize | |
|---|---|---|
| Check WhatsApp for new messages | 1 min each | 0 Minutes |
| Copy and paste message, name, and number to Sheet | 2 min each | 0 Minutes |
| Double-check formatting, avoid typos | 1 min each | 0 Minutes |
| Total (for just 10 messages) | 40 minutes | 0 Minutes |
If you wanted WhatsApp messages on Google Sheets—automatically—yes, you’re in the right place. No more doubt. No more manual chaos.
Customer Inquiry Tracker
Automatically save every incoming product question on WhatsApp to a Google Sheet for your support team—never drop the ball or miss a follow-up again.
Zero Manual Effort
Messages appear in your spreadsheet without lifting a finger.
Always Up-To-Date
Get the freshest data for reporting, follow-ups, or sanity checks, 24/7.
Custom-Fit
Pick which message details matter most to you. Tailor it your way!
Lead Collection for Real Estate Agents
Every lead's message and contact info lands straight into your leads database—so you can call, email, or text them back at the right time, with all the context.
⌾︎ You run a business—or manage a team—that gets important WhatsApp messages daily
⌾︎ You’re tired of manual spreadsheets but don’t want to learn complicated automation lingo
✕ You never use WhatsApp to collect information or leads
✕ You enjoy rewriting messages into spreadsheets (hey, some people might!)
✓ Choose exactly which fields from WhatsApp you want in your spreadsheet: message ID, sender, timestamp, etc.
✓ Direct messages to different sheets, tabs, or even columns—fully flexible.
✓ Set up filters for only certain types of messages, contacts, or keywords.
This automation is triggered every time you receive a message via WhatsApp and saves its content to a Google Sheets spreadsheet. You must provide the URL of the Google Sheet and can customize which specific data from each message you want to store.
Related automations
Other ready-to-use automations you may find useful.
Apps in this automation
These are the apps this automation connects. Open any of them to discover everything you can automate with it.
Actions used
These are the exact steps this automation runs. Each action can be reused in other automations.