# Enrich leads from Google Sheets with ScraperCity: n8n workflow > Started by an event in a connected app, and works across Google Sheets. 38 steps, 3 branches, 9 loops or waits: large, and worth reading before you trust it... Source: https://millionrounds.com/workflow/enrich-leads-from-google-sheets-with-scrapercity (Millionrounds; every figure on the page links to its filing or article) [Automation library](https://millionrounds.com/workflows) · [Lead generation](https://millionrounds.com/workflows?category=Lead+generation#library) # Enrich leads from Google Sheets with ScraperCity Started by an event in a connected app, and works across Google Sheets. 38 steps, 3 branches, 9 loops or waits: large, and worth reading before you trust it with anything live. Large [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fenrich-leads-from-google-sheets-with-scrapercity) **38 steps** Large: read it before trusting it with anything live **3** Branches: places the flow splits **9** Loops or waits **1** Service it connects to ## The flow Starts it 1 Logic 26 Service 11 The steps in the order they run, from what starts it. - 1 **Start Enrichment** Manual trigger *Starts it* - 2 **Configure Workflow** Set *Logic* - 3 **Read Contacts from Sheet** Google Sheets *Service* - 4 **Format Contacts for Email Finder** Code *Logic* - 5 **Start Email Finder Job** Http Request *Service* - 6 **Store Email Finder Run ID** Set *Logic* - 7 **Wait Before Checking Email Finder** Wait *Logic* - 8 **Poll Email Finder Loop** Split In Batches *Logic* - 9 **Check Email Finder Status** Http Request *Service* - 10 **Is Email Finder Complete?** If *Logic* - 11 **Download Email Finder Results** Http Request *Service* - 12 **Wait Before Next Email Finder Poll** Wait *Logic* - 13 **Parse Email Finder CSV** Code *Logic* - 14 **Remove Duplicate Emails** Remove Duplicates *Logic* - 15 **Filter Valid Emails Only** Filter *Logic* - 16 **Format Emails for Mobile Finder** Code *Logic* - 17 **Start Mobile Finder Job** Http Request *Service* - 18 **Store Mobile Finder Run ID** Set *Logic* - 19 **Wait Before Checking Mobile Finder** Wait *Logic* - 20 **Poll Mobile Finder Loop** Split In Batches *Logic* - 21 **Check Mobile Finder Status** Http Request *Service* - 22 **Is Mobile Finder Complete?** If *Logic* - 23 **Download Mobile Finder Results** Http Request *Service* - 24 **Wait Before Next Mobile Finder Poll** Wait *Logic* - 25 **Parse Mobile Finder CSV** Code *Logic* - 26 **Format Emails for Validator** Code *Logic* - 27 **Start Email Validator Job** Http Request *Service* - 28 **Store Validator Run ID** Set *Logic* - 29 **Wait Before Checking Validator** Wait *Logic* - 30 **Poll Validator Loop** Split In Batches *Logic* - 31 **Check Validator Status** Http Request *Service* - 32 **Is Validator Complete?** If *Logic* - 33 **Download Validator Results** Http Request *Service* - 34 **Wait Before Next Validator Poll** Wait *Logic* - 35 **Parse Validator CSV** Code *Logic* - 36 **Prepare Merge Inputs** Set *Logic* - 37 **Merge All Enrichment Data** Code *Logic* - 38 **Write Enriched Leads to Sheet** Google Sheets *Service* ## How it's built - **Starts on:** An event in a connected app - **Steps:** 38, with 3 branches, 9 loops or waits - **Size:** Large: read it before trusting it with anything live - **Connects to:** Google Sheets - **Model:** None. This is plumbing, not judgement ## Questions What does it need to run? An n8n account, plus your own Google Sheets account. You connect your own accounts after importing it; none are included. What starts it? It starts on an event in a connected app. Does it use AI? No. Every step is fixed logic or a call to a service, so it does the same thing every time. How long does it take to set up? Take your time. At 38 steps it is large: read it before trusting it with anything live. How do I import it? Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts. **Before you run it** Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 38 steps before you point it at anything that matters. ## Run it in n8n - **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n) - **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fenrich-leads-from-google-sheets-with-scrapercity) - **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts. Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind. ## Connects to Each opens the other workflows that use it. [Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library) ## Workflows like it Also lead generation, with the same services where possible, closest in size first. - [**Generate B2B Leads with SerpAPI** 38 steps · calls a model · Google Sheets](https://millionrounds.com/workflow/generate-b2b-leads-with-serpapi) - [**Speed-to-Lead AI Response Engine for WhatsApp, Web Forms** 37 steps · Email, Google Sheets](https://millionrounds.com/workflow/speed-to-lead-ai-response-engine-for-whatsapp-web-forms) - [**Speed-to-Lead AI Response Engine for WhatsApp, Web Forms, Chat** 37 steps · Email, Google Sheets](https://millionrounds.com/workflow/speed-to-lead-ai-response-engine-for-whatsapp-web-forms-chat) - [**Automated website audit & personalized outreach** 39 steps · calls a model · Google Sheets](https://millionrounds.com/workflow/automated-website-audit-and-personalized-outreach) - [**Capture and score multi-channel leads with Gmail** 39 steps · calls a model · Gmail, Google Sheets](https://millionrounds.com/workflow/capture-and-score-multi-channel-leads-with-gmail) - [**Generate leads with Google Maps** 36 steps · Google Sheets](https://millionrounds.com/workflow/generate-leads-with-google-maps)