Weekly
Get a weekly email summary of your edited Google Docs
Every Friday you get one email summarising what changed in your Google Docs this week, with the action items pulled out.
- Runs
- Weekly
- Apps
- Gmail, Google Docs
- AI
- Yes, uses the built-in AI allowance
- Access
- Docs read; Gmail gmail.send
Send this to your assistant
Create a ClickRuntime automation: every Friday, summarise the Google Docs edited this week in my Notes folder and email me the key points and actions.
First time? Adding ClickRuntime to your assistant takes about two minutes.
Why use it
Why teams use this automation
A team lead keeps meeting notes, project plans and one-to-one notes in a shared Google Drive folder. During the week several people edit them, and action items written in a doc on Tuesday are forgotten by Thursday. Reopening every document on Friday to see what changed takes longer than anyone has.
This automation looks at the docs in your folder that were edited during the week, has AI summarise each one and pull out the tasks, and sends you a single email on Friday. You start the next week knowing what moved and what you owe.
What you get out of it
Action items do not get lost
Tasks buried in the middle of notes are pulled out and listed together. You can copy them into your task list in a minute instead of hunting through documents.
One read instead of many
A short summary per document replaces opening each one. You see quickly which docs need a closer look and which only had small edits.
A natural weekly review
Friday's email is a ready agenda for reviewing the week. It works as a prompt to close loops before the weekend.
Covers what others changed too
Edits by colleagues in shared docs are included. You notice new decisions or questions even when nobody told you about them.
How it works
What happens, step by step
Every Friday, ClickRuntime finds the Google Docs in your folder that were edited in the past week.
It reads the text of each one.
AI writes a short summary of each document and lists any action items.
You receive one email with all the summaries and actions.
Before it runs live
- Connect Google through your own Google app (a one-time, 10-minute setup), so it works with your own Gmail
- Connect Google Docs
What you get
Build your own
Need it to work differently?
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
- Change what the AI looks for, or how it writes the result
- Add another app, for example also send it to Slack
- Combine it with other Gmail and Google Docs steps into one automation
Under the hood
The code that runs this automation
from datetime import datetime, timedelta, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, ai, notify
FOLDER_ID = "your-folder-id"
@on_trigger
def run(event):
creds = Credentials(credentials.connection("google", "work"))
since = (datetime.now(timezone.utc) - timedelta(days=7)).strftime("%Y-%m-%dT%H:%M:%S")
files = build("drive", "v3", credentials=creds, cache_discovery=False).files().list(
q=f"'{FOLDER_ID}' in parents and mimeType='application/vnd.google-apps.document' and modifiedTime > '{since}'",
fields="files(id,name,modifiedTime)").execute().get("files", [])
if not files:
return {"docs": 0}
docs = build("docs", "v1", credentials=creds, cache_discovery=False).documents()
parts = []
for f in files[:15]:
body = docs.get(documentId=f["id"]).execute()["body"]["content"]
text = "".join(r["textRun"]["content"] for c in body for r in c.get("paragraph", {}).get("elements", []) if "textRun" in r)
parts.append(f"## {f['name']}\n{text[:3000]}")
try:
digest = ai.generate("\n\n".join(parts), system="For each document give a 2-line summary, then list all action items with owners.", max_output_tokens=1500).text
except ai.AIError:
digest = "Edited this week:\n" + "\n".join(f["name"] for f in files)
notify.email_me("Weekly docs digest", digest)
return {"docs": len(files)}FAQ
Common questions
Which documents are included?
Can it send the digest to my team instead?
Will very long documents be summarised fully?
What permissions does it need?
Does it need AI?
How many runs does it use?
Can I change how it works?
Related
You might also like
Write a daily email digest into a Google Doc
Every evening, a short summary of the day's email is added to the top of a running Google Doc.
See how it worksTurn repeated support questions into FAQ drafts
Each week, the questions customers keep asking are grouped and added to your FAQ doc with draft answers ready to edit.
See how it worksDraft RFP answers in a Google Doc when one arrives by email
When an RFP lands in Gmail, every question in it is answered in a draft Google Doc and you get an email with the link.
See how it worksKeep exploring
Set up “Get a weekly email summary of your edited Google Docs” from your assistant
Copy the prompt above, or connect your assistant first. Free plan, no credit card.