Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To start generating Google Slides automatically, you need to access Pabbly Connect. Open a new tab and go to pabby.com/connect. This will take you to the Pabbly Connect landing page.

If you are a first-time user, sign up for a free account. This allows you to explore features of Pabbly Connect with 100 free tasks every month. Once logged in, you will see the Pabbly Connect dashboard ready for your automation setup.

2. Creating Your Workflow in Pabbly Connect

After accessing the dashboard, click on the “Create Workflow” button and select “Create from Scratch”. Name your workflow, for example, “Generate Google Slides in Bulk Using Google Sheets”. This name will help you identify your automation easily.

  • Click on the “Create Workflow” button.
  • Select “Create from Scratch”.
  • Name your workflow as desired.

Next, choose the trigger application as Google Sheets and set the event to “New or Updated Spreadsheet Row”. This means any new data added to your Google Sheets will trigger the workflow, allowing Pabbly Connect to automate the creation of Google Slides.

3. Setting Up Google Sheets with Pabbly Connect

To connect Google Sheets with Pabbly Connect, you will see a webhook URL provided after selecting your trigger. Copy this URL and head to your Google Sheets. In the Google Sheets, go to Extensions, then Add-ons, and select “Get Add-ons” to install Pabbly Connect Webhooks.

After installation, return to your Google Sheets and refresh the page. Go back to Extensions, select Pabbly Connect Webhooks, and click on “Initial Setup”. Here, paste the webhook URL and set your trigger column, which will be the column where you add participant details. For example, if column D contains phone numbers, select that as your trigger column.

4. Generating Google Slides from Google Sheets

Now that your Google Sheets is set up, add an action step in Pabbly Connect. Choose Google Slides as the action application and select the event “Create Presentation from Template”. Connect your Google account, and select the template you created for the certificates.

In the setup, you will need to map the participant’s name and date into the presentation title. Use variables in the template by adding curly brackets around the names. This will allow Pabbly Connect to dynamically generate slides with the participant’s details.

  • Select Google Slides as the action application.
  • Choose “Create Presentation from Template” as the event.
  • Map the participant’s name and date using variables.

Once set up, click “Save and Send Test Request” to generate the first slide. You will receive a confirmation that the slide has been created successfully in your Google Drive.

5. Finalizing the Setup and Testing

To finalize the setup, add another action step to share the created Google Slide as a PDF. Choose Google Drive and select the event “Share a File with Anyone”. Map the presentation ID you received from the previous step to make the file accessible.

Finally, update your Google Sheets with the PDF link of the certificate. Select Google Sheets again, and choose “Update Cell Value”. Map the necessary details, ensuring that the PDF link is updated in the correct row for each participant. This completes the automation workflow using Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the generation of Google Slides from Google Sheets. By following the steps outlined, you can efficiently create participation certificates for multiple users with ease. This setup saves time and enhances productivity.