Automate Sending Random Quotes on WhatsApp Using Pabbly Connect and Google Sheets

Learn how to automate sending random quotes on WhatsApp daily using Pabbly Connect and Google Sheets with this step-by-step tutorial. 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 Automation

To start automating the process of sending random quotes via WhatsApp, first access Pabbly Connect. Create a free account by visiting Pabbly.com/connect. Once registered, log in to your account and navigate to the dashboard.

Click on the ‘Create Workflow’ button and name your workflow, for example, ‘Randomly Send Quotes on WhatsApp Daily from Google Sheets’. Click on the ‘Create’ button to initiate the setup. This is where you will define the trigger and action for your automation process.

2. Scheduling the Workflow with Pabbly Connect

In the workflow setup, the first step is to schedule the automation. Select the ‘Schedule by Pabbly’ app as your trigger. This allows you to run the workflow daily at a specific time. Set the frequency to daily and choose the desired time (e.g., 8:10 AM). using Pabbly Connect

• Choose ‘Schedule by Pabbly’ as the trigger app.
• Set the frequency to daily.
• Select the time for sending quotes.

After saving this step, you will see a confirmation of the scheduled time. This ensures that your automation will run at the specified time every day.

3. Fetching User Data from Google Sheets

The next step involves fetching user data from Google Sheets using Pabbly Connect. Select the ‘Google Sheets’ application and choose the ‘Get Row’ action. Connect your Google account to allow Pabbly Connect to access your sheets.

Once connected, select the sheet containing user details. Specify the range of data you want to retrieve (e.g., A2 to C6). This will allow Pabbly Connect to capture all necessary user information for sending quotes via WhatsApp.

4. Iterating Over User Rows with Pabbly Connect

Since you want to send messages to each user individually, use the ‘Iterator by Pabbly’ feature. This will separate the user data row-wise, allowing you to send messages one by one. Select the array of user data captured in the previous step and map it accordingly. using Pabbly Connect

• Choose ‘Iterator by Pabbly’ to separate user data.
• Map the user data to prepare for sending messages.

After setting up the iterator, you will be able to handle each user’s data separately, which is essential for the next steps in the automation process.

5. Sending Random Quotes to WhatsApp

To send random quotes, you need to fetch the quotes from another Google Sheets file. Use the ‘Get Row’ action again for the quotes sheet. This time, however, you will introduce a random selection process. Use the ‘Number Formatter’ feature in Pabbly Connect to generate a random number within the range of your quotes.

Map this random number to fetch a specific quote from your quotes sheet. Finally, select the ‘WhatsApp Cloud API’ to send the message. Set up the connection by entering your WhatsApp API details and select the message template you created earlier.

Conclusion

This tutorial demonstrates how to automate the process of sending random quotes via WhatsApp using Pabbly Connect and Google Sheets. By following the steps outlined, you can set up a daily automation that enhances your communication with users. Using Pabbly Connect, you can ensure that your messages are sent efficiently and effectively.