How to Send SMS from Google Sheets using Pabbly Connect and Dove Soft

Learn how to send SMS from Google Sheets using Pabbly Connect and Dove Soft in this step-by-step tutorial. Automate your SMS sending process effortlessly. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for SMS Integration

To send SMS using Pabbly Connect, first, access the platform by visiting the Pabbly Connect website. Here, you can either sign in as an existing user or sign up for a new account. By signing up, you will receive 100 free tasks every month, allowing you to explore the automation capabilities of Pabbly Connect.

Once logged in, navigate to the ‘All Apps’ section and select Pabbly Connect to access the dashboard. This dashboard allows you to create and manage your workflows efficiently, setting the stage for integrating Google Sheets with Dove Soft SMS.

2. Creating a Workflow in Pabbly Connect

To create a workflow, click on the ‘Create Workflow’ button in the dashboard of Pabbly Connect. You will be prompted to name your workflow, for instance, ‘Send Automated SMS from Google Sheets using Dove Soft.’ After naming, select a folder to save the workflow, such as ‘Google Sheets and Dove Soft Automations.’

• Name your workflow appropriately.
• Select the appropriate folder for organization.
• Click on the Create button to initiate the workflow.

After creating the workflow, you will see two sections: Trigger and Action. Select Google Sheets as the trigger application, and Dove Soft as the action application. This sets the foundation for automating SMS sending whenever new data is added to Google Sheets.

3. Setting Up Google Sheets Trigger in Pabbly Connect

In this step, you will configure the trigger for Google Sheets in Pabbly Connect. Choose the trigger event as ‘New or Updated Spreadsheet Row’. This event will initiate the workflow whenever a new entry is made in your Google Sheets.

Upon selecting the trigger, a Webhook URL will be provided. This URL is crucial for connecting Google Sheets with Pabbly Connect. Copy this URL and go to your Google Sheets, where you will set up the Pabbly Connect Webhook add-on.

• Navigate to Extensions > Add-ons in Google Sheets.
• Search for and install the Pabbly Connect Webhook add-on.
• Paste the copied Webhook URL in the initial setup section.

After pasting the URL, select the trigger column, which indicates where the data will be added. For instance, if your mobile numbers are in column C, set the trigger column to C. Test the connection to ensure everything is set up correctly.

4. Connecting Dove Soft SMS to Pabbly Connect

Once the Google Sheets trigger is set, move to the action step and select Dove Soft as the action application in Pabbly Connect. Choose the action event as ‘Send SMS’. This action will be executed whenever the trigger is activated.

To establish a connection with Dove Soft, select ‘Add New Connection’ and provide the necessary credentials such as username and API key. These credentials can be found in your Dove Soft account under the API section.

Enter your Dove Soft username and API key. Map the SMS content with the customer’s name and mobile number from Google Sheets. Click on Save and Send Test Request to verify the setup.

After testing, you should receive a success response indicating that the SMS has been sent. This confirms that your connection between Dove Soft and Pabbly Connect is functioning properly.

5. Automating the SMS Sending Process

To ensure that SMS messages are sent automatically to all customers listed in your Google Sheets, you can utilize the ‘Send All Data’ feature in Pabbly Connect. This feature allows you to send SMS messages to all existing entries in your spreadsheet with just one click.

Additionally, enable the ‘Send on Event’ option to ensure that every time a new row is added to Google Sheets, an SMS will be sent to that new customer automatically. This automation eliminates the need for manual intervention, streamlining your communication process.

To summarize, by using Pabbly Connect, you have successfully set up an automated workflow that integrates Google Sheets with Dove Soft SMS. This allows you to send personalized SMS messages to your customers effortlessly.

Conclusion

In this tutorial, we explored how to send SMS from Google Sheets using Pabbly Connect and Dove Soft. By automating this process, you can efficiently communicate with your customers and enhance your marketing efforts. Pabbly Connect simplifies this integration, making it accessible without any coding skills.