Automated email sending from Google Sheets to Gmail

• Automate customer outreach campaigns using data from Google Sheets.
• Send personalized emails to customers based on specific criteria.
• Update message statuses in Google Sheets after sending emails.
• Filter messages by current date for timely communications.

Trigger the workflow based on a schedule to check for new messages. Retrieve customer messages from Google Sheets. Filter messages based on status and other criteria. Send personalized emails via Gmail to the filtered list. Update the status of sent messages in Google Sheets.

1. 1
   Import the workflow template into n8n.
2. 2
   Connect your Google Sheets and Gmail accounts.
3. 3
   Configure the schedule trigger to define how often to check for new messages.
4. 4
   Set the Google Sheets document and sheet name for retrieving data.
5. 5
   Customize email content and subject in the Gmail node.