How to Create Google Slides from Google Sheets in Bulk Automatically Using Pabbly Connect

Learn how to automate the creation of Google Slides from Google Sheets in bulk using Pabbly Connect. This step-by-step tutorial guides you through the process.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Slides Automation

To create Google Slides in bulk automatically from Google Sheets, you first need to set up Pabbly Connect. This integration platform simplifies the process of connecting various applications. Start by logging into your Pabbly Connect account or create a new one if you haven’t done so yet.

Once logged in, navigate to your dashboard and click the blue button to create a new workflow. Name your workflow something like ‘Create Google Slides in Bulk from Google Sheets’ and select the folder where you want to save it.

2. Setting Up the Trigger with Google Sheets

The next step is to set up the trigger in Pabbly Connect. For this automation, choose Google Sheets as your trigger application. Select the trigger event as ‘New or Updated Spreadsheet Row’. This means every time you add or update a row in your Google Sheets, it will trigger the action to create Google Slides.

• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.
• Copy the webhook URL provided by Pabbly Connect.
• Go to your Google Sheets, click on Extensions > Add-ons > Get add-ons, and install the Pabbly Connect Webhooks add-on.

After installing the add-on, go back to your Google Sheets, click on Extensions again, and find the Pabbly Connect add-on. In the initial setup, paste the copied webhook URL and specify the trigger column. This column will determine when the automation is triggered.

3. Setting Up the Action to Create Google Slides

After configuring the trigger, it’s time to set up the action in Pabbly Connect. Select Google Slides as your action application and choose the action event ‘Create Presentation from Template’. This will allow you to create a new slide presentation based on your Google Slides template.

You will need to connect your Google account to Pabbly Connect if you haven’t done so already. Once connected, select the template you created earlier. The variables you set in your template will appear as fields in Pabbly Connect.

• Select Google Slides as the action application.
• Choose ‘Create Presentation from Template’ as the action event.
• Map the fields from your Google Sheets data to the corresponding variables in your Google Slides template.

This mapping allows Pabbly Connect to replace the variables in your template with the actual data from your Google Sheets, creating personalized slides automatically.

4. Inserting Dynamic Images into Google Slides

To enhance your presentations, you can also insert dynamic images into your Google Slides using Pabbly Connect. After creating the slides, add another action in Pabbly Connect by selecting Google Slides again. This time, choose the action ‘Upload Image in Presentation’.

Connect to your Google account again if prompted, and then specify the presentation ID of the slide you just created. You can map the image URL from your Google Sheets data to insert specific images into your presentations.

Select Google Slides as the action application for image upload. Choose ‘Upload Image in Presentation’ as the action event. Map the image URL from your Google Sheets data to the corresponding field.

This process ensures that each Google Slide presentation not only contains personalized text but also relevant images, making your presentations visually appealing.

5. Finalizing Your Automation in Pabbly Connect

Once you have set up all the actions, it’s essential to test your workflow to ensure everything is working correctly. In Pabbly Connect, you can send test data to check if the Google Slides are being created as expected. Make sure to enable the ‘Send on Event’ option for real-time automation.

If the test is successful, your automation is ready to go! Every time you add new data to your Google Sheets, Pabbly Connect will automatically create Google Slides presentations in bulk without any manual effort required.

To summarize, by using Pabbly Connect, you can seamlessly integrate Google Sheets and Google Slides, allowing for efficient bulk creation of presentations. This automation saves time and enhances productivity, making it a valuable tool for anyone needing to create presentations from spreadsheet data.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to create Google Slides from Google Sheets in bulk automatically. This process streamlines your workflow and enhances productivity by eliminating manual tasks.