Website Data Scraper & Sheet Sync
Scrapes business data from URLs in Google Sheets and writes results back automatically.
Overview
A scalable scraping loop that reads target URLs from Google Sheets, visits each site, extracts key business information, cleans and structures it, then writes the results straight back into the sheet — with retry logic, error logging and Slack/Gmail alerts. Built to handle hundreds of websites per run.
What we built
- Reads target URLs from Google Sheets
- Scrapes via HTTP Request / Apify
- Extracts name, email, phone, address and services
- Cleans and de-duplicates into structured JSON
- Writes results back and marks rows complete
- Error-log sheet with Slack/Gmail failure alerts
Tech
n8nApifyGoogle SheetsSlack/Gmail