{"product_id":"n8n-workflow-apify-no-website-leads-to-google-sheets","title":"n8n Workflow: Apify No-Website Leads to Google Sheets","description":"\u003ch3\u003eAutomatically find newly registered “no-website” companies with Apify and keep your Google Sheets updated\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday to call the \u003cstrong\u003eApify No-Website Leads\u003c\/strong\u003e actor, then cleans the results and \u003cstrong\u003eappends or updates rows in Google Sheets\u003c\/strong\u003e using \u003cstrong\u003ecompanyNumber\u003c\/strong\u003e as the unique key—perfect for ongoing lead generation for teams that want fresh data without manual research.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules execution:\u003c\/strong\u003e runs every Monday at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e via an n8n Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfigures Apify search parameters:\u003c\/strong\u003e sets countries\/locations, activity keywords, lookback days (registered-in-last-days), output mode, and max results to match your prospecting criteria.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Apify via HTTP:\u003c\/strong\u003e uses an n8n \u003cstrong\u003eHTTP Request\u003c\/strong\u003e with Apify Header Auth (\u003ccode\u003eAuthorization: Bearer \u0026lt;YOUR_APIFY_TOKEN\u0026gt;\u003c\/code\u003e) to run the \u003cstrong\u003eeuroscrape\/no-website-leads\u003c\/strong\u003e actor and retrieves the dataset items.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes lead fields:\u003c\/strong\u003e keeps key lead fields and includes a \u003cstrong\u003ehotLead\u003c\/strong\u003e flag based on recent domain activity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets reliably:\u003c\/strong\u003e appends new rows or updates existing ones by matching on \u003cstrong\u003ecompanyNumber\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\u003eSaaS sales prospecting:\u003c\/strong\u003e automatically track newly registered companies that lack a live website, so your outreach targets are always current.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLead ops \u0026amp; enrichment:\u003c\/strong\u003e maintain a single source of truth in Google Sheets for “no-website” leads, updating the same company by company number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers:\u003c\/strong\u003e deploy a repeatable n8n workflow pattern for Apify-to-Google Sheets lead pipelines.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e Set, Sticky Note, HTTP Request, Google Sheets, Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eApify API\u003c\/strong\u003e (actor: \u003cem\u003eeuroscrape\/no-website-leads\u003c\/em\u003e) and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheet requirements:\u003c\/strong\u003e ensure columns include fields such as \u003ccode\u003ecompanyNumber\u003c\/code\u003e, \u003ccode\u003ename\u003c\/code\u003e, \u003ccode\u003eactivity\u003c\/code\u003e, \u003ccode\u003ecity\u003c\/code\u003e, \u003ccode\u003epostcode\u003c\/code\u003e, \u003ccode\u003ecountry\u003c\/code\u003e, \u003ccode\u003eregisteredOn\u003c\/code\u003e, \u003ccode\u003ewebsiteStatus\u003c\/code\u003e, \u003ccode\u003edomain\u003c\/code\u003e, \u003ccode\u003edomainCreatedOn\u003c\/code\u003e, \u003ccode\u003ehotLead\u003c\/code\u003e, \u003ccode\u003eaddress\u003c\/code\u003e, and \u003ccode\u003esourceUrl\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequirements:\u003c\/strong\u003e an \u003cstrong\u003eApify account\u003c\/strong\u003e and \u003cstrong\u003eAPI token\u003c\/strong\u003e, plus a connected Google Sheets account.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164173062323,"sku":"N8N-20513","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4-WXbkYsARP53J7DvMXYG_Dp2rpdD4.png?v=1791277546","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-apify-no-website-leads-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}