Step 2: Connect Google Sheets

These nodes read pending rows and update status after sending emails.

1. Open Retrieve Pending Emails and select the spreadsheet with documentId set to [YOUR_ID] and sheetName set to Sheet1 (gid=0).
2. Set a filter in Retrieve Pending Emails to only fetch rows where Email Sent equals No.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Pending Emails.
4. Open Refresh Sheet Rows and set operation to appendOrUpdate.
5. Configure column mappings in Refresh Sheet Rows:
   • Sent on → {{ $now }}
   • Message Id → {{ $json.id }}
   • Email Sent → Yes
   • Email Address → {{ $('Conditional Check').first().json['Email Address '] }}
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Refresh Sheet Rows.

Step 3: Set Up Batching and Conditional Logic

This stage limits records, iterates them one-by-one, and only sends when an email address exists.

1. Connect Retrieve Pending Emails → Cap Records → Batch Item Iterator.
2. In Batch Item Iterator, set batchSize to =1 to process one email at a time.
3. Connect Batch Item Iterator (second output) → Conditional Check.
4. In Conditional Check, set the condition to check that {{ $json['Email Address '] }} exists.
5. After updating the sheet, connect Refresh Sheet Rows → Delay Cycle → Batch Item Iterator to pace sends.
6. Set Delay Cycle amount to 10 (seconds).

Step 4: Configure Email Sending

Send the email via Gmail and optionally via SMTP if you want an alternative dispatch path.

1. Connect Conditional Check → Dispatch Gmail Notice → Refresh Sheet Rows.
2. In Dispatch Gmail Notice, set:
   • sendTo to {{ $json['Email Address '] }}
   • subject to {{ $json['Email Subject'] }}
   • message to {{ $json['Email Body'] }}
   • emailType to text
3. Credential Required: Connect your gmailOAuth2 credentials in Dispatch Gmail Notice.
4. Optional: Configure Utility: SMTP Dispatch Option if you want SMTP sending:
   • text → {{ $json['Email body'] }}
   • subject → {{ $json['Email subject'] }}
   • toEmail → {{ $json['Email Address '] }}
   • fromEmail → {{ $json['Sender email '] }}
   • emailFormat → text
5. Credential Required: Connect your smtp credentials in Utility: SMTP Dispatch Option if you use it.

Step 5: Test and Activate Your Workflow

Verify the end-to-end email dispatch and sheet updates before enabling it in production.

1. Click Execute Workflow to run a manual test from Scheduled Run Trigger.
2. Confirm that Retrieve Pending Emails returns rows with Email Sent = No.
3. Check that Dispatch Gmail Notice sends an email to the value in {{ $json['Email Address '] }}.
4. Verify Refresh Sheet Rows updates the row with Email Sent = Yes, Sent on timestamp, and Message Id.
5. Turn the workflow Active so it runs automatically every 6 hours.