Public Website to Google Sheets

Overview

This project is a Python-based web scraper that extracts business information from a public website and automatically updates the data into a Google Sheet using the Google Sheets API.

Features

• Extracts data such as:
  • Company name
  • Address
  • Services
  • Website or contact links
• Supports HTML saving by city
• Semi-automated for Cloudflare-protected websites
• Google Sheets API integration for live updates

Technologies

• Python
• Requests, BeautifulSoup
• Google Sheets API
• Pandas

How to Use

1. Clone the repo
2. Set up your credentials.json from Google Cloud
3. Run the Python script
4. Data will appear in your connected Google Sheet

License

This project is licensed under the MIT License.

Screenshot