Send a weekly YouTube email digest with Apify, OpenAI, Gmail and Sheets

Quick overview

This workflow runs every Monday, reads a YouTube watchlist from Google Sheets, uses Apify to fetch recent video transcripts, summarizes new videos with OpenAI, logs results back to Google Sheets, and sends a single HTML digest email via Gmail.

How it works

1. Runs every Monday morning on a schedule.
2. Reads a list of YouTube channel, playlist, or video URLs from a Google Sheets “Channels” tab.
3. Starts an Apify Actor run to expand the sources, collect recent videos, and fetch available transcripts, then polls Apify until the run succeeds or fails.
4. Filters out videos without transcripts and removes any videos that were already summarized in previous workflow runs.
5. Uses OpenAI to generate a structured summary, key takeaways, topic tags, and a worth-watching verdict for each new video.
6. Appends the video metadata and AI output to a Google Sheets “Videos” tab, builds a combined HTML digest, and sends it to the configured recipient via Gmail.

Setup

1. Create an Apify account, copy your API token, and add an HTTP Header Auth credential using Authorization: Bearer <YOUR_APIFY_TOKEN> for the Apify HTTP requests.
2. Connect Google Sheets OAuth credentials and create a spreadsheet with a “Channels” tab containing a Source column and a “Videos” tab with headers matching the logged fields.
3. Add OpenAI credentials (or update the model node) and set the summaryModel value if you want to use a different model.
4. Connect Gmail credentials and fill in the Google Sheets document ID (sheetDocId) and digest recipient email address (digestRecipient) in the workflow settings.