Automated Email Pattern Extraction and Verification Workflow

This n8n workflow streamlines the process of extracting, constructing, and verifying email addresses from a Google Sheet list. Triggered manually, it begins by retrieving rows with a ‘FALSE’ status, indicating unresolved entries. The workflow then scrapes website snippets using Serper.dev to identify common email patterns at each domain. Using AI-powered analysis via OpenRouter, it constructs potential email addresses based on the detected pattern and personal details like first and last names. The constructed emails are verified through the Prospeo API, which assesses deliverability and risk. Finally, the workflow updates the Google Sheet with the new email, pattern, confidence level, and verification status, completing the cycle. This automation is especially useful for sales, recruitment, and outreach teams aiming to enhance contact accuracy efficiently.