Automatically Create Google Slides from Google Sheets with Pabbly Connect

Learn how to automatically create Google Slides from Google Sheets using Pabbly Connect. This step-by-step tutorial guides you through the integration process. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Create a Google Sheet for Pabbly Connect Integration

To automatically create Google Slides from Google Sheets, start by setting up a Google Sheet. This sheet will serve as the data source for your Google Slides presentation. Ensure that you include all necessary details such as student names, competition names, and image URLs in separate columns.

Once your Google Sheet is ready, you can proceed to create a template in Google Slides. This template should include placeholders for the data you want to pull from your Google Sheet. Remember, Pabbly Connect will facilitate the transfer of this data into your presentation.

2. Set Up Pabbly Connect for Google Sheets and Google Slides

Next, navigate to Pabbly Connect and log into your account. If you don’t have an account, you can create one for free. Once logged in, click on the ‘Create Workflow’ button and name your workflow, such as ‘Create Slides from Google Sheets Data.’This workflow will act as the bridge between Google Sheets and Google Slides.

Now, select Google Sheets as your trigger application. Choose the event ‘New or Updated Spreadsheet Row’ to initiate the workflow whenever a new row is added or updated in your Google Sheet. This is crucial for Pabbly Connect to know when to start creating a new slide based on the data.

• Log into your Pabbly Connect account.
• Click on ‘Create Workflow’ and name it.
• Select Google Sheets as the trigger application.

After setting up the trigger, copy the webhook URL provided by Pabbly Connect. This URL will be used to connect your Google Sheet to the Pabbly Connect automation. Paste this URL into the Google Sheets add-on settings under the initial setup section. This step ensures that data from your Google Sheets is sent to Pabbly Connect whenever a new row is added.

3. Create Google Slides Presentation Using Pabbly Connect

After establishing the connection, it’s time to create the Google Slides presentation. In Pabbly Connect, select Google Slides as the action application and choose the event ‘Create Presentation from Template.’ This event allows you to generate a new presentation using the template you created earlier.

During this setup, you will be prompted to select the template and specify the title of the new presentation. Use the data from your Google Sheets to create unique titles for each presentation. For instance, you can include the student’s name and competition name in the title to differentiate each slide.

• Select the template you created in Google Slides.
• Map the title using data from your Google Sheets.
• Ensure all fields are correctly mapped to automate the process.

After filling in all required fields, click ‘Save and Send Test Request’ to check if the presentation is created successfully. If everything is set up correctly, you should see a new slide in your Google Drive containing the data from your Google Sheet.

4. Upload Images to Google Slides via Pabbly Connect

Now that your Google Slides presentations are being created automatically, the next step is to upload images. Return to Pabbly Connect and add another action step for Google Slides, selecting the ‘Upload Image’ event. This step allows you to replace the placeholder images in your template with the actual images from your Google Sheets.

In this setup, you will need to specify which presentation to update by mapping the presentation ID from the previous step. Additionally, you will map the image URL from your Google Sheets to ensure the correct images are uploaded to the corresponding slides. This integration is seamless with Pabbly Connect, making it easy to automate the entire process.

Select the presentation in which you want to upload the image. Map the image URL from your Google Sheets. Choose the upload method (e.g., Center Inside).

Once you have configured all fields, click ‘Save and Send Test Request’ again. If successful, your images will be automatically replaced in the Google Slides presentation, completing the automation process.

5. Finalize Your Automation with Pabbly Connect

With the Google Sheets and Google Slides integration complete, you can now automate the entire process. Every time a new row is added to your Google Sheets, a new Google Slides presentation will be created with the specified data and images. This is all made possible through Pabbly Connect, which handles the data transfer and automation seamlessly.

If you want to process multiple entries at once, you can enable the ‘Send All Data’ option in Pabbly Connect. This will allow the automation to create presentations for all existing rows in your Google Sheets, making it a powerful tool for bulk operations.

Before running the bulk process, ensure that your individual automation works correctly. Once confirmed, enabling the bulk option will save you time and effort in creating multiple presentations at once.

Conclusion

In this tutorial, we explored how to automatically create Google Slides from Google Sheets using Pabbly Connect. With the right setup, you can streamline your presentation creation process, saving time and ensuring accuracy. This integration allows for real-time updates, making it a valuable tool for anyone looking to automate their workflows.