Seamlessly Receive Incoming SMS in Google Spreadsheet - Real-Time Integration

In this tutorial, we'll demonstrate how to receive/capture incoming SMS messages real-time into Google Spreadsheet using Apps Script. Apps Script is a cloud-based JavaScript platform that lets you integrate with and automate tasks across Google products. Even if you've never written a line of code before, the process takes less than ten minutes to finish.

Using our apps script code, you can capture long code incoming SMS messages.

1. An SMS Gateway Center's SMS account with credits in your account balance with a paid subscription.
2. A completely functional Google account having access with Google Spreadsheets.
3. You must have a keyword set in your account to receive incoming SMS messages to the assigned long code.

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 SMS. Now add headers in the sheet. In row 1 of the spreadsheet, add column titles:

• Column 1 (A) = Date
• Column 2 (B) = VMN (Long code 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 SMS 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 SMS 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.

Now, log in to your SMS Gateway Center account. From the sidebar, navigate to 2 Way SMS and click on Manage 2 Way SMS Keywords.

On keywords manage page, click on Edit.

On the edit page, follow these steps:

• Add Callback URL (HTTP): Select Yes.
• Callback URL (HTTP): Choose the POST method from the dropdown and paste the Webhook URL provided by Google that you copied earlier.

Finally, click Save Changes.