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.

1. 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.

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