Weekly regional sales data collection to Google Sheets

This automation workflow helps retail operations teams and analysts collect up-to-date store data—ID, address, region, estimated sales—from corporate websites and public sources without manual input. The data is cleaned, structured, and automatically saved to Google Sheets, ready for analysis.

## Who it´s for
- Sales managers tracking territory performance
- Operations directors of retail chains
- Analysts automating data collection from public sources
- Teams using Google Sheets for reporting without manual entry

## What the automation does
- Triggers weekly via cron schedule
- Uses a LangChain-powered AI agent with OpenAI to control web scraping via Bright Data
- Extracts store data: ID, address, region, estimated sales
- Cleans and structures data into JSON format
- Splits and writes data into designated Google Sheets by region
- Sends a completion notification to the team via Gmail

## What´s included
- Ready-to-use n8n workflow
- Pre-configured trigger and handler logic
- Integrations with Bright Data, OpenAI, Google Sheets, and Gmail
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n instance (self-hosted or cloud)
- Bright Data API key for web scraping access
- Active OpenAI account and API key
- Google Cloud project with Google Sheets and Gmail APIs enabled

## Benefits and outcomes
- Saves time on weekly data collection
- Reduces errors from manual data entry
- Provides up-to-date insights for resource allocation decisions
- Automatic team notifications upon update
- Flexible region filtering via query parameters
- Streamlined reporting and analytics in Google Sheets

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.