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. This detailed tutorial covers step-by-step integration without coding. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To send SMS from Google Sheets using Pabbly Connect, start by accessing the platform. Simply visit the Pabbly Connect website and either sign in if you are an existing user or click on ‘Sign up for free’ to create a new account. New users receive 100 free tasks monthly, allowing them to explore this powerful automation tool.

Once logged in, navigate to the dashboard where you can manage your workflows. Click on the ‘Create Workflow’ option to begin setting up your automation. Here, you will provide a name for your workflow, such as ‘Send Automated SMS from Google Sheets using Dove Soft’. After naming, select the folder where you want to save this workflow.

2. Setting Up the Trigger with Google Sheets

In this step, you will configure the trigger for your workflow using Google Sheets. Select Google Sheets as your trigger application in Pabbly Connect. The trigger event you need to choose is ‘New or Updated Spreadsheet Row’. This event will initiate the workflow whenever a new row is added to your Google Sheets.

• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the provided webhook URL for later use.

After selecting the trigger event, a webhook URL will be generated. This URL is crucial for connecting your Google Sheets with Pabbly Connect. Copy this URL and proceed to your Google Sheets to set up the integration.

3. Integrating Google Sheets with Pabbly Connect

In your Google Sheets, navigate to the Extensions menu and select Add-ons, then click on ‘Get Add-ons’. Search for ‘Pabbly Connect Webhook’ and install it. After installation, refresh your Google Sheets to ensure the add-on appears under Extensions.

• Go to Extensions > Pabbly Connect Webhooks > Initial Setup.
• Paste the copied webhook URL into the designated field.
• Specify the trigger column (e.g., column C for mobile numbers).

Once you have set this up, click the ‘Send Test’ button to verify the connection. This will send a test response to Pabbly Connect, confirming that your Google Sheets integration is successful.

4. Configuring Dove Soft SMS as the Action

Now, it’s time to set up Dove Soft SMS as the action in your Pabbly Connect workflow. Select Dove Soft SMS as your action application and choose the action event ‘Send SMS’. This step allows you to automate the sending of SMS messages to the customers listed in your Google Sheets.

To establish a connection with Dove Soft, select ‘Add New Connection’ and enter your Dove Soft username and key. You can find these details in your Dove Soft account under the JSON API section. After entering the required information, click on ‘Save’ to finalize the connection.

Next, you will need to enter the SMS content. Personalize your message by mapping the customer name from the previous response. For example, your SMS could read: ‘Dear [Customer Name], enjoy our grand opening discount at Divine Glamour Makeup Studio. Book any service and get 20% off!’ Remember to format the mobile number correctly, including the country code.

5. Finalizing the Automation Process

With your workflow set up, you can now finalize the automation process in Pabbly Connect. Click on the ‘Save and Send Test Request’ button to ensure the SMS is sent correctly. You should receive a success response indicating that the SMS was sent to the mapped number.

If you want to send SMS to all existing customers listed in your Google Sheets, use the ‘Send All Data’ button in the Pabbly Connect Webhooks menu. This action will automatically send messages to all customers whose details are present in your spreadsheet.

For ongoing automation, ensure that you check the ‘Send on Event’ option. This setting will allow SMS to be sent automatically whenever a new row is added to your Google Sheets. This integration through Pabbly Connect ensures that your SMS sending process is efficient and requires no manual intervention.

Conclusion

In this tutorial, we explored how to send SMS from Google Sheets using Pabbly Connect and Dove Soft. This integration allows for automated messaging, enhancing communication with customers without the need for coding skills. Enjoy seamless SMS automation!