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!
Automate this task with 3 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
Begin by setting up the main trigger that activates the automation instantly whenever a new WhatsApp message is received.
Copy and paste this prompt into the AI editing tool.
Create a trigger that runs the automation every time a new message arrives on WhatsApp. ⤵
Click the 'Apply this task' button to confirm.
-
4
Add a step to capture the details of the incoming WhatsApp message, such as the sender's number, their name, the message ID, and the message text.
Copy and paste this prompt into the AI editing tool.
When a text message is received on WhatsApp, collect the sender's phone number, the sender's name, the message ID, and the content of the message. ⤵
Click the 'Apply this task' button to confirm.
-
5
Finally, add a step to save this information as a new row in a Google Sheets spreadsheet, storing the time received, the sender's number, name, message ID, and the message text in separate columns.
Copy and paste this prompt into the AI editing tool.
Add a row to a Google Sheets spreadsheet with the time the message was received, the sender's number, the sender's name, the message ID, and the message text, putting each piece of information in its own column. ⤵
Click the 'Apply this task' button to confirm.
-
6
Your automation is ready to use. Click the 'Save changes' button.
Save changes
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.
