Receive WhatsApp Incoming Messages in Google Spreadsheet – Real-Time Webhook Integration

In this quick tutorial, you'll learn how to capture incoming WhatsApp messages in real-time into a Google Spreadsheet using a lightweight Google Apps Script. This method leverages Apps Script — Google's cloud-based JavaScript platform — to automate workflows without requiring coding expertise.

With our prebuilt script, you can instantly log WhatsApp messages from your assigned long code number, enabling easy tracking, auditing, or customer support follow-up — all within your familiar spreadsheet interface.

1. A valid SMSGatewayCenter WhatsApp API account with active credits and a paid subscription.
2. A working Google Account with access toGoogle Spreadsheets.
3. At least one keyword configured on your WhatsApp long code to capture incoming replies via webhook.

Go to your Google account, click on Sheets.

A new tab will be opened where you can start a new spreadsheet, Click on Blank from shown template gallery as shown below.

A new blank spreadsheet will open. Rename the Sheet from Untitled spreadsheet to Incoming WhatsApp. Now add headers in the sheet. In row 1 of the spreadsheet, add column titles:

• Column 1 (A) = Date
• Column 2 (B) = WABA (WhatsApp Number)
• Column 3 (C) = Mobile
• Column 4 (D) = Keyword
• Column 5 (E) = Circle
• Column 6 (F) = Operator
• Column 7 (G) = Received Time
• Column 8 (H) = Message

Once you are done with column header in sheets, now head on to add our ready script. You can get our complete downloadable code, once you are recharged with your account from our team.

Go to Toolbar, Click on Extensions, then Apps Script.

A new Apps Script tab will open. Rename Untitled project to Receive Incoming WhatsApp Code. By default, code.js editor will be shown.

Remove all codes from the editor window. Copy and paste the given code from our team on this window and edit the following constants. Update Sheet1 to as you have named your sheet, if you have not changed the sheet name, then leave it as it is. Once editing is done, click on save button. On the top right, Click on Deploy and click on New deployment.

A pop window will open, click on Cog icon, you will be shown with options. Click on Web app, and now you will be shown with options.

• Description: Enter a short description.
• Execute as: Select Me.
• Who has access: Select Anyone from the drop-down options.

At the bottom, click on Deploy.

Google requires permission, so it pops up a confirm window to authorize your account with the added script. Click on Authorize access.

By continuing, it will take you to select your Google account, select the account which you have used for your sheet.

As our script isn't verified by Google, you'll see a warning on the next screen. Click on Advanced to proceed.

The Advanced option will appear as shown below. Click on Go to Receive Incoming WhatsApp Code (unsafe) to proceed.

In the next window, you'll see a list of permissions required by the script. Scroll down and click Allow. Don't worry — you are granting permissions to your own account, and no one else can access your app code or sheet data.

Once the deployment is successfully updated, Google will provide a Deployment ID and a Web App URL. Copy the Web App URL.

Next, log in to your SMSGatewayCenter account and navigate to the Webhook section from the left sidebar.

For a detailed step-by-step guide, refer to our knowledge base article on how to set up a webhook to receive incoming WhatsApp messages and delivery reports (DLRs).