n8n Workflow: Apify No-Website Leads to Google Sheets

Automatically find newly registered “no-website” companies with Apify and keep your Google Sheets updated

This n8n workflow runs every Monday to call the Apify No-Website Leads actor, then cleans the results and appends or updates rows in Google Sheets using companyNumber as the unique key—perfect for ongoing lead generation for teams that want fresh data without manual research.

What this workflow does

• Schedules execution: runs every Monday at 8:00 AM via an n8n Schedule Trigger.
• Configures Apify search parameters: sets countries/locations, activity keywords, lookback days (registered-in-last-days), output mode, and max results to match your prospecting criteria.
• Calls Apify via HTTP: uses an n8n HTTP Request with Apify Header Auth (Authorization: Bearer <YOUR_APIFY_TOKEN>) to run the euroscrape/no-website-leads actor and retrieves the dataset items.
• Normalizes lead fields: keeps key lead fields and includes a hotLead flag based on recent domain activity.
• Updates Google Sheets reliably: appends new rows or updates existing ones by matching on companyNumber.

Use cases

• SaaS sales prospecting: automatically track newly registered companies that lack a live website, so your outreach targets are always current.
• Lead ops & enrichment: maintain a single source of truth in Google Sheets for “no-website” leads, updating the same company by company number.
• Automation engineers: deploy a repeatable n8n workflow pattern for Apify-to-Google Sheets lead pipelines.

Technical details

• n8n nodes: Set, Sticky Note, HTTP Request, Google Sheets, Schedule Trigger.
• Integrations: Apify API (actor: euroscrape/no-website-leads) and Google Sheets.
• Sheet requirements: ensure columns include fields such as companyNumber, name, activity, city, postcode, country, registeredOn, websiteStatus, domain, domainCreatedOn, hotLead, address, and sourceUrl.
• Requirements: an Apify account and API token, plus a connected Google Sheets account.