Save every new message received on WhatsApp to Google Sheets
Skip the manual copy-paste and let your WhatsApp DMs land straight in Google Sheets, ready for action.
Keeping track of every new WhatsApp message can be overwhelming, especially if you’re juggling customer support, sales inquiries, or team communications. Manually copying these messages into Google Sheets eats up precious time, increases the chance of human error, and means important data can slip through the cracks. Without automation, you risk losing visibility over key conversations, missing out on timely follow-ups, and ultimately, letting opportunities—and money—fall by the wayside.
This Botize formula has your back by automatically saving every WhatsApp message you receive to a Google Sheet you specify. As soon as a new message hits your WhatsApp (via WhatsApp Business Cloud API), the details—timestamp, sender’s number and name, message ID, and message text—are captured and logged into your spreadsheet, giving you a searchable, organized database without lifting a finger. You’re in control: easily customize what information is stored and adjust how often the automation runs, so you only see what truly matters.
Ready to make your WhatsApp communications manageable, searchable, and always up-to-date? Follow the simple steps to set up this automation in Botize, or jump straight to the preconfigured formula to get instant results. Take the hassle out of data entry and let your sheets work for you!
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
Every WhatsApp Message, One Neat Spreadsheet. Automatically.
Whenever someone messages you on WhatsApp—be it a customer, a lead, or your pizza delivery guy—those words and details show up instantly in the Google Sheet you pick. No more missed info, no more scrambling. Just pure, organized conversation history, right where you need it, 24/7.
| Manual | Botize | |
|---|---|---|
| Notice a new WhatsApp message | 1 | 0 Minutes |
| Open Google Sheets, find the right sheet | 2 | 0 Minutes |
| Copy sender, timestamp, message content | 2 | 0 Minutes |
| Paste and organize into right row/column | 2 | 0 Minutes |
| Switch back to WhatsApp, repeat for every message | 5 | 0 Minutes |
| Total (per message) | 10 | 0 Minutes |
Yep, this is the tool you wanted: every WhatsApp message, logged in Google Sheets, no sweat.
Customer Inquiries Tracker
A solopreneur gets client messages on WhatsApp and has them all show up in a Sheet—making it easy to follow up, track requests, and never miss a potential deal.
Never Lose Details
Every message is stored forever—no more scrolling or screenshotting.
Instant Search Power
Find any conversation using Google Sheet filters in seconds, not hours.
Zero Manual Work
Free yourself from endless copying; your time is worth more.
Automated Worklog
A team leader wants all project updates sent via WhatsApp from field agents. Everything lands in Google Sheets, ready for reporting or audits with zero manual effort.
⌾︎ You get WhatsApp messages for work, leads, or customer support and need them organized.
⌾︎ You want a backup or an instant log of important conversations. Or you're tired of missing that one chat you needed.
✕ You don't use WhatsApp (really?), or you prefer chaos and endless scrolling.
✕ You want messages stored in a different file type or platform entirely.
✓ Choose which parts of the WhatsApp message to save (just text, sender info, IDs, timestamps, or all at once).
✓ Set it to work with any Google Sheet you own or manage—perfect for project-specific logs.
✓ Decide which Sheet tab/position to add new messages—so your records always stay organized your way.
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.