🔎 Web Scraping & ResearchIntermediate● Active

Google Maps scraper

A 22-step web scraping & research automation, triggered by manual, sheets, connecting Google Sheets, HTTP / REST API, PostgreSQL.

⬇ Download workflow JSON
💡

What this does for your business

In plain terms: this gathers information from the web for you. It collects and organises data from Google Sheets, PostgreSQL on demand — competitor tracking, research, monitoring — and hands you the result.

22
Nodes
3
Integrations
21
Connections
Manual, Sheets
Trigger

🚀 Deploy this workflow

Deploy this automation in minutes

Log in and we'll walk you through every key step by step, then deploy it for you.

Get started free Log in

🏗️ Architecture diagram

The real node graph exported from n8n — triggers (green), AI nodes (violet), services and logic — laid out as they run.

When clicking ‘Execut…manualTriggerEdit Fields2setLoop Over ItemssplitInBatchesCodecodeFilter3filterFilter5filterEdit FieldssetFilterfilterEdit Fields1set📊Append or update row …googleSheetsBatch Processing LogicsplitInBatches🌐Scrape Website ContenthttpRequestExtract Contact Infor…code📊Google Sheets TriggergoogleSheetsTriggerEdit Fields3set📊Append or update row …googleSheetswebsite?filterWaitwait🌐apify RequesthttpRequest🐘Execute a SQL querypostgres🌐apify Request1httpRequest📊Append row in sheetgoogleSheets

⚙️ How it works

  1. When clicking ‘Execute workflow’ · manualTrigger
  2. Google Sheets Trigger · googleSheetsTrigger
  3. Execute a SQL query · postgres
  4. apify Request · httpRequest
  5. website? · filter
  6. apify Request1 · httpRequest
  7. Filter3 · filter
  8. Filter · filter
  9. Batch Processing Logic · splitInBatches
  10. Edit Fields2 · set
  11. Edit Fields1 · set
  12. Edit Fields3 · set
  13. Filter5 · filter
  14. Append or update row in sheet · googleSheets

💼 Business analysis

🎯

Business use case

An automated research/monitoring workflow that gathers external data (Google Sheets, HTTP / REST API, PostgreSQL), structures it, and delivers insight on a schedule — competitor tracking, market monitoring, data collection.

📈

Market need

Timely external data (competitors, prices, trends) drives decisions, but collecting it by hand is impractical. Automated research is a durable need.

💰

Market value

Data/monitoring subscriptions run $50–$500/mo; the collection engine is the defensible core.

🧩 Integrations & stack

📊Google Sheets🌐HTTP / REST API🐘PostgreSQL
Node typesmanualTrigger, set, splitInBatches, code, filter, googleSheets, httpRequest, googleSheetsTrigger, wait, postgresWorkflow ID75NUg5q7qy2IO1ZF
⬇ Download workflow JSON ← Back to library