Text from Sheets → Duplicate Google Slides slide → Paste text into new slide

Hire a Pro
1

I’m looking for someone to get on a call and show me, come live, how to build this. I want to learn how to use Make, so I’d like that live step by step call.

What I’m trying to accomplish:

Every time a new row is added to a specific Google Sheet, I want the automation to take that text and duplicate a slide in a Google Slides presentation and add that text into the new slide in a specific text box.

4 Likes
3

Hi @rolo1792

image
image1822×1165 216 KB

I can help! I’ve already built similar Google Sheets → Google Slides automations and can demo it live on a call. Book a session on my Topmate : https://topmate.io/prem_patel/

and I’ll:
• Help you in creating new PPT with the slide template
• Map the Sheet row fields into the correct text box
• Show the exact module setup in Make and explain why each step is needed

Best,
@Prem_Patel

4

Hi Rob, @rolo1792

Hope you’re doing well!
How’s the weather in your city today?

Building with Make is not only easy but also pretty fun, especially when you see the magic unfold right before your eyes. I have been working with it for over 5 years, and for the last 3 years I have been building it consistently. It has been a wild ride, from creating simple 2-step processes to handling much more complex and advanced automations. Along the way, I had opportunities to guide others through their workflows, explaining, modifying the logic and flow.

It definitely be an exciting experience working together! As your tutor, will guide you through each stage to make sure everything flows smoothly. The end goal is to build an automation that works smoothly, with every step making sense and feeling intuitive as we build it together.

Here’s the plan:

  1. Clarity on the flow – Start by mapping out your needs.
  2. Building and Iterating – Develop the automation and fine-tune it as we go.
  3. Testing the Flow – Make sure everything works perfectly.
  4. Going Live – Once it’s all set, we’ll launch it into action.

Let me know your availability, and we can schedule the call to get started!

Also, feel free to check out my Fiverr services or connect with me on LinkedIn.

5

Hey Rob!

This Sheets → Slides automation is straightforward once you understand Google’s API requirements. Here’s what you need:

Workflow Structure:
Google Sheets (Watch Rows) → Google Slides (Duplicate Slide) → Google Slides (Replace Text)

Implementation Steps:

1. Google Slides - Get Presentation

  • Get your template presentation ID
  • This loads the slide structure

2. Google Slides - Duplicate Slide

  • Presentation ID: {{1.presentationId}}
  • Object ID: {{[slide_id_to_duplicate]}}
  • Index: Where to insert the new slide

3. Google Slides - Batch Update (for text replacement)

{
  "requests": [{
    "replaceAllText": {
      "containsText": {
        "text": "{{placeholder1}}"
      },
      "replaceText": "{{sheets.column_a}}"
    }
  }]
}

Key Points:

  • Each text placeholder in your template slide needs a unique identifier
  • Use {{placeholder}} format in your template
  • Map each Sheets column to corresponding placeholders
  • For multiple rows, wrap in an Iterator

Common Issue: Google Slides API requires exact object IDs for text boxes. You’ll need to identify these first using the API Explorer.

This typically takes 3-4 hours to set up properly with error handling and testing.

Ready to get this automated? Let’s build it together: Make Discovery Session | Flow Digital

Sam @ Flow Digital