Daily

Get a sourced daily news digest, saved to a sheet

Each morning Perplexity researches the latest news on your topic; you get the digest by email and every day is logged in your sheet.

Runs: Daily
Apps: Google Sheets, Perplexity
AI: Not needed
Access: Perplexity key; Sheets write

Send this to your assistant

Create a ClickRuntime automation: every morning at 7, ask Perplexity for the top news on AI in retail from the last 24 hours with sources, add it to my News sheet and email me the digest.

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

Keeping up with a fast-moving field means checking several sites every morning, and still missing the story that mattered. A digest helps, but most newsletters are someone else's selection, a day late, without a record you can search.

Analysts, founders and consultants use it to start each day with a short, sourced summary of their own topic, and to build a searchable history of what happened when.

What you get out of it

Your topic, not someone else's
You decide exactly what the digest covers, down to the industry and region.
Sources you can check
Every digest lists the pages behind it, so you can open the original before quoting it.
A history you can search
Each day becomes a row, so you can look back at what was said about a company or trend weeks ago.
Ready before your first coffee
The email arrives at a set time, so the news comes to you.

How it works

What happens, step by step

Every morning, ClickRuntime asks Perplexity for the main news on your topic from the last 24 hours.
Perplexity returns a short summary with the sources it used.
The summary and links are added as a new row in your sheet.
You get the same digest by email.

Before it runs live

Connect your Google Sheets account and pick the spreadsheets it may use
Connect Perplexity

What you get

RunsDaily

Get a sourced daily news digest, saved to a sheettoday, 9:00Succeeded

Email · Morning digestAI in retail: today's digest • Northwind Grocers pilots AI shelf restocking in 40 stores • Acme Retail adds AI sizing to its app

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

Run it at a different time, more or less often, or only on weekdays
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 Sheets and Perplexity 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.

daily_ai_news_digest_logged_to_a_sheet.pyexample

from datetime import date
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, notify

SHEET_ID = "your-spreadsheet-id"
TOPIC = "AI in retail"

def sonar(prompt):
    r = http.post("https://api.perplexity.ai/chat/completions", headers={"Authorization": f"Bearer {credentials.secret('PERPLEXITY_API_KEY')}"},
                  json={"model": "sonar", "messages": [{"role": "user", "content": prompt}]}, timeout=90).json()
    return r["choices"][0]["message"]["content"], [s["url"] for s in r.get("search_results", [])]

@on_trigger
def run(event):
    text, links = sonar(f"What are the most important news stories about {TOPIC} from the last 24 hours? "
                        "Five short bullets, each with the company or organisation named.")
    build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
        .spreadsheets().values().append(spreadsheetId=SHEET_ID, range="News!A:D", valueInputOption="RAW",
                                        body={"values": [[date.today().isoformat(), TOPIC, text, "\n".join(links)]]}).execute()
    notify.email_me(f"{TOPIC}: today's digest", text + "\n\nSources:\n" + "\n".join(links))
    return {"sources": len(links)}

FAQ

Common questions

Can I follow several topics?

Yes. List the topics and each gets its own section in the email and its own row in the sheet.

How long is the digest?

About five short bullet points per topic by default. Ask for more or fewer when you set it up.

Can I get it at the weekend?

Yes. Choose weekdays only or every day, at the time that suits you.

What permissions does it need?

Perplexity key; Sheets 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 each time it runs (daily). Checks that find nothing to do and stop right away aren't counted.

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.

DailyAI