Workflow
Daily AI Trends Tracker
Automatically discovers the top trending topics across social media and news every day, analyzes them with AI, and logs a structured, ranked list into Google Sheets.
Tags
Google SheetsData ScrapingTrend AnalysisSocial Media
How It Works
This workflow automatically discovers the top trending topics from across the internet every day and logs them into a Google Sheet as a structured, ranked list.
- Scheduled Trigger: The workflow runs automatically every day at 8:00 AM UTC.
- Dual Internet Search: Two parallel search queries are executed to maximize coverage. The first targets social media discussions, while the second focuses on community forums and news outlets.
- Merge: Results from both searches are combined into a single master list.
- Validate and Deduplicate: A code node removes duplicate URLs, filters out invalid entries, and enforces data quality to prevent the AI from fabricating trends without actual data.
- AI Analysis: An AI agent analyzes all search results and extracts up to 20 of the most prominent trends. The prompt explicitly instructs the AI to only extract trends supported by the search results to prevent hallucinations.
- Google Sheets Upsert: Each trend is written as a row into a Google Sheet using upsert mode. This either inserts a new row or updates an existing one using the Rank column as the key, preventing duplicate rows.
Extracted Trend Data
The AI extracts and formats the following data fields for every detected trend:
| Column | Field Name | Description |
|---|---|---|
| A | Rank | Numerical rank (1 to 20) based on popularity and relevance |
| B | Trend Title | A short title of the idea or trend |
| C | Description | A 2 to 3 sentence summary of the topic |
| D | Source URL | The web link to the originating discussion or news article |
| E | Relevance | Categorized importance (High, Medium, or Low) |
| F | Date Captured | The current date to help track trend cycles |
Key Features
- Fully automated daily execution for continuous monitoring.
- Dual-source search for broader trend coverage across the internet.
- Strict data validation and deduplication to maintain accurate records.
- AI-powered analysis with specific anti-hallucination guardrails.
- Structured output directly mapped to Google Sheets columns using upsert to avoid clutter.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
