Python + OpenAI Company Presence & News Analysis Tool

📄 Detailed Description: This project is a Python-powered automation tool 🤖 designed to collect, analyze, and summarize company information efficiently. It works in three main stages:

📊 Data Fetching: The program connects to Google Sheets API to automatically fetch a list of company names stored in a spreadsheet. This allows for easy updates — any new company added to the sheet is instantly included in the process.

🌏 Presence Check in China: For each company, the script uses web search and pattern recognition to check whether the company has operations, branches, or partnerships in China 🇨🇳. This helps identify global footprints and international connections.

🧠 AI-Powered News Analysis: Using OpenAI’s models (via the API), the program performs an intelligent search and summarization of recent news or online mentions related to each company. It extracts key highlights — such as expansions, controversies, or product updates — and produces a clean, easy-to-read summary 📰.

🐍 Python – main language for scripting and automation

📄 Google Sheets API – to retrieve company data dynamically

🌐 Requests & BeautifulSoup – for online presence checks

🧠 OpenAI API – for semantic search, summarization, and text analysis

💾 Pandas – for data organization and report generation

🚀 Outcome: The final output gives a structured summary for each company, showing:

✅ Whether the company is active or has a presence in China

🗞️ Relevant recent news and insights powered by OpenAI

📈 A clear overview of company activity for research or business intelligence purposes