Step 2: Connect Google Sheets

These nodes read input lists and later store validation results in Google Sheets.

1. Open Fetch Domain List and set Document to [YOUR_ID] and Sheet to [Input] domain.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Domain List.
3. Open Retrieve Email Prefixes and set Document to [YOUR_ID] and Sheet to [Input] partern.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Email Prefixes.
5. Open Store Output Rows and set Document to [YOUR_ID] and Sheet to [OutPut] emails.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Store Output Rows.

Step 3: Set Up the Email Candidate Assembly and Validation

Combine domains and prefixes, then validate each assembled email address via the external API.

1. Open Assemble Email Candidates and set Mode to combine and Combine By to combineAll.
2. Confirm Fetch Domain List connects to input 1 and Retrieve Email Prefixes connects to input 2 of Assemble Email Candidates.
3. In Validate Email via API, set URL to https://api.emaillistverify.com/api/verifyEmail.
4. Enable Send Query and set the query parameter email to {{ $json.root }}@{{ $json.domain }}.
5. Set Authentication to genericCredentialType and Generic Auth Type to httpHeaderAuth.
6. Credential Required: Connect your httpHeaderAuth credentials in Validate Email via API.
7. Credential Required: Connect your httpQueryAuth credentials in Validate Email via API.
8. Ensure Assemble Email Candidates outputs to both Validate Email via API and Merge Validation Results in parallel.

Step 4: Configure Output Storage

Merge validation responses and append results to the output sheet.

1. Open Merge Validation Results and set Mode to combine and Combine By to combineByPosition.
2. Verify Validate Email via API connects to input 2 of Merge Validation Results and Assemble Email Candidates connects to input 1.
3. In Store Output Rows, keep Operation set to append.
4. Map Email to {{ $json.root }}@{{ $json.domain }} and Status to {{ $json.data }} in Store Output Rows.

Step 5: Test and Activate Your Workflow

Run a manual test to confirm valid output and then enable the workflow for regular use.

1. Click Execute Workflow while viewing Manual Execution Start.
2. Confirm both Fetch Domain List and Retrieve Email Prefixes return items, and that Validate Email via API responds with a status.
3. Verify Store Output Rows appends new rows with Email and Status in the output sheet.
4. When the test is successful, toggle the workflow Active to enable it for production use.