Automate Google Slides Creation and WhatsApp Messaging with Pabbly Connect

Learn how to create Google Slides from Google Sheets and send them via WhatsApp using Pabbly Connect. This step-by-step tutorial covers everything you need to automate your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To begin automating the process of creating Google Slides from Google Sheets, you first need to access Pabbly Connect. Start by visiting the Pabbly Connect website and either sign in or create a new account if you are a first-time user.

Once logged in, you will be directed to the dashboard. Here, you can view your existing workflows or create a new one. Click on the ‘Create Workflow’ button to start setting up your automation.

2. Setting Up Google Sheets as the Trigger in Pabbly Connect

The next step involves setting Google Sheets as the trigger application in your workflow using Pabbly Connect. This setup will allow the automation to start when a new row is added to your Google Sheets.

• Select Google Sheets as the trigger application.
• Choose the trigger event as ‘New or Updated Spreadsheet Row’.
• Copy the webhook URL provided by Pabbly Connect.

After copying the webhook URL, go to your Google Sheets, navigate to the Extensions menu, and install the Pabbly Connect Webhooks add-on. Paste the webhook URL in the initial setup and set the trigger column to the last column of your data.

3. Creating Certificates with Google Slides

With the trigger set, the next step is to create certificates using Google Slides through Pabbly Connect. This requires selecting Google Slides as your action application to generate the certificates automatically.

Choose the action event as ‘Create Presentation from Template’. In this step, you will need to connect your Google account to allow Pabbly Connect to access your Google Slides. Once connected, select the template you created for the certificates.

• Map the student’s name and course name in the presentation title.
• Specify the location in Google Drive where the presentation should be saved.

After completing these steps, test the action to ensure that the presentation is created successfully. This automation allows you to generate personalized certificates for each student automatically.

4. Sending Certificates via WhatsApp Using Pabbly Connect

Now that your certificates are created, the next step is to send them via WhatsApp. For this, you will use the WhatsApp integration in Pabbly Connect to automate the messaging process.

Select WhatsApp as the action application and choose the option to send a template message. Connect your WhatsApp account to Pabbly Connect, and enter the necessary details such as the campaign name and student’s mobile number.

Map the student’s name and course name in the message template. Insert the PDF link of the generated certificate.

Once you have configured these settings, test the action to confirm that the message is sent successfully. This will allow students to receive their certificates directly via WhatsApp.

5. Conclusion: Automating Your Workflow with Pabbly Connect

Using Pabbly Connect, you can effectively automate the process of creating Google Slides from Google Sheets and sending them via WhatsApp. This integration not only saves time but also ensures personalized communication with students.

By following the steps outlined in this tutorial, you can streamline your workflow and enhance your online course management. Automating these tasks allows you to focus on delivering quality education while ensuring your students receive their certificates promptly.