Save and recall article and video summaries via Telegram

Summarizes any YouTube video or article you save and lets you pull up past summaries by asking a Telegram bot.

How the work actually flows

It branches. Exactly one path is taken.

Pattern: Exclusive Choice (4) · Simple Merge (5)

flowchart TD trig[\"new link added to sheet"\]:::trigdata s0["detect link type"]:::task s1["ai writes summary"]:::svc s2[("save summary to sheets")]:::store trig --> s0 s1 --> s2 gx{"× video or article link"}:::gate s0 --> gx p00["retrieve video transcript"]:::task gx -->|"video link"| p00 p10["retrieve webpage content"]:::task gx -->|"article link"| p10 jn{"○ content retrieved"}:::gate p00 --> jn p10 --> jn jn --> s1 out[/"searchable summary saved and retrievable"/]:::out pay{{"turns saved links into usable knowledge"}}:::pay s2 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceA record or sheetOne path onlyPaths rejoinResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
AI Agents & Autonomous SystemsSpreadsheet & Database Ops
Connects
Google SheetsGoogle GeminiTelegramApify

The problem it solves

You save interesting videos and articles meaning to read or watch them later, but they pile up and you never get back to most of them. When you do remember something useful you read weeks ago, there's no easy way to find it again.

Who it fits

Anyone building a personal reading list or research habit who wants quick, searchable summaries instead of a pile of unread links.

How it works

  1. Starts when you add a new YouTube or article link to a Google Sheet
  2. Detects whether the link is a video or an article
  3. Retrieves the transcript or webpage content automatically
  4. AI writes a concise summary and saves it to Google Sheets
  5. Lets you ask a Telegram bot for past summaries whenever you need them
What you get

Summaries you can recall anytime

You save any article or video and get a concise summary you can pull up again anytime through a quick chat.

What you get

A searchable library of saved summaries, plus instant answers through a Telegram chat.

What you need

A Google account for Sheets, a Google Gemini API key, an Apify account for video transcripts, and a Telegram bot.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Clean and deduplicate scraped sales leads automatically

Validates, cleans, and deduplicates scraped leads with AI before adding them to your spreadsheet.

Advanced

Turn a Telegram message into a designed resume image

Chats with you on Telegram and turns your resume details into a professionally designed image.

Advanced

Find LinkedIn leads and draft personalized outreach messages

Searches for LinkedIn profiles matching your target roles and drafts a personalized message for each one.

Standard

Automatically write and publish Thai-language articles

New entries in a spreadsheet trigger AI to write a Thai article, generate an image, and publish it, then notify you.

Advanced
Back to the AI Playbook