Send personalized emails from Google Sheets via SMTP

What problem does this solve?

This workflow automates sending personalized emails using a contact list stored in Google Sheets and a professional SMTP email account.

It removes manual work such as identifying who should receive an email, filtering no-show or specific leads, avoiding duplicate sends, and updating records after emails are sent. The entire process runs automatically in a controlled and repeatable way.

This is useful when you want to send targeted emails without using a full email marketing platform.

How this workflow operates

This workflow works with any type of email list stored in Google Sheets and sends emails based on conditions you define.

No-show workshop or webinar attendees Mark contacts as No-Show in the sheet and the workflow will send personalized follow-up emails only to those contacts.

Cold email lists Use the same workflow for cold outreach by adjusting the filter condition (for example, status = “Cold”).

Old or re-engagement lists Re-engage inactive contacts by updating their status (for example, “Re-engage” or “Inactive”) and running the workflow.

Custom filtering logic The filter conditions can be customized to match any column value (status, tag, campaign, or label), giving you full control over who receives emails.

In all cases, emails are sent one by one, duplicate sends are prevented, and Google Sheets is updated after each successful send.

What does it do?

Fetches contact data from Google Sheets

Processes contacts one by one to ensure safe delivery

Filters contacts based on a no-show or custom status

Checks whether an email has already been sent

Sends personalized emails via SMTP

Adds a delay between emails to respect provider limits

Updates Google Sheets to mark emails as sent

Key features

Google Sheets–based contact management

SMTP email sending (works with any professional provider)

No-show and status-based filtering

Built-in duplicate email prevention

Configurable delay between emails

Beginner-friendly and easy to customize

No external email marketing tools required

Ideal for

Marketers sending follow-ups or reminders

Sales teams running targeted outreach

Coaches and course creators following up with attendees

Founders and small teams managing email outreach via spreadsheets

Anyone who wants simple, rule-based email automation