How to Send Your Training Courses Details on WhatsApp from Google Sheets Using Pabbly Connect

Learn how to automate sending training course details from Google Sheets to WhatsApp using Pabbly Connect. Step-by-step tutorial included! Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Introduction to Pabbly Connect for Automating WhatsApp Messages

Pabbly Connect is an integration platform that allows users to automate workflows between applications. In this tutorial, we will explore how to send your training courses details on WhatsApp from Google Sheets using Pabbly Connect. This integration eliminates the need for manual message compilation, making the process seamless and efficient.

To get started, ensure you have a Google Sheets document ready with your training course details. By using Pabbly Connect, you can automate the message sending process directly to your students on WhatsApp, ensuring they are updated with the latest course information.

2. Setting Up Pabbly Connect to Work with Google Sheets

To set up the integration, first, access your Pabbly Connect account. If you don’t have one, you can create an account for free. Once logged in, navigate to the dashboard and click on the ‘Create Workflow’ button. Name your workflow something descriptive, like ‘Send Course Details from Google Sheets to WhatsApp’.

Next, you need to set up the trigger for your workflow. Select Google Sheets as the application and choose the trigger event as ‘New Spreadsheet Row’. This will allow Pabbly Connect to detect when a new row is added in your Google Sheets document.

• Log in to your Pabbly Connect account.
• Create a new workflow and name it appropriately.
• Select Google Sheets as the trigger app and ‘New Spreadsheet Row’ as the event.

Once you have completed these steps, Pabbly Connect will generate a webhook URL that you will use to connect your Google Sheets document. Copy this URL for the next step.

3. Connecting Google Sheets to Pabbly Connect

With the webhook URL copied, open your Google Sheets document and click on ‘Extensions’. From there, navigate to ‘Add-ons’ and then click on ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it. After installation, refresh your Google Sheet to see the new options.

Next, go back to ‘Extensions’, select ‘Pabbly Connect Webhooks’, and choose ‘Initial Setup’. Here, paste the webhook URL you copied earlier and specify the trigger column, which is the last column where data will be entered.

• Open Google Sheets and go to Extensions > Add-ons > Get Add-ons.
• Install Pabbly Connect Webhooks.
• Select ‘Initial Setup’ and paste the webhook URL.

After completing this setup, your Google Sheets will be connected to Pabbly Connect. Now, whenever you add a new training course in the specified column, it will trigger the workflow.

4. Sending Messages via WhatsApp Using 360 Dialog

After setting up the Google Sheets connection, the next step is to send the data to WhatsApp using 360 Dialog. In Pabbly Connect, click on the plus icon to add a new action step and select 360 Dialog as the application. Choose the action event as ‘Send Template Messages’.

To connect with 360 Dialog, you will need to provide your API key and domain, which you can find in your 360 Dialog account. This step is crucial as it allows Pabbly Connect to send messages directly to WhatsApp using the WhatsApp API.

Select 360 Dialog in Pabbly Connect and choose ‘Send Template Messages’. Enter your API key and domain from your 360 Dialog account. Map the required fields for the message template.

Once connected, you can map the fields from your Google Sheets data to the WhatsApp message template. This ensures that each student receives personalized messages with course details.

5. Testing the Integration and Finalizing Setup

Now that everything is set up, it’s time to test the integration. Go back to your Google Sheets and add a new training course. After adding the course, check your WhatsApp account to see if you received the message with the course details.

If the message is received successfully, it confirms that Pabbly Connect has successfully integrated Google Sheets with WhatsApp via 360 Dialog. This automation will save you time and ensure that your students are always informed about the latest training courses.

Add a new row in Google Sheets for a training course. Check WhatsApp for the course details message. Confirm successful message delivery.

By following these steps, you have successfully set up an automated workflow using Pabbly Connect to send training course details from Google Sheets to WhatsApp, enhancing your communication with students.

Conclusion

In this tutorial, you learned how to use Pabbly Connect to automate the process of sending training course details from Google Sheets to WhatsApp. This integration not only saves time but also ensures that your students receive timely updates about new courses. By following the steps outlined, you can streamline your communication process effectively.