Hébergement VPS n8n | Automatisation sécurisée et évolutive
Formation n8n en Français : Automatisation & Agents IA
This workflow reads a list of contacts (first name, last name, company domain) from Google Sheets, sends them to the ScraperCity Email Finder API, waits and polls until the job is done, keeps only the verified emails, asks OpenAI to write one personalized cold-email opening line per contact, writes everything back to Google Sheets, and emails you a run summary.
This course lets you re-build the workflow manually, node by node, live. Everything you need to copy-paste (expressions, JSON body, code, prompts) is in code blocks.
flowchart TD
A["Run email enrichment (Manual)"] --> B["Configuration"]
B --> C["Get contacts from Sheet"]
C --> D["Build contacts payload"]
D --> E["Submit to ScraperCity"]
E --> F["Wait before status check"]
F --> G["Check job status"]
G --> H["Route by job status"]
H -->|completed| I["Download results"]
H -->|stopped| J["Stop - failed/timeout"]
H -->|still processing| F
I --> K["Extract results from CSV"]
K --> L["Normalize result fields"]
L --> M["Keep verified emails"]
M --> N["Generate AI icebreaker"]
N --> O["Save enriched leads to Sheet"]
O --> P["Send run summary email"]
<aside> 🔑
You need 4 credentials in n8n before building: ScraperCity (to create), OpenAI, Google Sheets, Gmail.
</aside>