Skip to content
ClickRuntime

Connect Google Sheets to Google Slides

Sheets hold the data, Slides tell the story. Connecting them turns rows into personalised decks and sheet totals into report slides, so the numbers in your presentations always come from the same place.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Google Slides

Decks built from sheet rows and report slides filled from sheet data. These are ready-made starting points. Anything else you can describe works too.
Every 15 minutes

Make a personalised deck for every new row in your sheet

Each prospect or client row without a deck link gets its own copy of your Slides template with their details filled in, and the link is written back to the sheet.

See how it works
On a schedule

Fill your monthly report deck from your metrics sheet

On the 1st of each month, the totals in your Metrics sheet are written into a fresh copy of your Slides report and you get the link by email.

See how it works
Every 30 minutesAI

Turn topics in your content sheet into carousel slides

Each new topic you add to your content sheet becomes a 6-slide carousel written by AI in a copy of your Slides template, with the link written back.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and Google Slides, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Google Slides automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Google Slides in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Replace the chart image only when the sheet's numbers have changed since last month.

Skip rows with an empty "price" column and write "missing price" in the status column.

Use cases

Why people connect Google Sheets and Google Slides

How the two apps work together

  • A check every few minutes finds new or ready rows, or a schedule runs monthly.
  • The script copies a Slides template and replaces placeholders with column values.
  • It writes the deck link back to the row.

  • Marketing teams producing monthly reports

    Numbers from a sheet are inserted into a Slides template each month. Reports are ready on the first.

  • Sales teams making quotes

    Each row becomes a personalised deck with prices. Quotes are consistent.

  • Social teams creating carousels

    Topics and text in a sheet become carousel slides. Content production is faster.

  • Event teams making badges

    Attendee rows become name badges in one deck. Printing is simple.

More apps

Google Sheets, Google Slides and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Save to client folders

For each row, create the deck and save it in the client's Google Drive folder named in the row.

Email the deck

After each deck is made from a row, email the PDF from Gmail to the address in the row.

Monthly report ready

When the monthly report deck is created from my sheet, post the link to #marketing.

Fill the weekly deck and email it

Every Monday at 8 am, copy my Weekly review deck, replace the placeholders with this week's numbers from my Metrics sheet, and email the link to my team.

More with these apps

Setup

Connect Google Sheets and Google Slides once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Google Slides

Presentations

  1. At console.cloud.google.com, enable the Google Slides API in your project. Enable the Google Drive API too if the automation copies template decks.
  2. Under IAM & Admin → Service Accounts, create a service account and add a JSON key.
  3. Share the template presentation, or the folder it's in, with the service account's email as Editor.
  4. In the ClickRuntime dashboard, save the JSON key as a secret on Connections & secrets.

FAQ

Questions about connecting Google Sheets and Google Slides

How do I mark where data goes?
Put placeholders like {{company}} in your Slides template that match column names in your sheet.
Can it update charts?
Charts linked from Google Sheets can be refreshed, and text placeholders are replaced with the latest values.
Will it make the same deck twice?
No. The deck link is written back to the row, and rows that already have one are skipped.
Where are the decks saved?
In the Drive folder you choose, owned by your connected Google account.
Can it refresh linked charts?
Yes. Charts linked from Google Sheets can be refreshed through the Slides API.
Can it add rows as table rows in a slide?
Yes. The script can fill a table on a slide from several rows.
Can it make one deck with many slides?
Yes. It can add one slide per row in a single deck.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Google Slides should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude