Collect BBB business listings into Google Sheets with Apify
Ready for 3.0What this workflow does
This workflow has 24 nodes and runs manually, when you click “Execute workflow”. It uses only n8n's built-in nodes.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Configure search (Edit Fields (Set)): sets 6 fields: search, location, distanceMiles…
- Validate configuration (Code): runs custom JavaScript code
- Read destination (HTTP Request): calls an HTTP API (GET)
- Prepare tabs and lock (Code): runs custom JavaScript code
- Acquire destination lock (HTTP Request): calls an HTTP API (POST)
- Read existing rows (HTTP Request): calls an HTTP API (GET)
- Validate existing tables (Code): runs custom JavaScript code
- Resume an existing run? (If): checks a condition and branches into true / false
- Load recovery run (HTTP Request): calls an HTTP API (GET)
- Start bounded BBB run (HTTP Request): calls an HTTP API (POST)
…plus 13 more steps. See the full node list below.
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 Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if
From the author
Quick overview This workflow runs a bounded Better Business Bureau (BBB) search via Apify’s BBB Advanced Scraper and imports the resulting business listings into Google Sheets, updating existing rows by BBB profile URL and logging each scrape run for replay…