Automate Google Slides Presentation Creation with Pabbly Connect

Learn how to integrate Google Sheets, Google Slides, and Google Drive using Pabbly Connect to automate presentation creation effortlessly. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Slides Automation

To automate your Google Slides presentations, start by accessing Pabbly Connect. This platform enables seamless integration between Google Sheets, Google Slides, and Google Drive. First, sign up for a free account on the Pabbly Connect website, which allows you to utilize free automation tasks monthly.

Once logged in, navigate to the dashboard and click on ‘Create Workflow’. Name your workflow appropriately, such as ‘Google Slides Automation’. This is where you will define the trigger and actions for your automation process.

2. Defining Trigger Event in Google Sheets

The next step involves setting the trigger event, which initiates the workflow. In Pabbly Connect, select Google Sheets as your trigger application. Choose the trigger event as ‘New or Updated Spreadsheet Row’. This event will activate the automation whenever new data is added or existing data is modified in your Google Sheets. using Pabbly Connect

• Select the trigger application as Google Sheets.
• Set the trigger event to New or Updated Spreadsheet Row.
• Copy the provided webhook URL for connection.

After copying the webhook URL, follow the instructions to connect your Google Sheets with Pabbly Connect. This connection allows Pabbly Connect to fetch data from your spreadsheet, which will be used to create presentations in Google Slides.

3. Creating a Presentation in Google Slides

After establishing the trigger, proceed to set up the action in Google Slides. Select Google Slides as the action application and choose the action event ‘Create Presentation from Template’. This action will generate a new presentation based on a predefined template. using Pabbly Connect

Connect your Google account and select the template you want to use. For instance, if you have a template named ‘ID Card’, select it. You will then need to provide a title for the new presentation, which can include dynamic fields from the trigger data, such as the employee’s name.

• Choose the template for the presentation.
• Map the employee’s name and designation from the trigger data.
• Select the Google Drive folder where the presentation will be saved.

After filling in these details, click on ‘Save and Send Test Request’ to create the presentation. This will generate a new presentation in your specified Google Drive folder, ready for the next steps.

4. Uploading Image to Google Slides Presentation

With the presentation created, the next action is to upload an image into the newly created slide. In Pabbly Connect, click on the plus icon to add another action. Again, select Google Slides and choose the action event ‘Upload Image in Presentation’. using Pabbly Connect

Connect using the existing Google Slides connection. You will need to map the presentation ID from the previous step to ensure the image is uploaded to the correct presentation. Additionally, specify the image link from your Google Sheets data, which will be inserted into the slide.

Map the presentation ID from the previous step. Select the position for the image placement (e.g., Center). Map the image link from the trigger data.

After configuring these settings, click on ‘Save and Send Test Request’. This will successfully upload the image to the presentation, completing the first part of the automation.

5. Creating a Copy in Google Drive

The final step involves creating a copy of the presentation in a different Google Drive folder. Add another action in Pabbly Connect, select Google Drive, and choose the action event ‘Copy a File’. This will allow you to duplicate the presentation you just created. using Pabbly Connect

Use the existing connection to Google Drive. Map the presentation ID from the previous step, and select the folder where you want to save the copy. For clarity, you can name the copied file by mapping the employee’s name and adding a suffix like ‘_ID Card Copy’.

Map the presentation ID to specify which file to copy. Select the destination folder for the copied file. Define a clear name for the copied file.

Click ‘Save and Send Test Request’ to create the copy. This action ensures that you have a backup of the presentation, making it easier to manage and share with employees.

Conclusion

In this tutorial, we demonstrated how to automate the creation of Google Slides presentations using Pabbly Connect. By integrating Google Sheets, Google Slides, and Google Drive, you can streamline your workflow and save valuable time. This powerful automation allows for easy management of presentations, enhancing your productivity significantly.