LeeWei
Categories
Templates by LeeWei
Analyze videos with Google Gemini AI - form uploads & YouTube links
⚙️ Analyze Video Workflow - Automates Video Analysis with Google Gemini --- 🚀 Steps to Connect: Google Gemini API Key Go to Google AI and sign up to get your free API key. Create your query authorization credential using that API key in the HTTP Request nodes (e.g., "Upload File", "Get Analysis") that require a Google Gemini credential. Form Trigger Setup Ensure the On form submission node is linked and ready to accept video uploads. No additional configuration needed; the node is pre-set for video input. YouTube Video Analysis (Optional) Update the YouTube Video node’s jsonBody field with your desired YouTube URL (e.g., replace https://youtu.be/gwCQF--cARA?si=uCbaUnoRlEjHO50a with your video link). Keep the prompt as "Please summarize the video in 3 sentences" or modify it as needed. --- Overview of the n8n Workflow This n8n workflow automates the analysis of uploaded videos or YouTube links using Google Gemini, providing detailed descriptions or summaries of the content. It processes video uploads, extracts analysis, and stores the results, with options for real-time polling and YouTube integration. The workflow includes sticky notes with setup instructions and editable fields, formatted in Markdown for clarity, as seen in the "Example Output.txt". --- How it Works Uploads a video file or links a YouTube URL for analysis. Processes the video through Google Gemini to generate a detailed description or summary. Stores the analysis results and optionally polls for updates with a delay. Set up Steps Setup time: Approximately 10-15 minutes. Detailed instructions are available in the sticky notes within the workflow. --- Editable Fields YouTube Video Node: jsonBody Update the file_uri field with your YouTube video URL (e.g., replace https://youtu.be/gwCQF--cARA?si=uCbaUnoRlEjHO50a with your link). Modify the text prompt if you want a different analysis (e.g., "Describe the video in detail" instead of "Please summarize the video in 3 sentences"). On form submission Node: No edits needed Pre-configured for video uploads; ready to use as is. ---
By LeeWeiAnalyze trending YouTube videos with Apify, OpenAI, and Google Sheets
⚙️ Trending YouTube Videos Research Workflow: 🧑💻 Author: [Leewei] Automates scraping trending videos based on a keyword, filters high-potential ones, analyzes thumbnails and transcripts with AI, generates optimized titles and outlines, and updates a Google Sheet for content ideas. --- 🚀 Steps to Connect: Apify API Token Sign up for a free account at Apify and generate your API token. Paste the token into the two HTTP Request nodes (replace <token> in the Authorization header). 💡 This enables scraping YouTube video data and transcripts—setup takes about 5 minutes. OpenAI API Key Go to OpenAI and generate your API key. Add it to the credentials for the YouTube Title Generator, Analyze Thumbnail, and Outline Generator nodes. 💡 Use models like GPT-4o-mini for thumbnail analysis and title/outline generation. Google Sheets Credentials Set up OAuth2 credentials in n8n for Google Sheets with access to your Drive. Update the documentId in the Step 1 Results, Find Duplicate Entries, and Update Rows nodes to your own Google Sheet ID (clone the provided sheet if needed). 💡 This stores filtered video data, AI-generated titles, and outlines—expect 10-15 minutes for auth setup. (Optional) Customize Form Trigger If deploying publicly, no changes needed—the form prompts for "Keyword or Topic" to start the search. Test with a sample keyword like "AI automation" to see results in your sheet. ---
By LeeWeiGenerate AI-powered sales proposals from JotForm leads with OpenAI and Google Docs
⚙️ Proposal Generator Template (Automates proposal creation from JotForm submissions) 🧑💻 Author: [LeeWei] --- 🚀 Steps to Connect: JotForm Setup Visit JotForm to generate your API key and connect to the JotForm Trigger node. Update the form field in the JotForm Trigger node with your form ID (default: 251206359432049). Google Drive Setup Go to Google Drive and set up OAuth2 credentials ("Google Drive account") with access to the folder containing your template. Update the fileId field in the Google Drive node with your template file ID (default: 1DSHUhq_DoM80cM7LZ5iZs6UGoFb3ZHsLpU3mZDuQwuQ). Update the name field in the Google Drive node with your desired output file name pattern (default: ={{ $json['Company Name'] }} | Ai Proposal). OpenAI Setup Visit OpenAI and generate your API key. Paste this key into the OpenAI and OpenAI1 nodes under the "OpenAi account 3" credentials. Update the modelId field in the OpenAI1 node if needed (default: gpt-4.1-mini). Google Docs Setup Set up OAuth2 credentials ("Google Docs account") with edit permissions for the generated documents. No fields need editing as the node dynamically updates based on previous outputs. Google Drive2 Setup Ensure the same Google Drive credentials ("Google Drive account") are used. No fields need editing as the node handles PDF conversion automatically. Gmail Setup Go to Gmail and set up OAuth2 credentials ("Gmail account"). No fields need editing as the node dynamically uses the prospect's email from JotForm. --- How it works The workflow triggers on JotForm submissions, copies a Google Drive template, downloads an audio call link, transcribes it with OpenAI, generates a tailored proposal, updates a Google Docs file, converts it to PDF, and emails it to the prospect. Set up steps Setup time: Approximately 15-20 minutes. Detailed instructions are available in sticky notes within the workflow.
By LeeWeiAutomate faceless shorts with OpenAI, RunwayML & ElevenLabs: script to social media
⚙️ Faceless YouTube Generator - Automate Faceless YouTube Shorts with AI: Generate Scripts, Videos, Audio, and Captions in Minutes! Tired of grinding out YouTube content? This n8n workflow turns AI into your personal video factory—creating engaging, faceless shorts on autopilot. Perfect for creators, marketers, or side-hustlers looking to monetize without showing your face. From script writing to final upload, it's all handled: AI-generated scripts (optimized for 20-second hooks), stunning image-to-video animations via RunwayML, immersive audio with ElevenLabs, and pro captions. Scale your channel effortlessly and watch the views (and revenue) roll in! 🧑💻 Author: LeeWei --- 🚀 How It Works • Trigger & Script Magic: Starts via Google Sheets webhook—AI crafts a punchy 213-223 character script (via Anthropic) for ~20-second shorts, ensuring viral potential. • Visuals on Autopilot: Splits scenes, generates high-quality images with OpenAI, then animates them into videos using RunwayML's Gen3a Turbo. • Audio Layering: Adds soothing background sounds and professional voice-overs (Adam voice) via ElevenLabs for that polished, immersive feel. • Final Polish & Upload: Merges everything in Creatomate, slaps on captions with Replicate, uploads to Google Drive/YouTube, and updates your sheet—ready to post! Setup takes 15-20 minutes with API keys. Plug-and-play: Import the JSON into n8n, and you're set—edit only API tokens and credentials as noted. 🚀 Steps to Connect: Google Sheets & Drive Setup Use your existing Google OAuth2 credentials in the "Google Sheets" and "Google Drive" nodes. Clone the demo sheet (ID: 1Co9tTJelYyefLLxzkoOhUBU3XuQIspBpDudtZLynW2M) and update the ID in "Update Video Status" if needed. Tweak folder IDs in "Upload to Drive" nodes for custom storage. Anthropic API Key Head to Anthropic and grab your API key. Paste it into the "Anthropic Chat Model" node credentials. OpenAI API Key Visit OpenAI for your API key. Add it to the "OpenAI Chat Model" node credentials. RunwayML API Key Sign up at RunwayML and get your token. Replace "YOURAPITOKEN" in the "Authorization" headers of "Generate Videos" and "Get Generated Videos" HTTP nodes. ElevenLabs API Key Go to ElevenLabs and generate your key. Swap "YOURAPITOKEN" in the "xi-api-key" headers of "Generate Audio (Background sound)" and "Text to Speech (Adam Voice)" nodes. Creatomate API Key Register at Creatomate for your token. Update "YOURAPITOKEN" in the "Authorization" header of the "Render Video with Creatomate" HTTP node. Replicate API Key Get your token from Replicate. Insert "YOURAPITOKEN" in the "Authorization" header of the "Add Captions - replicate" HTTP node. (Optional) YouTube Upload For direct uploads, add your Google YouTube OAuth credentials to the "Upload Video" node.
By LeeWeiTransform spreadsheet data into smart charts with OpenAI, QuickChart & Google Drive
Overview of the n8n Workflow This n8n workflow automates the transformation of spreadsheet data into professional charts and graphs using AI-driven analysis. Triggered via Slack, it processes uploaded files (Excel, CSV, Google Sheets, or Drive links), interprets the data with an AI agent to determine the best visualization type (e.g., bar, line, pie, doughnut, or bubble charts), generates images via QuickChart, uploads them to Google Drive, and delivers the results back to the user in Slack with titles and shareable links. It maintains conversation context in Postgres for seamless multi-turn interactions and handles audio or text inputs for chart requests. What this workflow does: Hooks up to Slack for seamless spreadsheet uploads Automatically extracts your data and generates bar charts, line graphs, bubble charts, and more Delivers stunning visualizations straight back to you in Slack Makes it easy to spot trends, patterns, and insights—on demand --- How it Works • Users upload spreadsheets or share links via Slack, along with a natural language request (e.g., "Create a bar chart of sales by month"). • The workflow detects file types, extracts and aggregates data, then uses an AI agent to parse the request and select an appropriate chart type. • Data is formatted and sent to QuickChart's API to generate the visualization image. • Images are uploaded to Google Drive, and a confirmation message with titles and links is sent back to Slack. --- Set Up Steps Setup takes about 15-30 minutes, mainly for credential configuration. Detailed node instructions are in the workflow's sticky notes—focus on pasting API keys and testing triggers. Once cloned, the workflow runs plug-and-play; only tweak credentials and optional prompts as needed. --- ⚙️ Turn Spreadsheets Into Charts & Graphics Automate turning uploaded spreadsheets into AI-generated charts (bar, line, pie, etc.) via Slack, with results shared as Google Drive links. 🧑💻 Author: LeeWei --- 🚀 Steps to Connect: Slack Bot Setup Create a Slack app at api.slack.com/apps and add scopes for chat:write, files:read, channels:read. Generate a Bot User OAuth Token and paste it into the Slack Trigger node's credentials in n8n. Invite the bot to your desired channel for file uploads and messages. OpenAI API Key Sign up at platform.openai.com and generate an API key. Paste this key into the OpenAI (gpt-4o-mini) node's credentials. 💡 For cost efficiency, monitor usage—basic charts use minimal tokens. Postgres Database Connection Set up a Postgres instance (e.g., via Supabase or your host) with a table named n8nrodgerchat for chat history. Add connection details (host, database, user, password) to the Postgres nodes' credentials. This enables thread memory; skip if not using multi-turn chats (but recommended for context). Google Sheets & Drive Setup Create OAuth2 credentials at console.cloud.google.com with scopes for Sheets (read) and Drive (upload, share). Paste the credentials into the Google Sheets and implied Drive upload nodes. Test by sharing a sample sheet—ensures data extraction and image storage work. QuickChart Integration No API key needed for free tier (up to 500 charts/month); visit quickchart.io to confirm. For production (100k+ charts/month), upgrade to corporate plan ($40/month) and add any auth if required in the HTTP Request node. The node is pre-configured for chart generation—edit URL params only for custom styling. --- Plug and Play Instructions Clone the workflow JSON directly into n8n—all nodes (triggers, AI agents, extractors, switches) are pre-wired and ready. No re-setup needed beyond the steps above. Key editable fields (found in sticky notes): AI Agent Node: System Prompt Customize the chart interpretation (default: auto-selects bar/line/pie/etc. based on data). Example: Change to prioritize "scatter plots for correlations" if needed. Switch Nodes (File Detection) Add rules for new formats (e.g., .ods for OpenDocument) in the conditions for XLS/XLSX/CSV/Sheets/Drive. HTTP Request Node (QuickChart) Tweak chart params like width=800&height=600 for size, or colors via ?chart=... for branding. Let User Know Upload Complete: Text Adjust the confirmation message template for tone (e.g., add emojis or custom phrasing). Test with a sample Slack message: "Make a line graph from this sales CSV over months." Results appear instantly with links. --- Potential Customizations Add Chart Types: Duplicate a chart branch (e.g., Line Graph) and integrate new QuickChart endpoints for scatter or funnel charts. Switch AI Provider: Replace OpenAI with OpenRouter in the Chat Model node for alternative LLMs. Batch Size: Edit the Loop Over Items node's batch for larger datasets (default handles small files efficiently). Error Handling: Add IF nodes post-extraction to notify on invalid data. --- Considerations and Improvements Rate Limits: QuickChart free tier suits testing; scale to paid for heavy use. OpenAI tokens add up for complex data. File Limits: Supports up to ~10MB uploads; for larger, preprocess externally. Privacy: Data passes through OpenAI—review for sensitive info. Enhancements: Integrate image OCR for scanned tables, or export to PDF for reports. This workflow streamlines data viz without coding, perfect for teams analyzing trends on the fly. Questions? Drop a Slack message in your bot channel!
By LeeWeiAI-powered sales assistant with Airtable CRM, Gmail and web research
Overview of the n8n Workflow This n8n workflow automates sales processes using AI agents integrated with Airtable as a CRM and Gmail for email handling. It consists of two main workflows: one for handling Airtable status changes to send automated emails, and another for processing incoming emails to add new leads to the CRM or respond to existing leads/clients. The agents personalize emails, research leads via web searches, update CRM notes, and include human approval for responses. --- Sticky Notes: Setup and Customization Guidance The workflows include sticky notes with Markdown formatting for key instructions (assume these are added to the cloned workflows): Editable Fields (Airtable and Gmail Credentials) Editable Fields Update Airtable base ID and table ID in trigger/search nodes to match your CRM. Set Gmail credentials for triggers and email nodes. Editable Fields (API Keys and Models) Editable Fields Replace Tavily API key in HTTP request nodes with your own (sign up at tavily.com). Update OpenAI model in chat model nodes if needed (e.g., to gpt-4o). Editable Fields (Google Docs Templates) Editable Fields Replace Google Docs URLs in document nodes with your own templates for each status/email type. Ensure Google Docs credentials have read access. --- How to Set Up the Workflow To use these workflows in n8n (setup time: ~10-15 minutes): Import the JSONs: Paste the provided JSON into n8n to create the two workflows ("Airtable sales agent" and "Email sales Agent"). Configure Credentials: Airtable: Add API token credentials for your base. Gmail: Set up OAuth2 credentials for your email account. OpenAI: Add API key for chat models. Google Docs: Set up OAuth2 credentials with read access to your templates. Update Editable Fields: In Airtable nodes: Set your base ID and table ID. In HTTP nodes: Replace Tavily API key. In Google Docs nodes: Update URLs to your email templates/knowledge base. No need to rebuild nodes; all are pre-configured. Activate Workflows: Enable the triggers and test with sample data. --- Potential Customizations Change Status Templates: Add more switch outputs and Google Docs nodes for additional Airtable statuses. Adjust AI Prompts: Modify system messages in AI Agent nodes for different personalization or response styles. Replace Search API: Swap Tavily HTTP requests with another search tool if preferred. Add More Tools: Extend the AI Agent with additional tools for CRM updates or integrations. --- Considerations and Improvements API Limits: Monitor Tavily and OpenAI usage to avoid rate limits; add waits if needed. Error Handling: Add IF nodes for cases like no matching lead or failed searches. Data Privacy: Ensure sensitive lead data in Airtable and emails complies with regulations. Testing: Use test emails and Airtable records to verify before going live. --- Conclusion These n8n workflows create an efficient AI-powered sales system, automating lead addition, CRM updates, and email communications with minimal setup. They integrate seamlessly with Airtable and Gmail, allowing focus on high-value tasks. Customize as needed via the editable fields outlined.
By LeeWeiGenerate viral baby celebrity podcasts with AI, Hedra and ElevenLabs
⚙️ Automated Viral Baby Podcast Video Generator 🧑💻 Author: LeeWei --- Overview of the n8n Workflow This n8n workflow automates the creation of viral short videos featuring AI-generated baby podcasts. It handles everything from generating unique video ideas to producing audio, images, and videos using AI tools, then uploading the final content to YouTube and tracking it in Google Sheets. The workflow includes sticky notes labeling key sections for clarity, formatted in Markdown. --- How it Works This workflow distills the process of creating viral baby podcast videos into a few high-level steps: Idea Generation: Fetches existing topics from Google Sheets and uses AI to create a new, unique idea with a character (e.g., Baby Elon Musk). Content Creation: Generates a script/title, audio via TTS, and an image via DALL-E. Video Synthesis: Uploads assets to Hedra to produce a short video. Upload and Tracking: Saves the video to Google Drive, uploads to YouTube, and logs details in Google Sheets. --- Set up Steps Setup should take about 15-30 minutes, mainly for creating accounts and credentials. Detailed descriptions are kept in the workflow's sticky notes. Since this is plug-and-play, all nodes are pre-configured—edit only the specified fields below. --- 🚀 Steps to Connect: OpenAI API Key Go to OpenAI and generate your API key. Paste it into the OpenAI credentials for nodes like "Audio Prompt & Title", "Image Prompt", "Idea Generator", and "Create The Image". ElevenLabs API Key Visit ElevenLabs to generate your API key. Paste it into the HTTP Header Auth credentials for the "Text to Speech" node. (Optional) Update the voice ID in the URL if you want a different voice (default: "nPczCjzI2devNBz1zQrb"). Hedra API Key Go to Hedra and generate your API key. Paste it into the HTTP Header Auth credentials for Hedra-related nodes (e.g., "Create Audio Asset (Hedra)"). (Optional) Update the AI model ID in "Create Video (Hedra)" if needed (default: "d1dd37a3-e39a-4854-a298-6510289f9cf2"). Google Drive & Sheets OAuth Set up OAuth2 credentials at Google Cloud Console with access to Drive and Sheets. Paste into the Google Drive/Sheets credentials. Duplicate the template Sheet (link in video description) and update the documentId in "Get Existing Ideas" and "Google Sheets" nodes. Create a "Baby Pods" folder in Drive and update the folderId in "Upload Video" (default: "1WemU2r1nI0xnv-3z5a2LZk2kpt1bw5Pt"). Blotato --- Potential Customizations Change Characters or Prompts: Edit the system message in "Idea Generator" to add/remove characters (e.g., add "Baby Taylor Swift"). Adjust Schedule: Modify "Schedule Trigger1" for different run times. Different TTS or Image Models: Swap ElevenLabs/OpenAI endpoints for alternatives. Add Platforms: Extend with nodes for Instagram Reels or TikTok uploads. Video Settings: Tweak resolution/aspect ratio in "Create Video (Hedra)". --- Considerations and Improvements API Limits: Monitor usage for OpenAI, ElevenLabs, and Hedra to avoid rate limits; add more waits if needed. Error Handling: Add "If" nodes for failures (e.g., if video generation times out). Content Quality: Test prompts for virality; the default focuses on controversial topics. Dependencies: Ensure all APIs are active; Hedra may require waits for processing. Scalability: For more videos, increase batching or parallelize idea generation.
By LeeWeiAdaptive email auto-responder with GPT-4, RAG and human feedback loop
⚙️ Self Learning Agent: AI-Powered Email Auto-Responder that Improves with Feedback 🧑💻 Author: LeeWei --- Overview of the n8n Workflow This n8n workflow builds a self-improving AI agent for handling email responses. It integrates Gmail for incoming messages, uses an AI agent with a Supabase vector store for knowledge retrieval, drafts replies based on dynamic prompts, and evaluates confidence scores. High-confidence drafts are sent automatically, while low-confidence ones are routed to Google Sheets for human review. Feedback from Sheets triggers updates to the prompt or knowledge base, enabling the agent to learn and refine its responses over time. The workflow supports OpenAI and OpenRouter models, with structured output parsing and conditional routing for efficiency. --- How it Works • Triggers on new Gmail emails, extracts content, and uses an AI agent with company knowledge from Supabase to draft a response. • Assesses confidence; auto-sends high-confidence replies or saves drafts to Google Sheets for human feedback. • Monitors Sheets for updates, extracts feedback via AI, and applies changes—either refining the dynamic prompt or adding new info to the vector store. • Loops back improvements to enhance future responses without manual reconfiguration. --- Set Up Steps Setup takes about 20-30 minutes, focused on credentials and basic resource creation (e.g., Google Sheet and Supabase table). Detailed node-level guidance is in the workflow's sticky notes—clone the JSON for plug-and-play nodes, then edit only essentials like credentials and IDs. No need to rebuild nodes; they're pre-connected and ready. --- 🚀 Steps to Connect: Gmail Setup Set up OAuth2 credentials at console.cloud.google.com with scopes for Gmail (read/send). Paste into the Gmail Trigger and Gmail nodes' credentials fields. Test by sending a sample email to your connected inbox. OpenAI API Key Generate at platform.openai.com. Paste into the OpenAI Chat Model and OpenAI Chat Model1 nodes' credentials. 💡 Use a model like gpt-4o-mini for cost efficiency; adjust temperature in options for response creativity. OpenRouter API Key Sign up at openrouter.ai and create an API key. Paste into the OpenAI Chat Model2 node's credentials (used for feedback extraction). Select a model like gpt-4o-mini in the node for consistency. Supabase Connection Create a free account at supabase.com, set up a project, and add a table named documents with vector support (enable pgvector extension). Paste API URL and key into the Supabase Vector Store and Supabase Vector Store1 nodes' credentials. Initialize with sample docs via the workflow or dashboard for knowledge base testing. Google Sheets Setup Create OAuth2 credentials at console.cloud.google.com with scopes for Sheets (read/write). Paste into all Google Sheets nodes' credentials. Duplicate the sample sheet (ID: 1YDzwYd5LdTnSQlFM5YrDhhbCnNH7oHVvNg6x3mYu8I4) or create one with tabs: "Dynamic Var" (for prompts) and "Feedback" (columns: Id, Original Email, Draft, Human Feedback, Status). Replace the documentId in nodes with your sheet's ID. --- Plug and Play Instructions Clone the provided JSON directly into n8n—all nodes (triggers, agents, parsers, switches) are pre-wired and functional. No re-setup required beyond the steps above. Key editable fields (detailed in sticky notes): AI Agent Node: System Message Customize the prompt template for response style (e.g., add rules for tone or specific facts). Default handles factual, concise replies. Structured Output Parser Node: JSON Schema Adjust if adding output fields (e.g., include "suggestedfollowup" alongside "finalresponse" and "resolution_score"). If Node: Conditions Tweak the confidence threshold (default: <4 routes to review) based on your risk tolerance. Information Extractor Node: Prompt Refine the feedback analysis (e.g., prioritize certain feedback types like "add facts" vs. "update prompt"). Test with a sample email: Send a query to your Gmail, review in Sheets if low-confidence, provide feedback, and watch the agent improve on the next run. --- Potential Customizations Switch AI Models: Swap OpenAI/OpenRouter nodes for alternatives like Anthropic via compatible n8n nodes. Add Notifications: Insert a Slack or email node post-Sheets save for alerts on low-confidence drafts. Expand Knowledge Base: Add a loader node to ingest more docs into Supabase automatically. Confidence Routing: Duplicate the If node for multi-tier reviews (e.g., score 1-2 escalates to admin). --- Considerations and Improvements API Limits: Monitor OpenAI/OpenRouter usage for costs; start with mini models. Supabase free tier handles small knowledge bases—upgrade for scale. Data Privacy: Emails and feedback pass through AI providers—ensure compliance for sensitive info. Feedback Loop: Test iterations to confirm improvements; initial runs may need manual prompt tweaks. Enhancements: Integrate audio transcription for voice feedback or export logs for auditing. This workflow turns email handling into an adaptive, low-maintenance system—ideal for support teams or busy inboxes. For tweaks, reference the sticky notes or experiment in a test clone!
By LeeWeiAI industry trend monitor 24/7 across X, Gmail, and websites using GPT-5
Overview of the n8n Workflow 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. --- How it Works • 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. --- Set Up Steps 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. --- ⚙️ AI Trend Listener: Monitor Updates 24/7 Automate daily scanning of X (Twitter), newsletters, and websites for trends, saving key updates to Google Sheets. 🧑💻 Author: LeeWei --- 🚀 Steps to Connect: Google Sheets Setup Duplicate the template sheet. Add OAuth2 credentials in n8n for read/write access to the sheet. Populate the X, Newsletters, and Websites tabs with your sources (e.g., usernames, email filters, URLs). Apify Integration (for X Scraping) Sign up at apify.com and generate an API token. Paste the token into the HTTP Request node's credentials (header auth: Authorization Bearer). Test with a sample X account to fetch recent posts. Gmail Setup (for Newsletters) Create OAuth2 credentials in n8n with scopes for reading emails (gmail.readonly). Connect to the Gmail nodes; ensure your newsletters are in the inbox. 💡 Filter for specific senders in the Newsletters sheet tab. Airtop Browser Automation Register at airtop.ai, generate an API key, and create a profile. Paste the key into the Airtop nodes' credentials. The browser agent handles website navigation—test with a sample URL. OpenAI API Key Generate a key at platform.openai.com. Paste it into the OpenAI (or equivalent chat model) nodes. Use for AI agents analyzing data; select a model like GPT-4 for best results. Perplexity AI (for Web Research) Sign up at perplexity.ai/api and get an API key. Paste it into the Perplexity AI tool node. Enables context gathering during analysis—use sparingly for cost. --- Plug and Play Instructions 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. --- Potential Customizations Add More Sources: Expand Google Sheets tabs for new categories (e.g., Reddit via HTTP) and add aggregation branches. Switch AI Models: Replace OpenAI with another provider in the chat model nodes. Enhance Output: Add notifications (e.g., Slack node) after saving to Sheets. Scale Monitoring: Increase Apify maxItems or add loops for larger datasets. --- Considerations and Improvements Rate Limits: Apify and Perplexity have usage caps; monitor for heavy queries. Airtop starts with free credits (10,000). Data Volume: Handles moderate sources; for high-volume, batch process or filter stricter. Privacy: Data passes through third-party APIs—avoid sensitive topics. Enhancements: Integrate email notifications for urgent trends or add deduplication logic for cross-source overlaps. This workflow keeps you ahead in fast-moving fields like AI or markets, delivering daily insights without manual checking. Questions? Test it in n8n!
By LeeWei