The moment it happens

Fill a report deck with this week's numbers

A fresh copy of your report deck arrives with this week's figures in place, and you get the link by email.

Runs: The moment it happens
Apps: Google Slides
AI: Not needed
Access: read+write

Send this to your assistant

Create a ClickRuntime automation: give me a link I can post week and revenue values to; copy my Weekly Report template deck, replace {{week}} and {{revenue}} with those values, and email me the link.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Add to ChatGPT Add to Claude

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

Every Monday a finance analyst or account manager opens last week's report deck, saves a copy, and retypes the figures: revenue, new signups, churn, tickets closed. The slide that says 4,120 users still says 4,120 on Tuesday because someone forgot one placeholder, and a client or board member notices the mismatch before the author does. The work is dull and the errors are embarrassing.

Your deck holds placeholders such as {{revenue}} or {{signups}}. When another system or script sends the values to the trigger link, every placeholder in the Google Slides presentation is swapped for the new number using a text replacement across all slides at once, and you receive an email with the link to the finished deck.

It is useful for weekly business reviews, client status reports and any recurring presentation where the layout never changes but the figures do.

What you get out of it

Figures on every slide agree with each other
Because one replacement pass covers the whole presentation, the revenue on slide 2 and the revenue in the footer on slide 9 cannot disagree. Inconsistent numbers are what make readers distrust a report.
The weekly deck is ready before the meeting starts
The values arrive when the data is ready, and the link lands in your inbox. You open a finished deck instead of spending Monday morning copying numbers from a dashboard.
Retyping errors disappear
A transposed digit or a forgotten placeholder is the usual way a report ends up wrong. Numbers go straight from the source into the slide text with no hand in between.
The design stays exactly as you built it
Only the placeholder text is replaced, so fonts, charts, branding and layout are untouched. A designer can polish the template once and everyone benefits every week. A designer can polish the template once and everyone benefits every week.
Reports become a repeatable routine
Once the template exists, adding a client means sending that client's values to the same link. A task that took an hour per deck becomes something nobody has to remember to do.

How it works

What happens, step by step

When this week's figures, such as the week name and revenue, are sent to your ClickRuntime link, the automation starts.
It makes a fresh copy of your Google Slides report template and names it after the week.
Every placeholder in the copy is replaced with the new figures.
You get an email with a link to the finished deck.

Before it runs live

Connect Google Slides
Paste your automation's link into the other app's webhook settings

What you get

RunsThe moment it happens

Fill a report deck with this week's numbersjust nowSucceeded

Email · Weekly Report - Week 42 is readyhttps://docs.google.com/presentation/d/1x9…/edit

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. 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.

Changes you can ask for

Act only on the items that match your own rules, and skip the rest
Add an AI step, for example to summarize, sort or draft a reply
Add another app, for example also send it to Slack
Combine it with other Google Slides steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.

refresh_numbers_in_a_template_deck.pyexample

from clickruntime import on_event, credentials, http, notify

TEMPLATE_ID = "1AbCdEfGhIjKlMnOpQrStUvWxYz"  # Weekly Report template deck

@on_event
def handle(event):
    data = event.json or {}
    week, revenue = data.get("week"), data.get("revenue")
    if not week or revenue is None:
        return {"error": "send week and revenue"}
    headers = {"Authorization": f"Bearer {credentials.connection('google', 'work')}"}
    copy = http.post(f"https://www.googleapis.com/drive/v3/files/{TEMPLATE_ID}/copy", headers=headers,
                     json={"name": f"Weekly Report - {week}"}).json()
    requests = [{"replaceAllText": {"containsText": {"text": "{{" + k + "}}", "matchCase": True},
                                    "replaceText": str(v)}} for k, v in (("week", week), ("revenue", revenue))]
    resp = http.post(f"https://slides.googleapis.com/v1/presentations/{copy['id']}:batchUpdate",
                     headers=headers, json={"requests": requests})
    resp.raise_for_status()
    link = f"https://docs.google.com/presentation/d/{copy['id']}/edit"
    notify.email_me(f"Weekly Report - {week} is ready", link)
    return {"deck": copy["id"]}

FAQ

Common questions

Does it edit my original deck or a copy?

It replaces text in the presentation you point it at. For recurring reports, most people keep a master template and have the workflow work on a copy, so last week's version survives. Ask your AI assistant to copy the template first if you want that.

What format do the placeholders need?

Any unique text string works, though double braces like {{revenue}} are easiest because they are unlikely to appear in normal slide copy. Each placeholder is replaced everywhere it appears, including speaker notes only if you set that up.

What sends the values to the link?

Anything that can make a web request, such as a spreadsheet script, a BI tool, a billing system or another workflow. The request carries the values, and the deck is updated when it arrives, with no schedule involved.

What permissions does it need?

read+write. Nothing else in your accounts is used.

Does it need AI?

No. It runs without AI, so it doesn't use your plan's AI allowance.

How many runs does it use?

One run for each event the app sends.

Can I change how it works?

Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

The moment it happens