Skip to content
ClickRuntime

Connect Gmail, Google Sheets and Google Slides

Weekly decks are often the same slides with new numbers. With Google Sheets, Google Slides and Gmail in one automation, the numbers flow from the sheet into the deck and the deck goes out by email without anyone rebuilding it.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Workflows

What Gmail, Google Sheets and Google Slides can do together

Each of these is one automation that uses all three apps. Copy a prompt into your assistant and change the details to fit.

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.

One deck per client

On the 1st of each month, create a copy of my Client review deck for each row in my Clients sheet, fill in their numbers, and email it to the account owner in that row.

Certificates from a sign-up sheet

When a row in my Attendees sheet is marked Completed, fill my certificate slide with their name and date, export it as a PDF and email it to them.

Survey replies into a results slide

Each Friday, count the survey replies that came in by email this week, add them to my Survey sheet and update the chart slide in my Results deck.

Use cases

Why people use Gmail, Google Sheets and Google Slides together

  • Weekly metrics deck

    Managers present the same slides every week. The automation copies the deck template, fills in this week's numbers from the sheet and emails the link before the meeting.

  • A deck per client or region

    Account managers need one deck per client. The automation creates a copy for each row in the sheet and sends it to the right owner.

  • Certificates and one-pagers

    Trainers and event teams make a slide for each attendee. The automation fills a Slides template from each row and emails a PDF.

Ready-made ideas

Start from two of the three apps

These automations use two of the apps. Ask your assistant to add the third as an extra step.

Gmail + Google Sheets

Daily

Copy a table from a web page into a sheet every morning

Each morning the listings on a page you choose are added to your Google Sheet, and you get the same rows by email as a CSV.

See how it works
Every 10 minutesAI

Log PDF invoices from Gmail in a spreadsheet

Every invoice that arrives by email is added as a row in your Invoices sheet with supplier, date, number and total.

See how it works
Daily or weeklyAI

Draft a LinkedIn post from your content sheet every weekday

Each weekday you get an email with a ready-to-edit LinkedIn post about the next idea in your Content sheet.

See how it works

Gmail + Google Slides

The moment it happensAI

Email a tailored proposal deck to a client after a sales call

After a call, a proposal is written from your notes, built in your Slides template, turned into a PDF and emailed to the client from your Gmail.

See how it works
The moment it happens

Email a personalised certificate to everyone who passes

Everyone who scores 80% or more gets a PDF certificate with their name, made from your Slides template and emailed from your Gmail.

See how it works
Monthly

Get your monthly report deck by email with the latest numbers

On the 1st of each month, your Slides report template is filled with last month's figures from Google Analytics and the PDF is emailed to you.

See how it works

Google Sheets + Google Slides

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

Build your own

Build any Gmail, Google Sheets and Google Slides automation you can describe

The workflows above are examples. Describe your own steps across Gmail, Google Sheets and Google Slides, plus any other app 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.

Setup

Connect each app once

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

Gmail

Email

  1. At console.cloud.google.com, create a project and enable the Gmail API under APIs & Services → Library.
  2. Set up the OAuth consent screen. On Google Workspace choose Internal. On a personal Gmail account choose External, then under Audience click Publish app so it is In production, not Testing.
  3. Under Data Access, add the scopes you need, such as https://www.googleapis.com/auth/gmail.modify, or gmail.send if you only want to send.
  4. Under Clients, create an OAuth client of type Web application with the redirect URI https://clickruntime.com/oauth/callback.
  5. In the ClickRuntime dashboard, open Connections, choose Gmail and enter the client ID and secret. On a personal account Google shows an unverified-app screen: click Advanced, then go to your app.

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 Gmail, Google Sheets and Google Slides

Does it keep my slide design?
Yes. It copies your Slides template and only replaces the placeholders and charts you name, so your layout stays the same.
Can it send a PDF instead of a link?
Yes. Ask your assistant to export the deck as a PDF and attach it to the email.
Can different people get different decks?
Yes. The automation can make one copy per row and send each copy to the address in that row.

Related pages

Keep exploring

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

Free plan. No credit card.

Add to ChatGPTAdd to Claude