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!
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
Set up the first step so the automation can run as soon as it's activated.
Copy and paste this prompt into the AI editing tool.
Make sure the automation starts running immediately when it is turned on. ⤵
Click the 'Apply this task' button to confirm.
-
4
Capture every new WhatsApp message received.
Copy and paste this prompt into the AI editing tool.
Add a step to trigger the automation whenever a new text message is received on WhatsApp using Whapi. ⤵
Click the 'Apply this task' button to confirm.
-
5
Save all relevant information from each WhatsApp message into Google Sheets.
Copy and paste this prompt into the AI editing tool.
Add a step to create a new row at the end of your chosen Google Sheet whenever a message is received. In this row, save the date and time, the chat ID, the sender's phone number, the sender's name, the message ID, and the message text. ⤵
Click the 'Apply this task' button to confirm.
-
6
Your automation is ready to use. Click the 'Save changes' button.
Save changes
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.
