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.