Send an SMS message when a new row is added to Google Sheets using Zapier

October 29, 2023 • 5 min read

Automate sending personalized SMS messages each time a new row is added to your Google Sheets document using Zapier. You don't need to write any code to make this happen and you can personalize the SMS messages which are sent out.

Prerequisites

Basic understanding of Google Sheets.
Basic understanding of Zapier.
An account on httpsms.com

Step 1: Create trigger on Zapier

Create a new Zap on Zapier and select Google Sheets as the trigger. The event name should be "New Spreadsheet Row" if you want to send an SMS message every time a new row is added to your Google Sheets document.

On the Zap, select the Spreadsheet which you have on google drive and make sure to select the correct Worksheet.

In the sample spreadsheet below, we are mimicking an e-commerce store. The first column contains the name of the customer, the second column is the name of the product which was bought and the third column is the phone number of the customer who made the purchase. You can use your own custom spreadsheet with your own set of columns.

Step 2: Create an action on Zapier

An action is what happens after the trigger. In this case, we want to send an SMS message to the customer who made the purchase. Select Webhooks By Zapier as the action app and select Custom Request as the action event.

On the Action section in Zapier, set the Method to Post. Set the URL to https://api.httpsms.com/v1/messages/send. Set the `Data Pass-Through` to false. In the Data field, add the following JSON payload.


{
  "content": "Hello [Name]\nThanks for ordering [Product] via our shopify store. Your order will be shipped today!",
  "from": "+18005550199",
  "to": "[ToPhoneNumber]"
}

In the JSON message above, we are mimicking an e-commerce store. The [Name] variable contains the name of the customer on the spreadsheet. [Product] contains the name of the product which was bought and [ToPhoneNumber] contains the phone number of the customer who made the purchase. You can use your own custom message with your own set of variables according to your spreadsheet. Change the from field to the phone number which you registered on httpsms.com.

On the headers section add a new header called x-api-key and the value of this header should be your API key on httpsms.com and you can copy your API key from the settings pagehttps://httpsms.com/settings.

Also add a new header called Content-Type and the value of this header should be application/json

The final configuration of the action should look like the screenshot below.

Conclusion

Publish your zap and you will automatically trigger httpsms to send an SMS to your customer when ever you add a new row in the google sheet. Don't hesitate to contact us if you face any issues configuring your zap to send SMS messages from your Google Sheets by following this tutorial.

Until the next time✌️

Acho Arnold