Send Bulk Holi Offers for Free

Learn how to send bulk Holi offers for free using Pabbly Connect. This tutorial provides a step-by-step guide for seamless integration with Google Sheets and Pabbly Connect.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect to Get Started

To send bulk Holi offers for free, the first step is to access Pabbly Connect. If you are a new user, open a new tab and search for ‘Pabbly.com/connect’ in your browser.

Once on the Pabbly Connect landing page, click on the ‘Sign Up for Free’ option located in the top right corner. This allows you to explore Pabbly Connect with 100 free tasks every month, enabling you to send up to 100 messages for free.

2. Set Up Your Workflow in Pabbly Connect

After signing up, navigate to the workflow builder within Pabbly Connect. This is where you’ll set up the automation for sending Holi offers. The workflow consists of triggers and actions, with triggers starting the process and actions being the results.

• Click the ‘Add Trigger’ button.
• Search for ‘Google Sheets’ and select it.
• Choose ‘New or Updated Spreadsheet Row’ as the event and click ‘Connect’.

This setup allows Pabbly Connect to monitor your Google Sheets for any new entries, which will trigger the sending of your Holi offers.

3. Integrate Google Sheets with Pabbly Connect

Next, you need to copy the webhook URL provided by Pabbly Connect and integrate it into your Google Sheets. Open your Google Sheets and navigate to the ‘Extensions’ tab, then go to ‘Add-ons’ and select ‘Get Add-ons’.

Search for the ‘Pabbly Connect Webhooks’ add-on and install it. Once installed, refresh your spreadsheet to see the new options. Go to ‘Pabbly Connect Webhooks’ and select ‘Initial Setup’. Here, paste the webhook URL and define the trigger column, which is the final data column that will send data when a new entry is made.

4. Send Automated WhatsApp Messages via Pabbly Chatflow

After successfully setting up Google Sheets, it’s time to send automated WhatsApp messages using Pabbly Connect. Click on ‘Add New Action Step’ and select ‘Pabbly Chatflow’ as the action application.

• Choose ‘Send Text Message’ as the event and click ‘Connect’.
• If you have already created a connection, select it; otherwise, create a new connection using your API key from Pabbly Chatflow.
• Map the recipient’s WhatsApp number and message content.

This step allows Pabbly Connect to send personalized messages to your customers seamlessly through WhatsApp.

5. Finalize and Test Your Workflow

Once your WhatsApp message setup is complete, click on ‘Save and Send Test Request’ to ensure everything is working correctly. Replace any dummy phone numbers with actual numbers to test the message delivery.

Finally, go back to your Google Sheets, navigate to ‘Extensions’, and click on ‘Pabbly Connect Webhooks’ to send all data. This will trigger the sending of WhatsApp messages to all recipients listed in your spreadsheet, confirming that Pabbly Connect effectively automates your Holi offers.

Conclusion

This tutorial demonstrated how to use Pabbly Connect to send bulk Holi offers for free by integrating Google Sheets and Pabbly Chatflow. With these steps, you can easily automate your marketing efforts and reach more customers efficiently.