This n8n workflow automates the daily monitoring of trends across X (Twitter), newsletters, and websites. It runs on a schedule, fetches data from configured sources in Google Sheets, processes it using AI agents for extraction and analysis (including browser automation and web search), and appends relevant updates to a Google Sheets database. The workflow handles data aggregation, filtering for recency, and deduplication, ensuring users receive concise, actionable insights on topics like AI news or market opportunities.
• The workflow triggers daily, pulling configuration from Google Sheets (e.g., X accounts, newsletters, websites).
• It scrapes recent X posts, fetches newsletter emails via Gmail, and browses websites using an AI agent to extract updates.
• All data is aggregated, analyzed by an AI agent (with optional web research for context), and filtered for relevance.
• Extracted data points (name, description, source, date) are saved to Google Sheets for easy review.
Setup takes about 15-30 minutes, focused on credentials and API keys. Detailed node guidance is in the workflow's sticky notes—clone it, add credentials, and test. The workflow is plug-and-play once imported; only edit prompts or sources as needed.
Automate daily scanning of X (Twitter), newsletters, and websites for trends, saving key updates to Google Sheets.
Google Sheets Setup
Apify Integration (for X Scraping)
HTTP Request node's credentials (header auth: Authorization Bearer).Gmail Setup (for Newsletters)
gmail.readonly).Gmail nodes; ensure your newsletters are in the inbox.Airtop Browser Automation
Airtop nodes' credentials.OpenAI API Key
OpenAI (or equivalent chat model) nodes.Perplexity AI (for Web Research)
Perplexity AI tool node.Clone the workflow JSON directly into n8n—all nodes (schedules, agents, aggregators, HTTP requests) are pre-wired and ready. No re-setup needed beyond the steps above. Key editable fields (found in sticky notes):
Your Instructions Node: Browser Prompt
Customize the website extraction (default: "Search all the latest AI news from this page and its child pages"). Example: Change to "Find new real estate listings" for market-specific monitoring.
Your Instructions Node: Analysis Prompt
Adjust the AI filtering criteria (default: Focuses on AI developments). Example: Add rules for crypto signals or finance news exclusion/inclusion.
Google Sheets Nodes (Get X Accounts, Get Newsletters, Get Websites)
Update the sheet IDs or tabs if using a custom duplicate; add more sources directly in the sheet.
Schedule Trigger Node
Change the daily time (default: 6 AM) or frequency for more frequent runs.
Filter Node (for Tweets)
Tweak the 24-hour recency check if monitoring longer periods.
Test with the default AI focus: Run manually and check the Data Points sheet for updates.
This workflow keeps you ahead in fast-moving fields like AI or markets, delivering daily insights without manual checking. Questions? Test it in n8n!