Automate Daily SMS with Random Quotes Using Pabbly Connect and Google Sheets

Learn how to automate sending random quotes via SMS daily using Pabbly Connect, Google Sheets, and Twilio. Step-by-step tutorial included. 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. Setting Up Pabbly Connect for SMS Daily Automation

To automate sending random quotes via SMS daily, first, access Pabbly Connect. This platform allows you to create workflows that integrate Google Sheets and Twilio seamlessly. Start by creating a free account at Pabbly Connect, where you can test automation tasks.

Once you log in, navigate to the dashboard and click on the blue button labeled ‘Create Workflow.’ Enter a name for your workflow, such as ‘Auto Send Random Codes on SMS via Google Sheets,’ and click on ‘Create’ to begin your automation setup.

2. Scheduling Daily Automation with Pabbly Connect

In this step, you will set up the automation schedule using Pabbly Connect. Since the goal is to send SMS daily, you will need to select a scheduling trigger. Choose the ‘Schedule’ option, which allows you to run the workflow daily at a specific time.

• Select the frequency as ‘Every Day’.
• Set the time for the automation to run, for example, 8:00 AM.
• Click on ‘Save’ to confirm the scheduling.

After saving, you will see the scheduled time displayed in your workflow. This ensures that your automation will trigger daily at the specified time using Pabbly Connect.

3. Connecting Google Sheets to Pabbly Connect

Next, you will connect your Google Sheets to Pabbly Connect. This is crucial for fetching user details and motivational quotes from your sheets. Select Google Sheets as the application and click on ‘Connect’. Choose the option to add a new connection, then authorize Pabbly Connect to access your Google account.

Once connected, select the spreadsheet containing your customer details. Make sure to choose the correct sheet and specify the data range, from A2 to C (to accommodate future entries). Click ‘Save’ and send a test request to see if the data is captured correctly in Pabbly Connect.

4. Fetching Random Quotes Using Pabbly Connect

To send random quotes, you will need to implement a random selection process using Pabbly Connect. Start by choosing the ‘Number Formatter’ feature, which allows you to generate a random integer. Use the formula to define the range of your quotes in the Google Sheet.

• Input the formula: `RANDBETWEEN(2,9)` to get a random number between the specified range.
• Connect to Google Sheets again to fetch the corresponding quote based on the random number generated.
• Map the random value in the range input for fetching the quotes.

After setting this up, you can test the request to ensure that the correct random quote is fetched from your Google Sheets, thus utilizing Pabbly Connect to handle the logic of random selection.

5. Sending SMS Using Twilio via Pabbly Connect

Finally, connect your Twilio account to Pabbly Connect to send the SMS. Choose Twilio as the application and set the action event to ‘Send SMS’. You will need to create a new connection to Twilio by entering your Account SID and Auth Token, which can be found in your Twilio account settings.

In the SMS body, craft a message that includes the user’s name and the random quote fetched earlier. For example, you might write: ‘Hello [User Name], start your morning with this beautiful quote: [Random Quote].’ Make sure to map the user details and the quote correctly before sending the test request.

Conclusion

In this tutorial, you learned how to automate sending random quotes via SMS daily using Pabbly Connect, Google Sheets, and Twilio. By following these steps, you can set up an effective communication channel that engages your customers with motivational messages every day.