Automated Personalized Email Campaign with Google Sheets and Docs

This n8n workflow automates the process of sending personalized emails to contacts listed in a Google Sheet, using a Google Docs template for email content, and an SMTP server for sending. It is ideal for marketing campaigns, newsletters, or outreach efforts where personalized messaging is needed.

The workflow begins with a schedule trigger that initiates the process at regular intervals. It retrieves contact data from a specified Google Sheet and fetches the email template from Google Docs. Using a combination of set and merge nodes, it dynamically personalizes each email by replacing placeholders with contact-specific information.

The workflow includes a delay node to respect SMTP sending quotas, ensuring emails are sent within provider limits. It then sends each email through an SMTP server, using the email details and message content generated for each contact. After sending, it updates the contact’s row in Google Sheets with the status timestamp.

This automation is useful for continuous outreach, customizable newsletters, or follow-up campaigns where efficiency and personalization are key. It also provides notes and guidelines within the flow, making it easy to adapt for different campaigns and SMTP providers.