Step 2: Connect Google Sheets

These nodes load input websites and write output email results to Google Sheets.

1. Open Fetch Input Rows and set Document ID to https://docs.google.com/spreadsheets/d/1VOTFM8UeWHhJbtBM7SRca6vsVJlRUXzX71kjJ8n2jUY/edit?gid=0#.
2. Set Sheet Name to Input in Fetch Input Rows.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials to Fetch Input Rows.
4. Open Update Output Sheet and confirm Operation is appendOrUpdate.
5. Set Document ID to https://docs.google.com/spreadsheets/d/1VOTFM8UeWHhJbtBM7SRca6vsVJlRUXzX71kjJ8n2jUY/edit?gid=1538095319#gid=1538095319 and Sheet Name to Output.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials to Update Output Sheet.

Step 3: Set Up URL Normalization and Content Retrieval

This stage prepares URLs and fetches website content for email extraction. Fetch Input Rows outputs to both Ensure URL Scheme and Combine Streams in parallel.

1. Open Ensure URL Scheme to verify the code prepends http:// when a URL is missing a scheme.
2. Open Retrieve Site Content and set URL to ={{ $json.url }}.
3. Open Capture Detected Emails and set the Email array value to ={{$json.data.match(/(?:[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,})/g)}}.
4. Confirm Combine Streams uses Mode combine and Combine By combineByPosition to align fetched content with original rows.

Step 4: Validate Email Presence and Split Emails

Only rows with detected emails move forward, and each email is expanded into its own item.

1. Open Validate Email Presence and confirm the condition checks leftValue ={{ $json.Email }} with the operator lengthGt and rightValue 0.
2. Open Expand Email List and set Field To Split Out to Email.
3. In Expand Email List, set Fields To Include to website and Destination Field Name to email.

Step 5: Configure Domain Enrichment and Email Verification

Rows without detected emails are enriched using domain extraction and the EmailListVerify API.

1. Open Derive Domain From Site to ensure the code extracts the domain from the website field and writes it to domain.
2. Open Query EmailListVerify and set URL to https://api.emaillistverify.com/api/findContact.
3. Set Method to POST and JSON Body to ={ "domain": "{{ $json.domain }}" } .
4. Credential Required: Connect your httpHeaderAuth credentials to Query EmailListVerify.
5. Credential Required: Connect your httpQueryAuth credentials to Query EmailListVerify.
6. Open Derive Domain From Email to ensure the code extracts the domain from the returned email field and writes it to website.

Step 6: Configure Output to Google Sheets

All successful email results—whether scraped or verified—are written to the Output sheet.

1. Ensure Expand Email List connects directly to Update Output Sheet to write detected emails.
2. Ensure Derive Domain From Email also connects to Update Output Sheet to write verified emails.
3. In Update Output Sheet, keep the auto-mapped columns for website, email, and confidence.

Step 7: Test and Activate Your Workflow

Run the workflow end-to-end to confirm data flows from Input to Output.

1. Click Execute Workflow and manually run Manual Run Trigger.
2. Verify that Fetch Input Rows loads website URLs from the Input sheet.
3. Confirm that Update Output Sheet appends rows containing website and email.
4. When results look correct, toggle the workflow to Active for production use.