{"product_id":"google-maps-no-website-lead-list-automation-with-apify-sheets","title":"Google Maps No-Website Lead List Automation with Apify + Sheets","description":"\u003ch3\u003eAutomate Google Maps lead sourcing for businesses with no website—weekly, sorted, and delivered to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically finds Google Maps places in your chosen categories and location, filters out any listings that already have a website, and appends the best prospects to Google Sheets every Monday morning—prioritized by review count.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a schedule:\u003c\/b\u003e set to execute every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSearches Google Maps using your inputs:\u003c\/b\u003e you define the search terms (categories), the location (area), and a maximum results-per-term (with a minimum of 20).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches places from Apify:\u003c\/b\u003e it uses Apify’s \u003cb\u003eGoogle Maps Places API\u003c\/b\u003e actor (the workflow is configured to run the \u003cb\u003ejohnvc~google-maps-places-api\u003c\/b\u003e actor).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFilters to “no-website” leads:\u003c\/b\u003e it keeps only businesses where the Google Maps listing has an \u003cb\u003eempty website field\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFormats clean call-sheet rows:\u003c\/b\u003e it outputs key lead fields such as \u003cb\u003erating, review count, address, phone\/no-phone flag\u003c\/b\u003e, and a \u003cb\u003eGoogle Maps place link\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRanks and prioritizes:\u003c\/b\u003e it sorts leads by \u003cb\u003ereview count (descending)\u003c\/b\u003e so the most established prospects appear first.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAppends to Google Sheets:\u003c\/b\u003e it writes the sorted leads into your selected spreadsheet and sheet as a call sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eLocal service outbound:\u003c\/b\u003e generate leads for plumbers, contractors, clinics, or other categories in a specific city\/area.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAutomation engineers:\u003c\/b\u003e build repeatable lead pipelines using n8n + Apify + Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSaaS operators:\u003c\/b\u003e maintain weekly prospect lists without manual scraping or spreadsheet cleanup.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e \u003cb\u003eApify\u003c\/b\u003e (Google Maps Places API actor), \u003cb\u003eGoogle Sheets\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSetup required:\u003c\/b\u003e add your Apify API token in n8n and connect Google Sheets credentials for the append step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWorkflow nodes:\u003c\/b\u003e set, code, sort, filter, sticky note, and Slack (for operational visibility).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830417842355,"sku":"N8N-18225","price":32.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Opfe8fZIGMYoLxDR6XEIC_QJ2Xdk4w.png?v=1786698669","url":"https:\/\/buyflowscripts.com\/products\/google-maps-no-website-lead-list-automation-with-apify-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}