Templates / Business lead generation with Apify web scraping and Google Sheets storage

Business lead generation with Apify web scraping and Google Sheets storage

Ready for 3.0

by Jordan Lee · 9,678 views · created 2025-07-02 · Lead Generation

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow”.

Start Results (Apify) (HTTP Request): calls an HTTP API (POST)
Wait: waits 1 minutes
Get Results (Apify) (HTTP Request): calls an HTTP API
Split Out: splits a list into separate items
Update Scraped Information (Google Sheets): append or update
Get Results (Apify) (HTTP Request): calls an HTTP API (POST)

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (5)

Manual Triggern8n-nodes-base.manualTrigger
Waitn8n-nodes-base.wait
Split Outn8n-nodes-base.splitOut
Google Sheetsn8n-nodes-base.googleSheets
HTTP Requestn8n-nodes-base.httpRequest

From the author

This flexible template scrapes business listings for any industry and location, perfect for sales teams, marketers, and researchers. Good to know - Works with any business category (restaurants, contractors, retailers, etc.) - Fully customizable search…
Excerpt from Jordan Lee's description on n8n.io.

View the original on n8n.io → Check your own copy

Business lead generation with Apify web scraping and Google Sheets storage

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (5)

From the author

Get the weekly “what broke” email