How to Send REAL-TIME SMS from Google Sheets Using Pabbly Connect

Learn how to send real-time SMS notifications from Google Sheets using Pabbly Connect. This step-by-step tutorial guides you through the integration process. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for SMS Automation

To send real-time SMS notifications, you first need to access Pabbly Connect. This platform allows you to automate tasks between Google Sheets and SMS services seamlessly.

Start by signing up for a free account on Pabbly Connect. You can create your account in just two minutes. Once logged in, you will be directed to the dashboard where you can set up your workflows.

2. Creating a New Workflow in Pabbly Connect

In this step, you will create a workflow to automate SMS sending. Click on the ‘Create Workflow’ button and name your workflow, for example, ‘Google Sheets to Twilio’.

• Select the folder for your workflow in Pabbly Connect.
• Choose ‘Google Sheets’ as the trigger app.
• Set the trigger event to ‘New or Updated Spreadsheet Row’.

After setting up the trigger, you will get a webhook URL. This URL is essential for connecting your Google Sheets with Pabbly Connect.

3. Connecting Google Sheets to Pabbly Connect

To link Google Sheets with Pabbly Connect, copy the webhook URL provided. Open your Google Sheets, go to ‘Extensions’ > ‘Add-ons’ > ‘Get add-ons’ and search for ‘Pabbly Connect Webhooks’.

• Install the Pabbly Connect Webhooks add-on.
• Refresh your Google Sheets after installation.
• Go to ‘Extensions’ > ‘Pabbly Connect Webhooks’ > ‘Initial Setup’.

In the setup box, paste the webhook URL and set the trigger column to the last data entry column in your sheet. This setup enables Pabbly Connect to send data whenever a new row is added.

4. Configuring SMS Service with Pabbly Connect

After configuring Google Sheets, the next step is to set up your SMS service. In the action window of your Pabbly Connect workflow, select ‘Twilio’ as your SMS service provider.

Choose the action event as ‘Send SMS Message’. You will need to connect your Twilio account by entering your Account SID and Auth Token, which can be found in your Twilio dashboard.

Enter the body of the SMS, including personalized details from Google Sheets. Map the recipient’s mobile number and sender number from your Twilio account.

Once you have configured these details, click on ‘Save and Send Test Request’. This will allow you to test if the SMS is sent successfully through Pabbly Connect.

5. Testing Your SMS Automation Workflow

To verify that your automation is functioning correctly, return to your Google Sheets and enter a new user’s details in a new row.

Once the details are added, Pabbly Connect will automatically trigger and send an SMS notification to the user. You should see the SMS arrive on the recipient’s mobile device almost instantly.

This confirms that your setup is working perfectly. If you want to replicate this automation, you can clone the workflow using the link provided in the description.

Conclusion

This tutorial demonstrated how to send real-time SMS notifications from Google Sheets using Pabbly Connect. By following these steps, you can automate SMS notifications efficiently and enhance your communication processes.