Workflow Templates

This workflow automates the end-to-end process of generating and publishing blog posts from live news headlines. Fetch Headlines – Collects the latest top stories from Google News and GDELT, merges them, and removes duplicates. Headline Selection & Classification – Picks top headlines, checks relevance, and applies style rules. Draft Generation – Uses GPT to create an initial blog article in a natural, human tone. Tone & Expansion – Refines the draft for clarity, length, and style (customized to your own writing voice). Image Generation – Sends the article topic to Leonardo AI, waits for the image to finish rendering, and retrieves the final asset. Publish to WordPress – Uploads the generated image, assigns alt-text, creates a WordPress post with the article and image, and logs the publication to Google Sheets for tracking. Purpose Designed for hands-off content automation, this workflow continuously produces SEO-ready blog posts enriched with AI-generated images and publishes them directly to WordPress. It’s ideal for: Running an automated blog that reacts to trending news. Keeping websites updated with fresh, styled content without manual effort. Creating a repeatable content engine that combines research, writing, and media assets in one pipeline. Setup Instructions: Add Your Credentials Go to Credentials in n8n and create: OpenAI (for article generation) Leonardo AI (for image generation) WordPress (to publish posts) (Optional) Google Sheets (to log published articles) Attach these credentials to the matching nodes in the workflow. Check the WordPress Node Update the WordPress site URL to your own blog. Make sure the category, tags, and status (publish/draft) are set the way you want.

Who's it for Product managers, customer success teams, and UX researchers who collect feedback in Google Sheets and want to automatically categorize and analyze it with sentiment and emotions insights. Ideal for teams processing dozens or hundreds of customer comments daily. Read on Medium Watch on Youtube What it does This workflow automatically tags and analyzes customer feedback stored in Google Sheets using OpenAI's GPT-4. It reads unprocessed feedback entries, sends them in batches to OpenAI for intelligent tagging and sentiment analysis, then writes the results back to your sheet—complete with up to 3 relevant tags per feedback, sentiment scores (Very Negative to Very Positive), and emotional analysis. The workflow uses batch processing to optimize API costs: instead of sending 10 separate requests, it sends one request with all 10 feedbacks, reducing API calls by ~90%. How it works Fetches allowed tags from a Tags sheet and new feedback entries (where Status is empty) from a Feedbacks sheet Merges tags with feedbacks and processes them in batches of 10 Sends each batch to OpenAI with a structured prompt requesting tags, sentiment, and emotional analysis Writes results back to Google Sheets with tags, sentiment, emotions, and timestamps Requirements Google Sheets account with OAuth2 credentials OpenAI API account (uses GPT-4o-mini model) Google Sheet template with two sheets: "Tags" (single column) and "Feedbacks" (with columns: Feedbacks, Status, Tag 1-3, Sentiment, Primary/Secondary Emotion, AI Tag 1-2, Updated Date) Setup instructions Duplicate the provided Google Sheet template Connect your credentials in n8n: Google Sheets OAuth2 API OpenAI API Update Sheet URLs in these nodes: "Fetch Allowed Tags" - point to your Tags sheet "Fetch New Feedbacks" - point to your Feedbacks sheet "Update Google Sheet (Tagged)" - point to your Feedbacks sheet Test manually first using the Manual Trigger, then enable the Schedule Trigger for automatic processing every 60 minutes How to customize Adjust batch size**: Change the batch size in "Process Feedbacks in Batches" (default: 10) to process more or fewer feedbacks per API call Modify tagging logic**: Edit the system prompt in "Tag Feedbacks with AI" to change how tags are selected or add custom sentiment categories Change schedule**: Update the Schedule Trigger interval (default: 60 minutes) based on your feedback volume Extend the workflow**: Add nodes to send results to Slack, Notion, or Airtable for real-time alerts on negative feedback

Who is this template for? This template is designed for link building. When you reach out to some small blogs it is common for the owner to have an address like DomainName@gmail.com. This workflow will find such emails for you. What problem does this workflow solve? Get from a list of domain names to a list of email addresses. This is perfect to prepare a cold outreach campaign for link building. This workflow allows you to find email addresses with any extension. I recommend searching for Gmail as a starting Point. But you can also use workflow to check for other email providers. Pro-tip: Check the email provider used in the geography you target: Lapost.net for France Seznam.cz for Czechia What this workflow does This workflow will: Generate email candidates based on the domain name and root you are providing Check if those email addresses are valid using EmailListVerify ##Requirement This template uses: Google Sheet to handle input and output data EmailListVerify to discover email (from $0.05 per email) Setup (10 minutes) 1: Make a copy of the GoogleSheet template 2: In "[Input] pattern" sheet write the email extension you want to check. Gmail is a no-brainer. Depending on the location you target, you might want to include local email providers like laposte.net for France. 3: In "[Input] domain" put the domain for which you want to find email addresses. 4: Add your EmailListVerify API key to setting to the 3rd step 5: Update Google Sheet node to point to your copy of the template 6: Trigger the workflow

This workflow automates the process of finding YouTube creator contact emails for outreach and partnerships. It combines Apify scrapers with OpenAI to deliver a clean list of emails from channel descriptions: Step 1:** Search YouTube with Apify based on a keyword or topic Step 2:** Scrape each channel for descriptions and metadata Step 3:** Use OpenAI to extract and format valid email addresses into a structured JSON output This is useful for influencer outreach, creator collaborations, UGC sourcing, or lead generation — all automated inside n8n. ⚙️ Setup Instructions 1️⃣ Set Up OpenAI Connection Go to OpenAI Platform Navigate to OpenAI Billing Add funds to your billing account Copy your API key into the OpenAI credentials in n8n 2️⃣ Set Up Apify Connection Go to Apify Console and sign up/login Get your API token here: Apify API Keys Set up the two scrapers in your Apify account: YouTube Scraper by streamers YouTube Scraper by apidojo In n8n, create a HTTP Query Auth credential Query Key: token Value: YOUR_APIFY_API_KEY Attach this credential to both HTTP Request nodes (Search YouTube and Scrape Channels) 📬 Contact Information Need help customizing this workflow or building similar automations? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com

This n8n template auto-enriches brand-new HubSpot contacts with company details. Each day it finds contacts created in the last 24 hours (skipping free email domains), researches the company from the contact’s email domain, and writes back clean fields—no manual lookup needed. Perfect for GTM teams that want better segmentation and faster personalization from day one. How it works A daily schedule trigger starts the workflow. HubSpot: Get recently created/updated contacts** pulls the newest records. A filter keeps only contacts: created within the last 24 hours whose email domain doesn’t contain gmail.com (adjust as needed). An AI research agent (Gemini + SerpAPI): extracts the company domain from the contact’s email searches the web and returns structured JSON: company_name, industry, headquarters_city, headquarters_country, employee_count, website, linkedin, description HubSpot: Add company info** updates the contact with the enriched fields. How to use Connect HubSpot on both HubSpot nodes (OAuth2). Connect SerpAPI (paste your API key). Connect Google Gemini (Google AI Studio API key). (Optional) Edit the agent prompt to fetch more/different fields. (Optional) Tweak the filter to include/exclude other domains. Activate the workflow to run daily. Requirements HubSpot** (OAuth2) for reading/updating contacts SerpAPI** for web search results Google Gemini** for company profiling and structured output Notes & customization Free domains:** Add more exclusions (e.g., yahoo.com, outlook.com) to reduce false positives. Confidence gating:** Require website + LinkedIn before writing to HubSpot, or route low-confidence results for manual review. Field mapping:** Extend the update step with additional properties (e.g., industry tags, HQ timezone). Frequency:** Switch the trigger to hourly for faster enrichment on high-volume inbound. Data hygiene:** Normalize employee count ranges and country names to your CRM picklists.

This workflow fetches recent emails from Outlook and uses OpenAI to assign a category (e.g., Red, Yellow, Green). It then updates each message’s category in Outlook. ⚙️ Setup Instructions 1️⃣ Set Up Outlook Connection In n8n → Credentials → New → Microsoft Outlook OAuth2 API Log in with your Outlook account & approve access Attach this credential to the Get Messages from Outlook and Update Category nodes in the workflow (Optional) Adjust the limit field in Get Messages from Outlook if you want more/less than 5 results 2️⃣ Set Up OpenAI Connection Go to the OpenAI Platform Navigate to OpenAI Billing Add funds to your billing account Copy your API key into the OpenAI credentials in n8n and select it on the OpenAI Chat Model and Categorizing Agent nodes ✅ Notes The agent reads subject + bodyPreview and returns a JSON category. The Update Category node writes that category back to Outlook. You can tweak the category names or logic in the Categorizing Agent system message. 📬 Contact Need help customizing the categorization rules or routing categories to folders? 📧 robert@ynteractive.com 🔗 Robert Breen 🌐 ynteractive.com

Daily ETH Wallet Balance & Holdings Alerts Never miss a snapshot of your (or others) ETH wallet, this workflow polls your wallet on a schedule, fetches balances and current ETH prices, formats a concise summary, and posts it to Discord (or email/Slack/Telegram). Easy to customize to track multiple wallets, tokens, or alert on thresholds. How it works Schedule Trigger - Runs on your cadence (default: morning and evening). Query Blockchain - Calls Etherscan (or another API) to get wallet balances and token holdings. Process Balances - Calculates totals and converts values using CoinGecko price lookups. Format Summary - Creates a readable report (holdings, USD value, % change, etc.). Deliver Alert - Sends the snapshot to Discord (swap in Slack/Telegram/email/webhook as needed). Quick setup notes Add your Etherscan (or preferred) API key and CoinGecko key where indicated. Set the wallet address(es) in the code node(s) supports one or many. Adjust the schedule, number of snapshots, and message format to suit your needs. Use cases / variations Single-wallet daily snapshot** - Quick morning/evening balances. Multi-wallet portfolio digest** - Aggregate several addresses into one report. Token breakdown** - Show ERC-20 token amounts and fiat values. Price/threshold alerts** - Ping when ETH or a token crosses a set price or % change. On-demand reporting** - Trigger via webhook or command to pull a live snapshot. NFT & token inventory** - Report owned collections and token counts. Tax / bookkeeping exports** - Add CSV output for record-keeping. Why use this Hands-off monitoring** - automated snapshots replace manual checks. Customizable** - swap APIs, add wallets, or change channels in minutes. Actionable** - get the data you need (holdings, fiat value, alerts) where you already work.

AI-Powered Lead Generation: Personalized Icebreakers with Perplexity Research & Claude Sonnet 4.5 This production-ready workflow transforms your lead generation by automatically researching prospects and generating genuinely personalized icebreakers that feel human-written. What normally takes 10-15 minutes per lead now happens in under a minute, at scale. 🎯 What It Does: Pulls lead data from Google Sheets, conducts real-time AI research on each prospect, and generates custom cold email opening lines that reference actual company achievements and recent news. The workflow processes leads in batches, updates your spreadsheet automatically, and maintains context throughout the entire process. Automated Research**: Perplexity Sonar searches the web for current information about each prospect and their company Company Name Standardization**: GPT-4o-mini cleans up corporate names to sound natural ("Sharp Guys Web Design Agency" becomes "Sharp Guys") Personalized Icebreakers**: Claude Sonnet 4 crafts opening lines that reference real achievements in a casual, bar-conversation tone Smart Processing**: Filters already-processed leads, handles batches of 25, and safely updates your spreadsheet Cost Effective**: Approximately $0.02 per lead with typical 2-3x response rate improvement 💡 Use Cases & Results: Perfect for: B2B sales teams, marketing agencies, business development, recruiters, freelancers, startup founders doing cold outreach. Expected results: 2-3x response rate improvement ~$0.02 per lead cost 10-15 min → 30-60 sec per lead Why it works: Icebreakers reference real, current information vs generic templates. Prospects notice the personalization. 🔧 How It Works: The workflow follows a six-step process. First, it retrieves lead data from your Google Sheets and filters out any leads that already have icebreakers to avoid reprocessing. Then it processes leads in manageable batches of 25 to respect API rate limits while maintaining efficiency. For each lead, the system standardizes the company name by removing corporate suffixes like "Agency," "Inc.," or "Group" to make icebreakers sound more natural. Next, Perplexity Sonar conducts real-time web research on the prospect, finding recent company news, achievements, funding rounds, and relevant background information. Claude Sonnet 4 then analyzes this research and generates a personalized icebreaker that sounds genuinely human-written. The prompt instructs Claude to use a casual, spartan tone and to look for plausible connections without stretching the truth. Each icebreaker follows a proven format: "Hey [FirstName], [specific observation about their company], I wanted to share something that could be relevant for [Company]." Finally, the workflow updates your spreadsheet with both the cleaned company name and the personalized icebreaker, then loops back to process the next batch until all unprocessed leads are complete. ✨ Key Features: Real-time research**: Perplexity Sonar accesses current web data for the most relevant, up-to-date information Natural language**: Icebreakers reference real achievements in conversational tone, not corporate speak Batch processing**: Handles 25 leads at a time with automatic looping for any volume Smart filtering**: Skips leads that already have icebreakers, enabling easy reruns with new data JSON output**: Structured format ready for integration with cold email tools Resume capability**: Can stop and restart anytime without losing progress Quality assurance**: AI models are specifically chosen for their strengths (speed, research, writing) 📋 Requirements: Google Sheets with lead data (columns: id, first_name, last_name, title, organization_name, Icebreaker, company_name_cleanup) OpenAI API key (for GPT-4o-mini company name cleanup) OpenRouter account with credits (for Perplexity Sonar and Claude Sonnet 4 access) n8n Cloud or self-hosted instance ⚡ Quick Setup: Prepare your Google Sheets spreadsheet with the required columns and fill in your lead data. Connect your Google Sheets, OpenAI, and OpenRouter credentials to n8n. Configure the "Get Leads" and "Update Icebreaker" nodes to point to your spreadsheet. Test with a couple of leads first to ensure everything works, then run the full workflow. The workflow includes comprehensive documentation via sticky notes covering data structure, AI model selection rationale, customization options, cost analysis. 🎁 What You Get: Complete end-to-end automation with detailed sticky note documentation explaining each step, customizable prompts for adjusting tone and style, batch processing logic that respects API limits, error handling and retry mechanisms, cost optimization using the right AI model for each task (GPT-4o-mini for simple transformations, Perplexity for research, Claude for writing), and security best practices for handling lead data responsibly. 💰 Expected Results: At approximately $0.02 per lead, this workflow typically delivers response rate improvements of 2-3x compared to generic templates. For a hundred leads, you invest about $2 and save over fifteen hours of manual research and writing time. The icebreakers sound genuinely human because they reference real, current information rather than generic templates. Many users report that prospects often respond positively to the personalized opening, commenting that it doesn't feel like a mass email. 🔄 Integration Ready: The output format is designed to integrate seamlessly with popular cold email tools like Instantly, Lemlist, Smartlead, and others. Simply export your updated spreadsheet and import the icebreakers into your outreach sequences. The casual tone and specific details make these icebreakers perfect for relationship-building campaigns where authenticity matters. Icebreaker Examples: https://docs.google.com/spreadsheets/d/1_oxNW4l54fVjxq6Y62xR_yqqQK6O3gCsmqmBhO2ei1Y/edit?usp=sharing

Who's it for Professionals and teams managing high email volumes who need automatic email triage and responses. What it does This workflow monitors your Outlook inbox and uses AI to classify emails into three urgency levels: Urgent, Important, or Not Important. It automatically generates personalized replies and organizes emails into folders. How it works New emails trigger AI classification based on urgency and deadlines. The system then generates an appropriate reply using GPT-4 and moves the email to the corresponding folder. Requirements Microsoft Outlook account with API access OpenAI API key (GPT-4 access) Three Outlook folders: URGENT, Important, Not Important Setup Connect your Outlook credentials, add your OpenAI API key to all Chat Model nodes, update folder IDs in the Move nodes, and customize the AI prompts to match your tone. Customization Adjust classification criteria, modify reply tone and style, add more categories, or integrate with other tools like Slack or CRM systems.

How it works This workflow automatically pulls daily signup stats from your PostgreSQL database and shares them with your team across multiple channels. Every morning, it counts the number of new signups in the last 24 hours, formats the results into a concise report, and posts it to Slack, Microsoft Teams, and Telegram. This ensures your entire team stays updated on customer growth without manual queries or reporting. Step-by-step Daily Trigger & Data Fetching The Daily Report Trigger runs at 9:00 AM each day. The Fetch Signup Count node queries the customers table in PostgreSQL. It calculates the number of new signups in the last 24 hours using the created_at timestamp column. Report Preparation The Prepare Report Message node formats the results into a structured message: Report date Signup count A clear summary line: Daily Signup Report – New signups in the last 24h: X Multi-Channel Delivery The prepared message is sent to multiple platforms simultaneously: Slack Microsoft Teams Telegram This ensures all teams receive the update in their preferred communication tool. Why use this? Automates daily customer growth reporting. Eliminates manual SQL queries and report sharing. Keeps the whole team aligned with real-time growth metrics. Delivers updates across Slack, Teams, and Telegram at once. Provides simple, consistent reporting every day.

This n8n workflow automatically fetches top technology news from Google News, summarizes it using AI, and sends a daily email with key updates. Users get a concise overview of important tech developments every morning. Good to know: Focuses specifically on technology news. Summarizes multiple sources into one concise email. Ensures consistent and easy-to-read formatting. Handles updates from different websites reliably. How it works Trigger: Schedule Daily Tech News Runs automatically every morning at 8 AM. Fetch Google Tech News Retrieves the latest tech news from Google News. Extract Tech News Articles Parses the HTML to extract headlines, source, and timestamps. Format Tech News Data Prepares structured data ready for AI analysis. Check If News Found If no news is found, sends an error alert email. Otherwise, continues to AI summarization. AI Tech News Analyzer Uses an AI model to summarize and highlight key trends. Send Tech News Email Sends a formatted daily email with summarized tech news. Send Error Alert (optional) Sends an alert email if no news can be found. Email Examples Output Email Example: Subject: 🌐 Daily Tech News Summary - August 14, 2025 📌 Top Technology Headlines Today: AI-powered tools are revolutionizing cloud computing. (Source: TechCrunch) Startup funding in India sees record growth. (Source: Economic Times) New smartphone launches include innovative camera features. (Source: The Verge) Cybersecurity threats increase amid remote work trends. (Source: Wired) 🗓️ Summary Date: August 14, 2025 How to use Setup Instructions: Import workflow into your n8n instance. Configure SMTP credentials for sending emails. Set the schedule to run daily at your preferred time. Test the workflow to ensure news is fetched and the email is sent correctly. Requirements: n8n instance (cloud or self-hosted). Email account with SMTP access. Reliable internet connection. Access to Google News. Troubleshooting: No news found:** Check internet connection and Google News accessibility. Email not sent:** Verify SMTP credentials. AI summarization errors:** Check model credentials and API usage.

How it works Receives chat messages from customers requesting table reservations. Uses an AI Agent with OpenAI Chat Model to understand and process requests. Checks table information, availability, and existing reservations from Google Sheets. Calculates guest counts and reservation timing using the Calculator node. Updates table availability and reservation records in real-time. Handles reservation changes, including updates and cancellations. Set up steps Add credentials** for OpenAI (Chat Model) and Google Sheets. In the AI Agent node, link: Chat Model → OpenAI Chat Model node. Memory → Simple Memory node. Tools → Calculator and Google Sheets nodes for reservation data handling. Configure Google Sheets nodes: Get Table Information (read sheet) Get Table Availability (read sheet) Get Table Reservations (read sheet) Update Table Availability (update sheet) Update Reservations (append sheet) Cancel Reservations (delete sheet) Ensure your sheets have consistent column names for table IDs, dates, times, and guest counts. Test by sending a reservation request through the chat trigger and verify updates in the Google Sheets.