Newsletter drafts from videos — by link

The scenario takes video links from таблица, gets the transcript and writes a newsletter draft from it. It saves the draft back and notifies your Send Email.

  • A draft issue from a single link
  • A video transcript turned into an email
  • All drafts collected in таблица
  • A ready-notification to Send Email
Google Sheets
Set it upScriptera

How it works

To get Send Email notifications in Google Sheets, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: Manual Trigger: Start Workflow
  2. Then: Read YouTube Links from Google Sheets
  3. Check: Loop: Process Each YouTube Link
  4. Then: Send Email Notification When Draft is Ready
  5. Then: Dumpling AI: Get YouTube Transcript
  6. Then: GPT-4o: Write Newsletter Draft from Transcript
  7. Then: Log Newsletter Draft to Google Sheets

You can launch this Send Email + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios