Step 2: Connect Google Sheets

These nodes read contacts and log a timestamp after emails are sent.

1. Open Retrieve Contact Sheet and set Document ID to your Sheet ID (replace [YOUR_ID]).
2. Set Sheet Name to Sheet1.
3. In Retrieve Contact Sheet, keep the filter for lookupColumn as Emailed.
4. Open Log Email Timestamp and set Operation to update.
5. In Log Email Timestamp columns mapping, set Emailed to {{ $now }} and row_number to {{ $('Retrieve Contact Sheet').item.json.row_number }}.
6. Credential Required: Connect your Google Sheets credentials in both Retrieve Contact Sheet and Log Email Timestamp.

Step 3: Set Up Contact Filtering and Batching

This limits your daily outreach and skips rows without valid emails.

1. In Cap Ten Recipients, set Max Items to 10.
2. In Verify Email Field, ensure the condition checks for a non-empty email using {{$json["Email"]}}.
3. Connect the false path of Verify Email Field to Bypass Invalid Entry for invalid rows.
4. Use Iterate Contacts to process one contact per loop from the valid path.

Step 4: Configure AI Email Generation

The AI agent writes the outreach email using the OpenAI model.

1. In Compose Outreach Email, set the Text field to =Write a friendly email to {{ $json['First Name'] }} Refer to System message for Context .
2. Keep the System Message exactly as defined for healthcare outreach and the medical joke template.
3. Ensure OpenAI Chat Engine is connected as the language model for Compose Outreach Email (AI sub-node).
4. Credential Required: Connect your OpenAI credentials in OpenAI Chat Engine.

Step 5: Map Email Fields and Send Messages

This step prepares the email payload and sends it through Gmail.

1. In Map Email Fields, set Email to {{ $json.Email }}.
2. Set First Name to {{ $json['First Name'] }}.
3. Set EmailContent to {{ $node["Compose Outreach Email"].json["output"] }}.
4. In Dispatch Email Notice, set Send To to {{ $('Retrieve Contact Sheet').item.json.Email }}.
5. Set Subject to Medical joke of the day and Message to {{ $json.output }}.
6. Credential Required: Connect your Gmail credentials in Dispatch Email Notice.

Step 6: Add Delay and Parallel Logging

After each email, the workflow waits, then updates the sheet and proceeds to the next contact.

1. In Staggered Delay 2-5m, set Unit to minutes.
2. Set Amount to {{ Math.floor(Math.random() * 4) + 2 }} to randomize the delay.
3. Staggered Delay 2-5m outputs to both Iterate Contacts and Log Email Timestamp in parallel.

Step 7: Test and Activate Your Workflow

Run a manual test to verify the email content, delivery, and sheet updates before going live.

1. Click Execute Workflow to run a manual test.
2. Confirm that Dispatch Email Notice sends an email to the row’s address and includes the AI-generated body.
3. Check Log Email Timestamp updates the Emailed column with a timestamp.
4. Once verified, switch the workflow to Active so Daily Schedule Trigger runs it automatically.