Google Sheets integration

Send a WhatsApp message automatically when a row is added to a Google Sheet, or when a row changes. Each row becomes one message, personalised with values from its columns. No automation tool is needed: triggers run inside Wbiztool.

Before you start#

• A paid plan. Every paid plan includes Google Sheets triggers: Lite 1, Standard 3, Advanced 5 and Enterprise 10 (see Pricing). Once your Google account is connected, the Google Sheets page shows how many triggers you've used out of your limit. If your plan has no triggers, Connect Google Account shows an upgrade prompt; contact support if you're unsure which plan you need.
• A connected WhatsApp number on WhatsApp settings.
• You must be an owner or editor of the workspace. Only the owner can disconnect the Google account.
• A Google Sheet whose first row contains column headers, such as Name, Phone and Order.

Connect your Google account#

Go to wbiztool.com/google-sheets/ and click Connect Google Account. The page isn't listed in the dashboard menu, so use this link. Sign in with Google and allow access. Wbiztool asks for read-only access to your spreadsheets, and access to the files you pick, so it can see when they change.

One Google account can be connected per workspace. Disconnect (owner only) removes the connection and stops all of its triggers.

Create a trigger#

1. Select resources

   Choose the WhatsApp Number to send from, click Select Sheet to pick your Google Sheet from Google Drive, then choose the Worksheet (tab). Each worksheet can have one trigger.

2. Choose the trigger event

   • New Spreadsheet Row: sends a message for each row added after you create the trigger.
   • New or Updated Spreadsheet Row: also sends again when a row that was already processed changes.

3. Configure the trigger

   Give it a Trigger Name and choose the Phone Number Column. Turn on Enable Scheduling if you want messages sent at a date and time taken from the row. See Scheduling.

4. Write the message

   Choose the Message Type and write the Message Template, using {{Column Name}} to insert values from the row. The Message Preview shows the result.

5. Save and test

   Save the trigger. Use Test on the trigger to preview the message built from the last row of the sheet, and optionally send it. The test message starts with [TEST], and it needs the phone header to match the column name exactly.

Rows already in the sheet when you create a New Spreadsheet Row trigger are skipped. Only rows added afterwards are sent.

Message templates#

Write column headers inside double braces, exactly as they appear in the header row, with no spaces inside the braces:

Hi {{Name}}, your order {{Order ID}} is ready for pickup.

With a row where Name is Aman and Order ID is 4821, the message is:

Hi Aman, your order 4821 is ready for pickup.

Headers are case-sensitive: {{name}} doesn't match a column called Name.

Message types#

Phone numbers#

• The Phone Number Column must contain full numbers with country code, such as 919876543210. No country code is added for you.
• Spaces, dashes, brackets, dots and + are removed. Numbers stored in scientific notation, like 9.19877E+11, are converted to digits, but any digits the sheet already rounded away are lost.
• Use a phone header whose name isn't part of any other header (for example, avoid Phone next to Alternate Phone). Wbiztool uses the last column whose header contains the name you picked. The same applies to the date and time columns.
• Rows where the phone isn't 6 to 15 digits long are skipped. Skipped rows don't count as errors on the trigger card, so if messages are missing, check the phone values.

Scheduling#

With Enable Scheduling on, choose:

• Date Column: the date to send. Accepted formats: YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY and DD-MM-YYYY. For dates like 03/04/2026 that fit both, the month-first reading (MM/DD/YYYY) is used, so prefer YYYY-MM-DD.
• Time Column (Optional): the time as HH:MM or HH:MM:SS (24-hour). Without it, the message is scheduled for midnight at the start of that date, so a row dated today with no time is already in the past and is skipped.
• Default Timezone: the timezone of the dates and times in your sheet.

Rows whose date and time are already in the past are skipped. Without scheduling, each row is sent as soon as the trigger runs.

How and when triggers run#

Google notifies Wbiztool when the sheet changes, and the trigger then reads columns A to Z of the worksheet and processes the new or changed rows. Messages usually go out shortly after the change is saved.

• Only columns A to Z are read. Keep the phone column and every column you use in templates within them.
• If your plan runs out of messages, processing stops at that row. The remaining rows are sent on a later change to the sheet once you have messages again.
• Pause, resume or delete a trigger from its card. The card shows how many times the trigger ran and how many errors it had.

Troubleshooting#