A Python-based automation tool that fetches the latest AI news twice daily, summarizes it using the Perplexity API, rates it for small business relevance, and stores the results in Google Sheets.

✅ Scrapes AI news from top tech sites:

🧠 Uses OPEN AI API for smart, concise summaries

🔍 Rates each news item (1–10) for small business relevance

🗓️ Automatically runs twice daily (via cron-job.org)

📊 Saves news data to Google Sheets with:

🛠 Built with Python + CrewAI + Flask, ready to deploy on Render or Replit

Crew Ai

Flask (lightweight backend)

Open AI API for AI-powered summarization

Google Sheets API for data storage

BeautifulSoup + requests for scraping

Cron-job.org or GCP Cloud Scheduler for scheduling

Scrape: Gets latest articles from the web

Summarize: Calls Perplexity API with article link or content

Rate: Adds a 1–10 rating based on relevance to small businesses

Save: Uploads to Google Sheets

🔸 Render: Serverless deployment with CRON setup

🔸 Replit + cron-job.org:

🔐 All secrets handled via environment variables and secure base64-encoded credentials

Add Telegram/Slack notifications

Dashboard to browse recent summaries

More granular rating using sentiment/keywords

UI for non-dev users