{"product_id":"n8n-workflow-apify-web-scraping-to-google-sheets-leads","title":"n8n Workflow: Apify Web Scraping to Google Sheets Leads","description":"\u003ch3\u003eScrape business leads with Apify and automatically load them into Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e uses \u003cstrong\u003eApify’s Google Places scraping\u003c\/strong\u003e to collect business listings (for any industry and location) and then \u003cstrong\u003ecleans, structures, and saves the results directly to Google Sheets\u003c\/strong\u003e—ready for lead generation, research, and sales outreach.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Start manually or on a schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify configuration:\u003c\/strong\u003e Set scraping parameters such as `industry`, `location`, and the \u003cstrong\u003edata fields\u003c\/strong\u003e you want from each listing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun the scraping job:\u003c\/strong\u003e Executes the Apify scraping execution.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData processing:\u003c\/strong\u003e Cleans and structures the raw output so it fits a consistent format.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDelay built in:\u003c\/strong\u003e A built-in delay ensures scraping completes before data collection begins.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage:\u003c\/strong\u003e Automatically organizes and writes the results into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSales teams:\u003c\/strong\u003e Generate targeted leads for restaurants, contractors, retailers, and more—by city\/region and industry.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarketers:\u003c\/strong\u003e Build lead lists for campaigns using customizable Google Places search parameters.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResearchers:\u003c\/strong\u003e Compile structured business listing datasets for market studies and competitor research.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers \u0026amp; SaaS operators:\u003c\/strong\u003e Reuse a flexible template where parameters can be adjusted per request.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify source:\u003c\/strong\u003e Uses \u003cstrong\u003ecrawler-google-places\u003c\/strong\u003e (Google Maps scraper) by Compass: \u003ca href=\"https:\/\/apify.com\/compass\/crawler-google-places\" target=\"_blank\" rel=\"noopener\"\u003ehttps:\/\/apify.com\/compass\/crawler-google-places\u003c\/a\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ tech stack:\u003c\/strong\u003e Manual trigger (for ready-to-use execution), \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, plus utility nodes such as \u003cstrong\u003ewait\u003c\/strong\u003e and flow helpers like \u003cstrong\u003esplit out\u003c\/strong\u003e and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e Configure your Apify API token via Apify Settings → Integrations → API token, then paste the Apify “\u003cstrong\u003eGet Run URL\u003c\/strong\u003e” endpoint into n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eIf you need an \u003cstrong\u003en8n workflow\u003c\/strong\u003e for \u003cstrong\u003eApify web scraping to Google Sheets\u003c\/strong\u003e, this template is designed to be flexible, parameter-driven, and ready for lead generation.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764354670771,"sku":"N8N-5555","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xIEoIb1tYG1Dk5JmPC06H_SPY8QBKh.png?v=1786008180","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-apify-web-scraping-to-google-sheets-leads","provider":"N8N Commerce","version":"1.0","type":"link"}