Verify Google Sheets lead emails with Apify Email Verifier

## Verify a Google Sheets lead list (Email Verifier) ### How it works This workflow manually processes a Google Sheets lead list to verify email addresses. It reads rows that still need verification, filters and batches eligible email addresses, sends them to an Apify email verification actor, then maps the returned verdicts back to the original sheet rows. Finally, it writes the verification results back into Google Sheets. ### Setup steps - Configure Google Sheets credentials for both the read and write nodes. - Make sure your sheet has these columns: email, status, sub_status, score, catch_all, disposable, verified_at. - Create an n8n Header Auth credential named Apify API (Authorization: Bearer ). - Confirm the code nodes reference the correct email, verdict, and row identifier fields from your sheet. ### Customization Adjust the batching logic (BATCH_SIZE = 100), filtering rules, verdict column names, or Apify actor parameters to match your lead list structure and verification requirements.