by WeblineIndia
RSS Feed Latest Article Fetcher Workflow This n8n workflow fetches URLs from an RSS feed, checks which URLs have a valid RSS feed and if true, fetches the latest articles from those URLs. It then stores the article details, including the article link, in Google Sheets. Quick Implementation Steps Import this JSON workflow into n8n. Connect your application or RSS feed URLs to be checked. Add Google Sheets API credentials to store the fetched articles. Enable the workflow — done! What It Does Fetches RSS Feed URLs Retrieves a list of URLs from an RSS feed source. Checks Each URL for RSS Feed Verifies which URLs contain a valid RSS feed. Fetches Latest Articles For URLs with valid RSS feeds, it fetches the latest articles from those feeds. Stores Articles in Google Sheets Adds the article data, including article links, to a Google Sheet for record-keeping. Who’s It For This workflow is ideal for: Content aggregators looking to fetch articles from multiple RSS feeds. Teams needing to automate article collection and storage for easy reference. Organizations aiming to centralize their content curation process in Google Sheets. Requirements n8n (Self-Hosted or Cloud) Google Sheets API credentials with permissions to append data A list of RSS feed URLs to check How It Works Trigger: Workflow is triggered by clicking "Execute Workflow". Fetch RSS URLs: Retrieves a list of URLs to check for RSS feeds. Check for RSS Feed: Validates whether the URLs have a valid RSS feed. Fetch Latest Articles: For valid RSS feeds, the workflow fetches the latest articles. Store in Sheets: The fetched articles, along with their links, are added to a Google Sheet. Stop if No Articles Found: If no valid articles are found, the workflow automatically stops. Setup Instructions Import Workflow: Workflows → Import from File in n8n. RSS Feed URL Setup: Input the URLs you want to check for RSS feeds. Google Sheets Setup: Connect your Google Sheets account and configure the spreadsheet where articles will be stored. Run the Workflow: Trigger the workflow manually by clicking "Execute Workflow" and monitor the results in your Google Sheet. Logic Overview | Step | Node Description | |----------------------------------------|----------------------------------------------------------------------------------| | 1. Trigger | Execute Workflow: Initiates the workflow process when triggered. The workflow begins when you manually execute it. | | 2. Fetch RSS URLs | RSS Feed: Retrieves a list of RSS URLs from Google Sheets. | | 3. Check for RSS Feed | Check RSS URLs: Verifies whether each URL has a valid RSS feed using an HTTP Request node. | | 4. Fetch Latest Articles | Fetch Each URL: Fetches the latest articles from valid RSS feeds using the RSS Feed Read node. | | 5. Fetch Existing Titles | Fetch Existing Title: Retrieves stored titles from Google Sheets for comparison. | | 6. Check for Duplicates | Check if Title Exists: Compares new titles with existing ones. Duplicates are skipped; new ones proceed. | | 7. Store Only Non-Duplicate Titles | Append Row in Sheets: Stores new (non-duplicate) articles in Google Sheets. | | 8. Optional Message Node | Message: Logs duplicate events (e.g., "Data already exists"). | | 9. Stop if No Articles Found | Stop: Halts workflow if no new articles are found or added. | Customization Options RSS URL List**: Adjust the list of URLs to fetch articles from. Google Sheets**: Modify the Google Sheets integration to store additional data (e.g., article content, author). Error Handling**: Add custom error messages if no RSS feed is found or no articles are fetched. Troubleshooting No Articles Fetched**: Ensure the RSS feed URLs are correctly formatted and active. Google Sheets Issues**: Verify that the Google Sheets API credentials are correctly configured and the sheet is accessible. Workflow Not Triggering**: Check the execution trigger settings to ensure the workflow is activated manually. Use Case Examples Blog Aggregator: Automatically fetch and store the latest blog articles from multiple RSS feeds into a central Google Sheet for analysis. Content Curation: Gather the latest articles from industry-related RSS feeds and share them with your team. Need Help? If you need help setting up, customizing or extending this workflow, WeblineIndia can assist with full n8n development, workflow automation, content fetching systems and custom integrations.
by automedia
Transcribe New YouTube Videos and Save to Supabase Who's It For? This workflow is for content creators, marketers, researchers, and anyone who needs to quickly get text transcripts from YouTube videos. If you analyze video content, repurpose it for blogs or social media, or want to make videos searchable, this template will save you hours of manual work. What It Does This template automatically monitors multiple YouTube channels for new videos. When a new video is published, it extracts the video ID, retrieves the full transcript using the youtube-transcript.io API, and saves the structured data—including the title, author, URL, and full transcript—into a Supabase table. It intelligently filters out YouTube Shorts by default and includes error handling to ensure that only successful transcriptions are processed. Requirements A Supabase account with a table ready to receive the video data. An API key from youtube-transcript.io (offers a free tier). The Channel ID for each YouTube channel you want to track. You can find this using a free online tool like TunePocket's Channel ID Finder. How to Set Up Add Channel IDs: In the "Channels To Track" node, replace the example YouTube Channel IDs with your own. The workflow uses these IDs to create RSS links and find new videos. Configure API Credentials: Find the "youtube-captions" HTTP Request node. In the credentials tab, create a new "Header Auth" credential. Name it youtube-transcript-io and paste your API key into the "Value" field. The "Name" field should be x-api-key. Connect Your Supabase Account: Navigate to the "Add to Content Queue Table" node. Create new credentials for your Supabase account using your Project URL and API key. Once connected, select your target table and map the incoming fields (title, source_url, content_snippet, etc.) to the correct columns in your table. Set Your Schedule (Optional): The workflow starts with a manual trigger. To run it automatically, replace the "When clicking ‘Execute workflow’" node with a Schedule node and set your desired interval (e.g., once a day). Activate the Workflow: Save your changes and toggle the workflow to Active in the top right corner. How to Customize Transcribe YouTube Shorts:* To include Shorts in your workflow, select the *"Does url exist?"** If node and delete the second condition that checks for youtube.com/shorts. Change Your Database:* Don't use Supabase? Simply replace the *"Add to Content Queue Table"* node with another database or spreadsheet node, such as *Google Sheets, **Airtable, or n8n's own Table.
by higashiyama
Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOUR_SPREADSHEET_ID>, <YOUR_SHEET_GID_OR_NAME>, <YOUR_SLACK_CHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.
by banan
How it works This workflow syncs Toggl Track time entries to Google Sheets and creates monthly tabs automatically. It fetches: time entries from Toggl project metadata from Toggl Then it: filters entries by your selected project name writes detailed rows to a Detail Sheet writes daily aggregated rows to a Summary Sheet creates/removes monthly tabs to keep both sheets clean and aligned Set up steps Estimated setup time: 10–15 minutes. Configure HTTP Basic Auth for Toggl: Username: your Toggl API token Password: api_token Configure Google Sheets OAuth2 credentials. In Set Date Range, set start_date. In Process Data, set: PROJECT_NAME TIMEZONE Replace placeholders in workflow nodes: YOUR_DETAIL_SPREADSHEET_ID YOUR_SUMMARY_SPREADSHEET_ID Detailed node-by-node guidance is included in sticky notes inside the workflow.
by Vonn
This workflow automatically searches YouTube Data API for videos related to specific keywords, extracts channel data, filters channels based on performance metrics, and saves the results into Google Sheets. Instead of manually searching YouTube and copying channel information, this workflow continuously discovers creators and builds a structured lead database. It is designed for marketers, researchers, agencies, and teams that need a reliable way to identify relevant YouTube channels in specific niches. Who this workflow is for This workflow is ideal for: influencer marketing teams discovering creators in specific niches agencies building creator outreach lists researchers analyzing YouTube channel growth and trends startups building creator marketplaces marketers identifying potential partners or competitors If you regularly search YouTube for channels related to certain topics, this workflow automates that process. How it works The workflow runs on a schedule in n8n and processes keywords one at a time to avoid API limits. The automation performs the following steps: A Schedule Trigger starts the workflow automatically. Keywords are retrieved from a keyword list. The workflow selects one keyword to process. The YouTube Data API searches for videos related to that keyword. Channel IDs are extracted from the video results. Channel statistics such as subscriber count, total views, and video count are retrieved. Channels are filtered using configurable thresholds. Qualified channels are saved or updated in Google Sheets. The result is an automatically growing database of YouTube channels relevant to your target topics. Requirements To use this workflow you will need: An instance of n8n A YouTube Data API credential A Google Sheets account A spreadsheet where discovered channels will be stored How to set up Create credentials for the YouTube Data API in n8n. Connect your Google Sheets account. Add your target keywords to your keyword source. Configure filtering rules such as minimum subscribers or views. Set the schedule trigger interval. Once configured, the workflow will run automatically and populate your spreadsheet with newly discovered YouTube channels. How to customize the workflow You can adapt the workflow depending on your use case. Common customizations include: adjusting subscriber or view thresholds discovering smaller emerging creators by lowering filters adding additional data fields such as video titles or upload dates integrating notification tools like Slack when new channels are discovered exporting results to databases or CRM systems Because the workflow is built in n8n, you can easily extend it to support more advanced creator discovery or automation pipelines.
by Matthew
Instagram Hashtag Lead Generation Automate the process of finding and qualifying Instagram leads based on hashtags. This workflow reads hashtags from Google Sheets, scrapes Instagram for posts using Apify, analyzes caption content and language, compiles unique usernames, gathers detailed user info, and filters leads based on follower count. How It Works Fetch Hashtags The workflow starts and pulls a list of hashtags from a Google Sheet. Scrape Instagram Posts For each hashtag, it builds Instagram explore URLs and scrapes posts using Apify. Analyze Captions Each caption is cleaned, hashtags and links are removed, and language/content is analyzed (English/French/Spanish). Extract & Filter Usernames Usernames are combined and deduplicated, their Instagram profiles scraped for follower counts and other details. Qualified Leads Only users with followers in your target range are kept as qualified leads for outreach or analysis. Requirements An n8n instance. Apify API key. Google account with a Sheet containing hashtags. Apify Instagram Scraper actor access. The Google Sheet should have a column with hashtags. Setup Instructions Add Credentials In n8n, add your Apify API key and Google Sheets credentials. Configure Google Sheets Nodes Choose your credentials, spreadsheet, and sheet name in the “Get list of Hashtags” node. Configure Apify Request Nodes Enter your Apify API key and select the Instagram scraper actors. Adjust Filtering Edit the min/max follower count in the relevant filter node to match your needs. Test & Run Manually execute the workflow or add a trigger to run on a schedule. Customization Options 💡 Trigger:** Add a schedule or webhook to automate execution. Language Filtering:** Modify keyword lists or add language detection logic. Lead Output:** Extend the workflow to save leads to a CRM or send notifications. Details Nodes used in workflow: Manual Trigger Google Sheets Code HTTP Request (Apify) IF (Conditional) Aggregate Remove Duplicates Sticky Note
by TAKUTO ISHIKAWA
Generate AI math RPG quests from study logs in Google Sheets Who it's for This template is for educators, parents, or self-learners who want to gamify their study routines. It turns boring study logs into an interactive RPG math battle using AI. How it works This system consists of two workflows (Part 1: Quest Generation, Part 2: Quiz Battle). In this workflow, when a user submits their study time via an n8n Form, the system logs the data into Google Sheets, calculates total EXP, and retrieves the user's current level. Then, it uses a Basic LLM Chain to generate a math question tailored to that level, along with an RPG-style monster and flavor text. The generated quest is saved back to Google Sheets with a pending status, ready for the user to answer. How to set up Create a Google Sheet with three tabs: StudyLogs, Users, and Quests. Connect your Google Sheets credential and select your spreadsheet in all Google Sheets nodes. Connect your OpenAI or OpenRouter credential. Run the "Study Log Input Form" to generate your first monster! Requirements A Google account (for Google Sheets) An OpenAI or OpenRouter API key How to customize the workflow You can easily change the prompt in the "Generate RPG Quest" node to create language quizzes, history trivia, or any other subject instead of math!
by Pavel Zamorev
Use OpenAI to generate short, memorable brand names for your app and automatically check .com availability — results go straight into Google Sheets. Categories: AI, Marketing Description This n8n workflow helps you find an available .com domain for your product. It uses OpenAI to generate batches of creative, on-brand names (e.g. for a digital wardrobe / closet app, inspired by names like Whering, Acloset, Stylebook), then checks each suggestion via API Ninjas. Available domains are appended to a sheet, taken ones to a separate sheet. On each run it reads both sheets so it never suggests or re-checks the same names. The loop runs until you have at least 15 available domains or hit 10 iterations (20 names per iteration). Good to know API Ninjas* free tier supports *.com only. Under heavy load you may see occasional 502 errors; the workflow uses Continue On Fail and only processes successful responses. Add a **Wait node (200–500 ms) before "Check domain (API Ninjas)" if needed. OpenAI** usage depends on your plan (tokens and rate limits). Each iteration sends one request for 20 names. State is passed through the pipeline so that newly checked domains are excluded in the next iteration — no duplicates in suggestions or in the sheets. How it works Start: Manual Trigger runs Read sheet available and Read sheet closed (in sequence). Build initial state builds alreadyChecked from both sheets and sets totalFound from the available count. Prepare prompt builds a system and user prompt with your app context and the current alreadyChecked list, then Generate names (OpenAI) returns 20 new names. Normalize to domains cleans and turns them into .com domains. Check domain (API Ninjas) checks each name. Merge name and API result combines normalized names with API results (only items with a valid available field). Filter available only and Closed only split results; Append to sheet available and Append to sheet closed write to Google Sheets. State for next run updates totalFound, appends this round’s domains to alreadyChecked, and increments the iteration. Exit or loop stops when totalFound >= 15 or iteration > 10, otherwise loops back to Prepare prompt with the updated state. How to use Use the Manual Trigger to run the workflow. Configure credentials: OpenAI (e.g. OpenAI Vision), Api ninjas (Header Auth, X-Api-Key from api-ninjas.com), and Google Sheets account. In one Google spreadsheet create two sheets named available and closed, each with header row: domain, name. Set this document and sheet names in the four Google Sheets nodes (Read sheet available, Read sheet closed, Append to sheet available, Append to sheet closed). If you see repeated 502s, add a Wait node (200–500 ms) before Check domain (API Ninjas) or enable Retry On Fail on that node. Requirements n8n (2.2.3+ recommended) OpenAI** API key (for name generation) API Ninjas** API key (for domain availability) or other API Google Sheets* (one document with two sheets: *available, **closed; columns: domain, name) Customising this workflow Different niche:* Edit the *Prepare prompt** node to change the app context and style (e.g. another app category, different reference names). The prompt enforces short names (under 14 characters), letters only, and excludes already-checked domains. Target count and iterations:* In *Exit or loop**, change the conditions (e.g. totalFound > 15 to another number, or iteration = 10 to allow more rounds). Other TLDs:** The free API Ninjas tier is .com only; with a paid plan you could extend the workflow to check other zones.
by Parth Pansuriya
Automate SEO Blog Creation with Apify + Google Docs + KIE AI’s Nano Banana API Who’s it for For content creators, SEO specialists, and digital marketers who want to automatically generate SEO-optimized blog posts from trending topics — no manual writing or formatting required. How it works / What it does This workflow turns trending searches into fully structured blog posts using AI: Fetch trending topics from India (or any country) using Apify’s Google Trends scraper. Generate a SEO-optimized blog post with title, meta description, headings, and long-form content using Gemini AI. Refine the System Message (optional) with Gemini AI for better readability and engagement. Create a custom blog image using KIE AI’s Nano Banana API based on the blog title. Automatically insert all content and images into a Google Doc, ready for publishing. How to set up Add your Apify API token in the Google Trends node. Configure Google Docs OAuth2 credentials for the document update node. Add your KIE AI Nano Banana API token for image generation. Schedule the Daily Trigger to your preferred time (default is 8 AM). Requirements Apify API token (for trending search scraping) Google account with Docs access KIE AI Nano Banana API token How to customize the workflow Change country or timeframe for trending searches. Update the AI prompt for tone, length, or style of the blog. Change the Google Doc ID to insert content into a different document. Adjust image generation settings (size, style) in the KIE AI node.
by Naveen Choudhary
This workflow automatically enriches company domain lists with comprehensive business information using Perplexity AI's research capabilities and organizes the data in Google Sheets for easy analysis and use. Who's it for Sales teams** building prospect databases with accurate contact information Marketing professionals** researching target companies for campaigns Business development teams** gathering competitive intelligence Data analysts** enriching existing company datasets Researchers** collecting business information for market analysis How it works The workflow reads unprocessed company domains from a Google Sheets document, processes them in batches of 10 using Perplexity AI to research detailed business information, then saves the enriched data back to the spreadsheet. It focuses on German addresses but can be customized for any region. What it does Fetches unprocessed domains - Reads company domains from Google Sheets that haven't been processed yet Batches for efficiency - Groups domains into batches of 10 to optimize API costs and performance AI-powered research - Uses Perplexity AI to find comprehensive business data for each company Parses structured data - Converts AI responses into clean, structured JSON format Updates spreadsheet - Saves enriched data and marks domains as processed to prevent duplicates Requirements Perplexity AI API key** (Get one here) Google Sheets API access** (OAuth2 credentials) Google Sheets template** - Make a copy of this template How to set up Make a copy of the template Google Sheet and update the document ID in both Google Sheets nodes Configure Perplexity AI credentials in the HTTP Request node Set up Google Sheets OAuth2 authentication Add your company domains to the "domain" column in the Data tab Leave the "processed" column empty for new domains Run the workflow using the manual trigger How to customize the workflow Change target region**: Modify the AI prompt to research addresses in different countries Adjust batch size**: Change the batch size in the "Batch Process Domains" node (smaller batches = lower costs) Add custom fields**: Extend the AI prompt and Google Sheets mapping to include additional data points Automate execution**: Replace Manual Trigger with Schedule Trigger for regular processing Filter criteria**: Modify the Google Sheets filter to process specific subsets of domains Output data includes Complete company address (street, city, state, postal code, country) International phone number format Latest employee count and annual revenue (USD) Industry classification LinkedIn company URL Reliable source URL for verification Processing status tracking
by Fahmi Fahreza
AI-Powered Product Video Generator (Foreplay + Gemini + Sora 2) Sign Up For Foreplay HERE Automatically generate personalized, cinematic-quality product videos using Foreplay’s ad data, Google Gemini AI for creative prompts, and Sora 2 for text-to-video generation. Who’s it for? Perfect for marketers, brand managers, or creators who want to produce quick, high-quality video ads without manual scripting or editing. How it works Fetch product data and related competitor videos from Foreplay. Use Gemini AI to generate creative text-to-video prompts. Send the prompt and image to Kie.ai to generate a short, cinematic product video. Save the finished video automatically to Google Drive. How to set up Connect your Foreplay, Google Drive, Gemini, and Kie.ai credentials. Set your product image folder's permission (Google Drive) as public. Add your API keys inside the Set Workflow Credentials node. Then run the workflow manually to generate your first video ad!
by Jemee
This workflow automates the extraction of SEO metadata (URL, page title, and meta description) from every page listed in your website's sitemap and exports it to Google Sheets. Ideal for SEO audits, content inventories, and tracking on-page elements. Prerequisites Before using this workflow: A publicly accessible sitemap.xml URL Google Sheets spreadsheet with columns: URL, Title, and meta description Google Sheets API access via OAuth2 Setup Instructions 1. Configure Sitemap Source In the "Get Sitemap XML" node, replace the default URL with your actual sitemap URL 2. Connect Google Sheets Open the "Append or update row in sheet" node Configure Google Sheets credentials Set Document ID and Sheet Name Verify column mappings match your spreadsheet 3. Adjust Rate Limiting (Optional) Modify Wait nodes if encountering 429 errors Increase delay between requests if needed How It Works Trigger: Manual workflow execution Sitemap Fetch: Retrieve sitemap.xml file URL Parsing: Extract all URLs from sitemap Batch Processing: Process URLs in manageable batches Data Extraction: Scrape title and meta description from each page Data Merge: Combine URL with extracted metadata Sheet Update: Append or update rows in Google Sheets using URL as a unique key Features Duplicate Prevention**: Uses appendOrUpdate with URL matching Rate Limiting**: Built-in delays between requests Flexible Processing**: Handles sitemaps of various sizes Easy Customization**: Modify code nodes for additional data extraction Use Cases SEO audits of title and description tags Content migration planning Website content inventory management Ongoing SEO monitoring and reporting