Watch Step By Step Video Tutorial Below
1. Introduction to the Integration
Integrating Google Sheets with SMS Horizon allows you to send bulk SMS efficiently. This process connects two different services to streamline communication.
To achieve this, we will use a third-party app called Pabbly Connect. It will facilitate the integration between Google Sheets and SMS Horizon.
2. Setting Up Pabbly Connect
First, visit the Pabbly Connect website and sign in to your account. Once logged in, access the dashboard where you can create workflows.
Click on the “Create Workflow” button. Name your workflow, for example, “Google Sheets to SMS Horizon,” and click save.
3. Configuring Google Sheets as the Trigger
In the trigger window, select Google Sheets as the app and set the method to “New Spreadsheet Row.” This will capture data from the spreadsheet.
Next, click on “Capture Webhook Response”. This action prepares Pabbly Connect to receive data from Google Sheets.
4. Preparing Your Google Sheet
Open your Google Sheet, which should have columns for name, number, caller ID, date, and message. Fill in the details for each column.
To send this data to Pabbly Connect, use the add-on feature. Ensure the Pabbly Connect Webhook add-on is installed in your Google Sheets.
5. Connecting to SMS Horizon
Now, in Pabbly Connect, select SMS Horizon as the action app. Choose the method “Send SMS” to configure the sending of messages.
Input your SMS Horizon username and API key to connect. These can be found in the SMS Horizon bulk SMS section under the HTTP API settings.
Map the data received from Google Sheets to the appropriate fields in SMS Horizon. Save this configuration to finalize the integration.
Conclusion
This guide detailed how to integrate Google Sheets with SMS Horizon using Pabbly Connect, allowing for automated SMS sending from your spreadsheet data.
Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.
- Sign Up Free – Start your journey with ease!
- 10,000+ Video Tutorials – Learn step by step!
- Join Pabbly Facebook Group – Connect with 21,000+ like minded people!
- Know more about Pabbly Connect – Automate workflows effortlessly!