Find and verify business emails with ScraperCity, OpenAI, Google Sheets, and Gmail

Description

Quick overview This workflow reads contacts from Google Sheets, finds and verifies their business emails via the ScraperCity Email Finder API, generates a short personalized icebreaker with OpenAI, appends the enriched leads to another Google Sheet, and emails a run summary via Gmail. How it works Starts manually to run an email enrichment job. Reads contacts (first name, last name, domain) from an input Google Sheets worksheet and aggregates them into a single payload. Submits the contacts to the ScraperCity Email Finder API, then waits and repeatedly checks the job status until it succeeds or fails/times out. When the job succeeds, downloads the result CSV from ScraperCity, parses it, normalizes key fields (name, domain, email, verification status, provider), and keeps only rows with an email. For each verified contact, prompts OpenAI to generate one short, company-referencing cold-email opening line in the configured language. Appends the enriched lead (including email, status, and icebreaker) to an output Google Sheets worksheet and sends a summary email via Gmail. Setup Create a ScraperCity account with Email Finder credits and add an HTTP Header Auth credential that sends your API key (for example, an Authorization: Bearer header) for the ScraperCity HTTP requests. Connect your Google Sheets OAuth2 credential and select the input spreadsheet/worksheet (contacts) and output spreadsheet/worksheet (leads). Add an OpenAI API credential and confirm the model name in the Configuration values. Add a Gmail OAuth2 credential and set the notification email address, offer text, and any polling limits (wait time and max checks) in Configuration. Ensure your input sheet contains columns named firstName, lastName, and domain. Additional info Find and verify business emails then draft AI icebreakers in Google Sheets Open full documentation on Notion Need help customizing? Contact me for consulting and support : Linkedin MY NEW YOUTUBE CHANNEL 👉 Subscribe to my new YouTube channel. Here I'll share videos and Shorts with practical tutorials and FREE templates for n8n. An n8n automation workflow template by Dr. Firas.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• http-request
• gmail
• code
• basic-llm-chain
• openai-chat-model

Capabilities

• 6 nodes
• 1 views

Information