Social Media & Publishingfree

Automate Personalized Email Campaigns with Google Docs, Sheets and SMTP

by Stéphane HeckelUpdated Aug 2026

Requires

Google Sheets

Google Docs

Email (SMTP)

1/5

STEPS · 13

Runs on a schedule

On a schedule, builds personalized emails from Google Docs templates and Sheets data, and sends them via SMTP.

Stopanderror with YouTube & Schedule

On a schedule, reads an RSS feed and YouTube data, filters new items, and emails the results via SMTP.

On a schedule, reads rows from Google Sheets and posts each as a tweet on X.

On a schedule, reads Google Sheets entries, adds matching YouTube videos to playlists, and notifies via Telegram.