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

October 29, 20235 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.


  • Basic understanding of Google Sheets.
  • Basic understanding of Zapier.
  • An account on

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.

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 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]"


On the headers section add a new header called x-api-key and the value of this header should be your API key on and you can copy your API key from the settings page

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.


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