Workflow Templates

Who Is This For? This workflow is perfect for content creators, marketers, and business professionals who receive regular newsletters and want to effortlessly convert them into engaging LinkedIn posts. By automating the extraction and repurposing process, you can save time and consistently share thoughtful updates with your network. What Problem Does This Workflow Solve? Manually reading newsletters, extracting the key points, and then formatting that content into professional, engaging LinkedIn posts can be time-consuming and error-prone. This workflow automates those steps by: Filtering Emails:** Uses the Gmail node to process only those emails from a specific sender (e.g., newsletter@example.com). Extracting Content:** Leverages OpenAI to identify and summarize the top news items in your newsletter. Generating Posts:** Crafts concise, insightful LinkedIn posts in a smart, deadpan style with a touch of subtle humor. Publishing:** Posts the generated content directly to LinkedIn. What This Workflow Does Filter Newsletters:** The Gmail node is set up to only handle emails from your chosen sender, ensuring that only relevant newsletters are processed. Extract Key Content:** An OpenAI node analyzes the newsletter text to pull out the most important news items, including headlines and summaries. Split Content:** A Split Out node divides the extracted content so each news item is processed on its own. Generate LinkedIn Posts:** Another OpenAI node takes each news item's details and produces a well-structured LinkedIn post that delivers practical insights and ends with a reflective observation or question. Publish to LinkedIn:** The LinkedIn node publishes the crafted posts directly to your account. Setup Gmail Node: Rename it to “Filter Gmail Newsletter” and configure it to filter emails by your newsletter sender. OpenAI Nodes: Ensure your OpenAI API credentials are set up correctly. Customize the prompt if needed to match your desired tone. LinkedIn Node: Rename it to “Post to LinkedIn” and confirm that your LinkedIn OAuth2 credentials are properly configured. How to Customize OpenAI Prompts:** Adjust the prompts in the OpenAI nodes to fine-tune the post tone and output formatting. Email Filter:** Change the Gmail filter to match the sender of your newsletters. Post Processing:** Optionally, add extra formatting (using Function nodes) to further enhance the readability of the generated LinkedIn posts. This template offers an automated, hands-off solution to transform your newsletter content into engaging LinkedIn updates, keeping your audience informed and inspired with minimal effort.

This is a very simple workflow that lets you subscribe to any github repository for the latest release (using n8n as example). How it works: daily poll to Github repository for release for latest (stable) version of n8n parses the content to HTML sends a gmail Setup steps: add your gmail credentials (or use other email node of choice) change the url to the right Github repository you want to check regularly change the To email address to the email that you want to receive the updates for Feedback & Questions If you have any questions or feedback about this workflow - Feel free to get in touch at ria@n8n.io

This n8n template demonstrates how to create an intelligent food recipe assistant that accepts requests via Gmail and web forms, processes them using AI chat models (Ollama and Llama 3.2), and delivers personalized recipes back to users. The system combines multiple input methods with advanced AI processing to provide customized cooking instructions and ingredient lists. Good to know The system accepts recipe requests through both Gmail and web form submissions AI models understand dietary restrictions, cuisine preferences, and cooking skill levels Recipe responses include formatted ingredients, step-by-step instructions, and cooking tips All requests are processed automatically without manual intervention How it works Gmail Recipe Request Workflow Gmail triggers activate when users send emails with recipe requests to the designated email address The system extracts recipe requirements, dietary preferences, and cooking constraints from email content User queries are processed through the Ollama Recipe Generator for intelligent recipe creation AI-generated recipes are formatted with proper ingredients, instructions, and cooking times Formatted recipes are sent back to users via Gmail with a professional presentation Web Form Recipe Request Workflow Web form submissions trigger when users fill out structured recipe request forms Form data includes cuisine type, dietary restrictions, available ingredients, and cooking time preferences The Llama 3.2 Chef Model processes structured requests for optimized recipe generation Recipes are formatted with clear instructions, ingredient measurements, and cooking techniques Users receive formatted recipes via email with additional cooking tips and variations How to use Import the workflow into your n8n instance and configure Gmail integration for recipe requests Set up the web form with fields for cuisine preferences, dietary restrictions, and cooking skill level Configure Ollama and Llama 3.2 AI models with appropriate recipe generation prompts Test both Gmail and web form inputs with sample recipe requests Customize email templates to match your brand and include additional cooking resources The system scales automatically to handle multiple simultaneous recipe requests Requirements Gmail account for email-based recipe requests and responses Ollama installation with Recipe Generator model Llama 3.2 Chef Model access for advanced recipe processing n8n instance with Gmail and AI model integrations Customising this workflow Recipe automation can be adapted for different cuisines, dietary needs, and cooking skill levels Try popular use-cases such as meal planning assistance, ingredient substitution suggestions, or nutritional information inclusion The workflow can be extended to include recipe image generation, shopping list creation, and cooking video recommendations

⚡ AI Copywriter Pro: Instant Ad Copy & CTA Generator Transform product details into compelling marketing copy in seconds. This intelligent n8n workflow takes basic product information and generates professional ad copy with powerful calls-to-action using GPT-4, then distributes the results to your team via Slack or stores them in Airtable for future use. 🚀 How It Works This streamlined 4-step automation delivers professional marketing copy instantly: Step 1: Simple Form Input Users submit basic product information through a clean web form - just product name and key features required. Step 2: AI-Powered Generation The workflow sends product details to GPT-4 with a specialized copywriting prompt that creates: Compelling 2-sentence ad copy optimized for conversions 3 powerful call-to-action phrases with different urgency levels Professional tone tailored for marketing campaigns Step 3: Structured Processing The AI response is automatically parsed into clean, labeled fields ready for immediate use across marketing channels. Step 4: Multi-Channel Distribution Generated content is simultaneously: Posted to your designated Slack channel for team review Logged in Airtable for campaign tracking and reuse ⚙️ Setup Steps Prerequisites Active OpenAI API account with GPT-4 access Slack workspace with admin permissions Airtable account for content storage n8n instance (cloud or self-hosted) Configuration Steps 1. Credential Setup OpenAI API Key**: Required for GPT-4 content generation Slack OAuth2**: Needed for posting messages to channels Airtable Personal Access Token**: Essential for database operations 2. Form Configuration The workflow automatically generates a web form at: your-n8n-instance.com/form/[webhook-id] Form fields are pre-configured for: Product Name (text input) Product Features (textarea for detailed descriptions) Form can be embedded on websites or shared as standalone link 3. Slack Integration Setup Connect your Slack workspace to n8n Create or select target channel for ad copy notifications Update the channelId parameter with your channel's ID Test connection with sample message 4. Airtable Database Preparation Create new base or use existing one Set up table with columns: Product Name (Single line text) Product Features (Long text) Ad Copy (Long text) CTAs (Long text) Copy base and table IDs from Airtable URLs Update workflow parameters accordingly 5. AI Prompt Customization The default prompt generates versatile marketing copy, but you can customize for: Industry-specific terminology Brand voice and tone Target audience demographics Campaign objectives (awareness, conversion, retention) 🎯 Use Cases E-commerce & Retail Product Launch Campaigns**: Generate copy for new product announcements Seasonal Promotions**: Create urgency-driven messaging for sales events Category Pages**: Develop compelling descriptions for product collections Social Media Ads**: Produce scroll-stopping copy for Facebook and Instagram SaaS & Technology Feature Announcements**: Craft clear, benefit-focused messaging Free Trial Campaigns**: Generate conversion-optimized trial signup copy Case Study Promotions**: Create compelling success story headlines Webinar Marketing**: Develop registration-driving event descriptions Agency & Freelance Client Presentations**: Rapidly prototype copy concepts for pitches A/B Testing**: Generate multiple copy variations for campaign testing Campaign Brainstorming**: Kickstart creative sessions with AI-generated ideas Content Calendar Filling**: Populate social media schedules efficiently Startup & Small Business MVP Marketing**: Create professional copy without hiring agencies Investor Pitches**: Generate compelling product descriptions Website Content**: Populate landing pages with conversion-focused copy Email Campaigns**: Develop subject lines and promotional content Content Marketing Blog Post Promotions**: Generate social media copy for article shares Newsletter CTAs**: Create compelling subscription and engagement prompts Video Descriptions**: Develop YouTube and social video copy Podcast Promotions**: Generate episode descriptions and listener CTAs 🔧 Advanced Customization Options Multi-Tone Generation Modify the prompt to generate different copy styles: Professional & Corporate: "Generate formal, trust-building copy..." Casual & Friendly: "Create conversational, approachable messaging..." Urgent & Scarcity: "Develop time-sensitive, action-driving copy..." Luxury & Premium: "Craft sophisticated, high-end positioning..." Batch Processing Enhancement Add nodes for processing multiple products: Split in Batches**: Handle bulk product lists Merge**: Combine results for team review Item Lists**: Process CSV uploads of product catalogs Quality Control Integration Implement approval workflows: Human Review Step**: Add manual approval before publishing Sentiment Analysis**: Score copy for emotional impact Brand Guidelines Check**: Validate against company voice standards A/B Test Setup**: Generate multiple variations automatically Extended Distribution Connect additional platforms: Email Marketing**: Send to Mailchimp, ConvertKit, or HubSpot Social Media**: Post directly to Facebook, Twitter, LinkedIn CMS Integration**: Push to WordPress, Webflow, or custom sites Project Management**: Create tasks in Asana, Trello, or Monday.com 📊 Output Examples Sample Input: Product Name: EcoSmart Water Bottle Product Features: Self-cleaning UV technology, 24-hour temperature retention, BPA-free stainless steel, leak-proof design, 500ml capacity Generated Ad Copy: Stay hydrated and eco-conscious with the EcoSmart Water Bottle—featuring revolutionary self-cleaning UV technology that eliminates 99.9% of bacteria while keeping your drinks perfectly chilled for 24 hours! Experience the future of hydration with premium stainless steel construction that's as durable as it is sustainable. CTAs: • Order Your EcoSmart Bottle Today • Join the Clean Hydration Revolution • Get 24-Hour Freshness Now Slack Notification Format: 🎯 NEW AD COPY GENERATED Product: EcoSmart Water Bottle 📝 Ad Copy: Stay hydrated and eco-conscious with the EcoSmart Water Bottle—featuring revolutionary self-cleaning UV technology that eliminates 99.9% of bacteria while keeping your drinks perfectly chilled for 24 hours! Experience the future of hydration with premium stainless steel construction that's as durable as it is sustainable. 🔥 Call-to-Actions: • Order Your EcoSmart Bottle Today • Join the Clean Hydration Revolution • Get 24-Hour Freshness Now Ready to use in campaigns! 🚀 🛠️ Troubleshooting & Best Practices Common Issues & Solutions API Rate Limits Monitor OpenAI usage dashboard Implement delay nodes for high-volume processing Consider upgrading to higher tier plans Inconsistent Output Quality Refine prompts with specific examples Add output validation rules Include brand guidelines in system prompt Integration Failures Verify all API credentials are current Test connections individually before full workflow Check service status pages for outages Optimization Strategies Cost Management Use GPT-4o-mini for routine copy generation Reserve GPT-4 for premium campaigns Cache common responses to reduce API calls Quality Enhancement A/B test different prompt variations Collect team feedback on generated copy Maintain library of high-performing examples Workflow Efficiency Set up monitoring alerts for failures Create backup workflows for critical campaigns Document customizations for team reference 📈 Performance Tracking Key Metrics to Monitor Generation Speed**: Average time from input to output Approval Rate**: Percentage of AI copy used without edits Campaign Performance**: Click-through rates of AI-generated content Cost Per Copy**: API costs per generated piece Success Indicators Reduced copywriting turnaround time (target: under 30 seconds) Increased campaign launch frequency Higher team satisfaction with copy quality Measurable improvement in conversion rates 📞 Questions & Support Need help setting up or customizing your AI Copywriter Pro workflow? 📧 Direct Support Email**: Yaron@nofluff.online Response Time**: Within 24 hours on business days Specialties**: Custom prompt engineering, integration troubleshooting, workflow optimization 🎥 Video Tutorials YouTube Channel**: https://www.youtube.com/@YaronBeen/videos Complete setup walkthrough Advanced customization techniques Integration with popular marketing tools Prompt engineering masterclass 🤝 Professional Network LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Connect for ongoing automation support Share your copywriting success stories Get early access to new workflow templates 💬 What to Include in Support Requests Your specific industry or use case Current marketing tools and platforms Sample products you want to test with Any custom requirements or brand guidelines Screenshots of any errors or unexpected outputs Ready to revolutionize your copywriting process? Deploy this workflow and watch your marketing team's productivity soar while maintaining professional, conversion-focused messaging!

AI-Powered Proposal Generator - Sales Automation Workflow Overview This n8n workflow automates the entire proposal generation process using AI, transforming client requirements into professional, customized proposals delivered via email in seconds. Use Case Perfect for agencies, consultants, and sales teams who need to generate high-quality proposals quickly. Instead of spending hours writing proposals manually, this workflow captures client information through a web form and uses GPT-4 to generate contextually relevant, professional proposals. How It Works Form Trigger - Captures client information through a customizable web form OpenAI Integration - Processes form data and generates structured proposal content Google Drive - Creates a copy of your proposal template Google Slides - Populates the template with AI-generated content Gmail - Automatically sends the completed proposal to the client Key Features AI Content Generation**: Uses GPT-4 to create personalized proposal content Professional Templates**: Integrates with Google Slides for polished presentations Automated Delivery**: Sends proposals directly to clients via email Form Integration**: Captures all necessary client data through web forms Customizable Output**: Generates structured proposals with multiple sections Template Sections Generated Proposal title and description Problem summary analysis Three-part solution breakdown Project scope details Milestone timeline with dates Cost integration Requirements n8n instance** (cloud or self-hosted) OpenAI API key** for content generation Google Workspace account** for Slides and Gmail Basic n8n knowledge** for setup and customization Setup Complexity Intermediate - Requires API credentials setup and basic workflow customization Benefits Time Savings**: Reduces proposal creation from hours to minutes Consistency**: Ensures all proposals follow the same professional structure Personalization**: AI analyzes client needs for relevant content Automation**: Eliminates manual copy-paste and formatting work Scalability**: Handle multiple proposal requests simultaneously Customization Options Modify AI prompts for different industries or services Customize Google Slides template design Adjust form fields for specific information needs Personalize email templates and signatures Configure milestone templates for different project types Error Handling Includes basic error handling for API failures and form validation to ensure reliable operation. Security Notes All credentials have been removed from this template. Users must configure their own: OpenAI API credentials Google OAuth2 connections for Slides, Drive, and Gmail Form webhook configuration This workflow demonstrates practical AI integration in business processes and showcases n8n's capabilities for complex automation scenarios.

Who is this for? Professionals and individuals who receive high volumes of emails, those who want to automatically organize their Gmail inbox using AI classification. What problem is this workflow solving? Manual email sorting is time-consuming and inconsistent. This workflow automatically categorizes incoming emails into 8 predefined labels (To respond, FYI, Comment, Notification, Meeting update, Awaiting reply, Actioned, Marketing) to help maintain inbox zero and prioritize responses. What this workflow does Monitors Gmail for new incoming emails Uses AI to analyze email content and classify into appropriate categories Automatically applies the corresponding Gmail label Runs on a schedule to process emails consistently Setup Prerequisites n8n instance (cloud or self-hosted) Gmail account with API access enabled Access to an LLM provider (OpenAI, Anthropic Claude, or similar) Step-by-Step Configure Gmail Credentials Create Gmail Labels Configure LLM Chain Set Email Polling Schedule Test the Workflow Create Gmail Labels Before running the workflow, create these 8 labels in your Gmail account: To respond FYI Comment Notification Meeting update Awaiting reply Actioned Marketing How to customize this workflow to your needs Modify Classification Categories To change the email categories, update two places: In the AI prompt (Basic LLM Chain node): Your new category - Description of what emails fit here Another category - Description [... continue with your categories] In Gmail labels: Create corresponding labels in your Gmail account with the exact same names and numbering. Adjust Classification Rules The AI prompt contains specific rules for each category. To modify: Edit the "Key classification rules" section in the LLM prompt Add examples of emails that should go into each category Specify edge cases and how they should be handled Change Email Sources Currently monitors all incoming emails. To filter specific emails: In the Gmail Trigger node, add filters such as: from:specific-sender@domain.com subject:contains-keyword -label:already-processed You can also change this use Outlook Modify Polling Frequency More frequent**: Add multiple poll times (e.g., 9 AM, 12 PM, 6 PM) Less frequent**: Change to once daily or weekly Real-time**: Switch to webhook-based triggering (requires Gmail API setup) I choose daily for cost.

This workflow compares two lists of objects (List A and List B) using a user-specified key (e.g. email, id, domain) and returns: Items common to both lists (based on the key) Items only in List A Items only in List B How it works: Accepts a JSON input containing: listA: the first list of items listB: the second list of items key: the field name to use for comparison Performs a field-based comparison using the specified key Returns a structured output: common: items with matching keys (only one version retained) onlyInA: items found only in List A onlyInB: items found only in List B Example Input: { "key": "email", "listA": [ { "email": "alice@example.com", "name": "Alice" }, { "email": "bob@example.com", "name": "Bob" } ], "listB": [ { "email": "bob@example.com", "name": "Bobby" }, { "email": "carol@example.com", "name": "Carol" } ] } Output: common: [ { "email": "bob@example.com", "name": "Bob" } ] onlyInA: [ { "email": "alice@example.com", "name": "Alice" } ] onlyInB: [ { "email": "carol@example.com", "name": "Carol" } ] Use Cases: Deduplicate data between two sources Find overlapping records Identify new or missing entries across systems This workflow is useful for internal data auditing, list reconciliation, transaction reconciliation, or pre-processing sync jobs.

This workflow is designed for freelancers, solopreneurs, and business owners who receive a high volume of irrelevant messages in their Gmail inbox — from cold offers to spammy promotions — and want to automatically filter and delete them using AI. Its main purpose is to scan new emails with the help of OpenAI, classify their content, and automatically delete those considered marketing (OFFER) or junk (SPAM). The result is a cleaner inbox without the need to manually sift through low-value messages. The classification logic uses a detailed system prompt with practical examples, so even complex or borderline messages are categorized accurately. Important emails — such as payment confirmations, shipping updates, or genuine business inquiries — remain untouched. This helps maintain a professional inbox with only valuable and relevant communication. The entire process runs automatically in the background and can be customized further — for example, to archive instead of delete, or log deleted emails for review. How it works When triggered (every hour), the workflow fetches new Gmail messages using the Gmail Trigger node. Each message is passed to an AI classifier powered by OpenAI, which reads the message body (email snippet) and returns one of three labels: SPAM: Obvious junk messages, scams, or low-effort bulk messages OFFER: Cold outreach, discount promotions, cart reminders, or generic advertising IMPORTANT: Valuable information for the user, even if commercial (e.g., invoices, order updates, personal inquiries) The workflow then routes the result through an IF node. If the message is marked as SPAM or OFFER, it is immediately deleted from Gmail via the Gmail Delete node. Emails marked as IMPORTANT are ignored and remain in the inbox. The classification is entirely AI-driven based on message content — sender address, headers, or metadata are not used. How to set up To get started, simply connect two credentials: A Gmail account using OAuth2 (via the Gmail Trigger and Gmail Delete nodes) An OpenAI API key (used by the AI classifier node) No advanced setup is needed beyond these two connections. Optionally, you can review or modify the system prompt used for classification — it’s available inside the workflow’s LangChain AI Agent node. The prompt is in English, so it’s recommended to use this workflow with English-language emails for best results. By default, the workflow deletes matching emails immediately. If you prefer safer testing, you can modify the Gmail node to archive, label, or log emails instead of deleting them. The full workflow takes around 5–10 minutes to configure and includes a sticky note with additional instructions and warnings.

🌐 Web Server Monitor & Alert System This automation pings web servers at regular intervals, logs their status, and sends email alerts if a server goes down. It’s perfect for maintaining visibility over server uptime — without complex monitoring tools. 🧠 How It Works This workflow performs minute-by-minute checks on all listed servers in a Google Sheet and: ✅ Logs all reachable servers in an “Alive” log. 🔻 Sends an email alert if a server is unreachable. 📄 Logs failed servers in a “Down” sheet with timestamps. 🧩 Key Components ⏰ 1. Schedule Trigger Runs the workflow every minute for real-time monitoring. 📄 2. Web Servers List (Google Sheets) Pulls server IPs or hostnames from a Google Sheet named Server_List. Each row = one server to monitor. This makes adding/removing servers effortless — just update the sheet. 🌐 3. Servers Alive Check (HTTP Request) Performs an HTTP GET request to each server (e.g., http://your-server.com). If the request fails, it automatically triggers the error path (handled via continueOnFail). ✅ 4. Web Server Alive Log (Google Sheets) Records successful pings in Server_Status_Alive with: Timestamp Server IP Status = Alive This log can be used for uptime reports or audits. 📧 5. Server Down Notification (Gmail) If a server fails, this node sends an email to the admin. It includes: Server address Timestamp Suggested action 📄 6. Web Server Down Log (Google Sheets) Logs failed pings in a separate sheet for historical tracking and debugging. ✅ Main Advantages Live Server Monitoring Stay informed about server health in near real-time. No-Code Configuration Add/remove servers from the Google Sheet — no need to touch the workflow. Email Alerts on Failure Proactively notifies you before users report the issue. Audit-Ready Logging Maintains logs for both healthy and failed checks for documentation or reporting. Flexible & Scalable Monitor 1 or 100 servers with the same template — just scale the list. ⚙️ Setup Steps 🔑 Prerequisites Google Sheet with server list (column name = “Server”) Gmail OAuth2 Connection for alerts n8n Instance running regularly 🛠 Configuration Google Sheets Sheet 1 (Server_List): Your list of servers. Sheet 2 (Server_Status_Alive): Log for reachable servers. Sheet 3 (Server_Status_Down): Log for unreachable servers. Gmail Integration Connect your Gmail account in the Server Down Notification node. Edit recipient email and message content as needed. HTTP Check Adjust the HTTP request URL template if using port numbers or paths (e.g., http://{{Server}}:8080/status). Schedule Default is every 1 minute. Change via Schedule Trigger if needed. 🧪 Testing Input a reachable server (e.g., example.com) and an unreachable IP. Run the workflow manually or wait for the next scheduled run. Check: Alive log updates correctly. Down log records failures. Email alert is received. 🚀 Deployment Activate the workflow, and it will quietly run in the background, notifying you of any server downtime instantly while keeping logs for future review.

Google Sheets to MailChimp Auto-Importer Overview This n8n workflow automatically imports contacts from Google Sheets into your MailChimp mailing list. Perfect for businesses collecting leads through Google Forms, event registrations, or maintaining contact lists in spreadsheets. Key Features 📊 Bulk Import: Process entire Google Sheets at once 🔄 Smart Name Parsing: Automatically splits full names into first and last names 📱 Phone Number Support: Includes phone numbers as merge fields ⚡ Error Resilience: Continues processing even if individual contacts fail 📝 Import Summary: Generates a summary of processed contacts Prerequisites Before using this workflow, ensure you have: An active n8n instance (self-hosted or cloud) A Google account with access to Google Sheets A MailChimp account with at least one audience/list created Basic understanding of n8n workflows Initial Setup Step 1: Import the Workflow Copy the workflow JSON In n8n, click "Import from File" or paste the JSON Save the workflow with a meaningful name Step 2: Configure Google Sheets Connection Click on the "Get Google Sheet Data" node Click on "Credential to connect with" Select "Create New" and choose "Google Sheets OAuth2" Follow the OAuth flow to authenticate your Google account Save the credentials Step 3: Configure MailChimp Connection Click on the "Add to MailChimp" node Click on "Credential to connect with" Select "Create New" and choose "MailChimp OAuth2" or "MailChimp API" For API method: Log into MailChimp Go to Account → Extras → API keys Generate a new API key Copy and paste it into n8n Save the credentials Step 4: Configure Your Specific Settings Google Sheets Settings: Open the "Get Google Sheet Data" node Replace YOUR_GOOGLE_SHEET_ID with your actual sheet ID Find this in your Google Sheets URL: https://docs.google.com/spreadsheets/d/[SHEET_ID]/edit Replace YOUR_SHEET_NAME with your worksheet name (e.g., "Sheet1" or "Form Responses 1") MailChimp Settings: Open the "Add to MailChimp" node Replace YOUR_MAILCHIMP_LIST_ID with your audience ID Find this in MailChimp: Audience → Settings → Audience name and defaults Verify the status is set to "subscribed" Google Sheets Format Requirements Your Google Sheet must have the following columns (exact names): Names**: Full name of the contact (e.g., "John Doe") Email address**: Valid email address Phone Number**: Contact phone number (optional) Example: | Names | Email address | Phone Number | |-------|--------------|--------------| | John Doe | john@example.com | +1234567890 | | Jane Smith | jane@example.com | +0987654321 | How to Use Manual Execution: Open the workflow in n8n Click "Execute Workflow" Monitor the execution progress Check the output of "Create Import Summary" for results Scheduling (Optional): To run this automatically: Replace the "Manual Trigger" node with a "Schedule Trigger" node Set your desired schedule (e.g., daily at 9 AM) Activate the workflow Customization Options Adding More Fields: To include additional fields like company name or address: Add columns to your Google Sheet Modify the "Edit Fields" node to include new fields Update the "Format Subscriber Data" code to map new fields Add corresponding merge fields in the MailChimp node Handling Duplicates: The workflow uses "continueRegularOutput" error handling, which means: Existing subscribers will be skipped New subscribers will be added The workflow continues processing Adding Email Notifications: To receive import summaries via email: Add a Gmail or Email node after "Create Import Summary" Configure with your email settings Use the import summary data in the email body Troubleshooting Common Issues: "Invalid API Key" (MailChimp) Verify your API key is correct Check that your MailChimp account is active "Sheet not found" (Google Sheets) Verify the sheet ID is correct Ensure the service account has access to the sheet "Email already exists" errors This is normal for existing subscribers The workflow will continue processing other contacts Missing data in MailChimp Check that column names match exactly (case-sensitive) Verify data exists in the Google Sheet Best Practices Test First: Always test with a small dataset first Backup Data: Export your MailChimp list before large imports Clean Data: Ensure email addresses are valid before importing Monitor Regularly: Check import summaries for any issues Respect Privacy: Only import contacts who have consented to receive emails Support For issues specific to: n8n platform: Visit n8n Community Forum Google Sheets API: Check Google Developers Documentation MailChimp API: See MailChimp API Documentation Need help customizing? Contact me for consulting and support or add me on LinkedIn - https://www.linkedin.com/in/femi-adedayo-h44/ License This workflow template is provided free for personal and commercial use. Feel free to modify and share!

This n8n template demonstrates how to create an automated customer feedback collection system for restaurants. The workflow triggers when new customer emails are added to an Excel sheet, automatically sends personalized feedback forms, and stores all responses in a separate Excel tracking sheet. Perfect for restaurants wanting to systematically gather customer insights and improve service quality. Good to know Each feedback form is personalized with the customer's name and email All responses are automatically timestamped and organized in Excel sheets The system handles form validation and ensures complete data capture Email notifications keep your team updated on new feedback submissions How it works Email Distribution Workflow New customer entries are detected in Excel Sheet-1 (customer database) containing customer names and email addresses The system automatically generates personalized feedback forms for each new customer Customized feedback emails are sent with embedded forms tailored to restaurant experience evaluation Wait nodes ensure proper processing timing before sending emails Feedback Collection Workflow Customer form submissions trigger the data collection process All feedback responses are captured including ratings, comments, and contact information Data is automatically appended to Excel Sheet-2 (feedback responses) with complete timestamps The system handles multiple concurrent submissions without data loss Excel Sheet Structure Sheet-1 (Customer Database) Name - Customer's full name Email - Customer's email address for form distribution Sheet-2 (Feedback Responses) Timestamp - Date and time of form submission Name - Customer's full name E-Mail - Customer's email address Contact Number - Customer's phone number How was the cleanliness of the dining area? - Cleanliness rating/feedback Did you like the taste of the food? - Food taste evaluation What dish did you enjoy the most? - Favorite dish identification Was your order accurate and timely? - Service accuracy rating Was our staff polite and helpful? - Staff service evaluation Was the food presentation appealing? - Food presentation rating How would you rate your overall dining experience? - Overall experience score Any additional comments or suggestions? - Open-ended feedback field How to use Import the workflow into your n8n instance and configure Excel integration Set up Sheet-1 with customer names and emails for feedback distribution Configure the feedback form with your restaurant's specific questions and branding Add new customer entries to Sheet-1 to automatically trigger feedback emails Monitor Sheet-2 for incoming responses and analyze customer satisfaction trends The system scales automatically with your customer database growth Requirements Google Sheets account for data storage and management Email service integration (Gmail, SMTP, or similar) n8n instance with Google Sheets and email connectors Customising this workflow Customer feedback automation can be adapted for different restaurant types and service models Try popular use-cases such as post-dining follow-ups, seasonal menu feedback, or special event evaluations The workflow can be extended to include automated response analysis, sentiment scoring, and management dashboard integration

📰 AI News Digest Agent: Auto News Summarizer & Email Newsletter Create an intelligent news curation system that automatically fetches breaking headlines, generates AI-powered summaries, and delivers personalized news digests to your subscriber list. Perfect for newsletter creators, team leaders, and content curators who want to keep their audience informed without the manual effort of news monitoring and summarization. 🔄 How It Works This streamlined 5-step automation delivers fresh news insights around the clock: Step 1: Automated News Collection The workflow runs on a configurable schedule (default: every 10 minutes) to fetch the latest headlines from NewsAPI, ensuring your content stays current with breaking developments. Step 2: Intelligent Content Curation The system pulls top headlines from reliable news sources, filtering by country, category, and relevance to deliver the most important stories of the day. Step 3: AI-Powered Summarization GPT-4 processes the collected headlines and creates: Concise 5-bullet point summaries Key insights and implications Easy-to-digest news overviews Professional formatting for email distribution Step 4: Subscriber Management The workflow accesses your Google Sheets subscriber list, retrieving names and email addresses for personalized delivery. Step 5: Automated Email Distribution Personalized news digests are automatically sent to each subscriber via Gmail, with custom greetings and professionally formatted content. ⚙️ Setup Steps Prerequisites NewsAPI account (free tier available) OpenAI API access for content summarization Google Sheets for subscriber management Gmail account for email distribution n8n instance (cloud or self-hosted) Required Google Sheets Structure Create a simple subscriber database: | Name | Email | |---------------|--------------------------| | John Smith | john@example.com | | Sarah Johnson | sarah@company.com | | Mike Chen | mike.chen@startup.co | Configuration Steps Credential Setup NewsAPI Key: Sign up at newsapi.org for free headline access OpenAI API Key: Required for AI-powered news summarization Google Sheets OAuth2: Access your subscriber spreadsheet Gmail OAuth2: Enable automated email sending News Source Configuration Country Selection: Choose target region (US, UK, CA, AU, etc.) Category Filters: Focus on specific topics (technology, business, health) Source Selection: Prefer certain news outlets or avoid others Language Settings: Configure for international audiences AI Summarization Customization Default prompt creates 5-bullet summaries, but can be tailored for: Industry Focus: Technology, finance, healthcare, politics Audience Type: General public, professionals, executives Content Depth: Brief overviews vs detailed analysis Tone & Style: Formal, conversational, or technical Email Template Personalization Subject Line Formatting: Include date, breaking news indicators Greeting Customization: Use subscriber names for personal touch Content Layout: Professional formatting with clear sections Branding Elements: Add your organization's signature or logo Delivery Schedule Optimization Frequency Settings: Every 10 minutes, hourly, or daily Time Zone Considerations: Optimize for subscriber locations Breaking News Alerts: Immediate delivery for urgent stories Digest Compilation: Collect multiple stories for periodic summaries 🚀 Use Cases Newsletter Publishers Content Automation: Generate newsletter content without manual curation Consistent Publishing: Maintain regular delivery schedules automatically Audience Growth: Provide value that encourages subscriptions and shares Time Savings: Eliminate hours of daily news monitoring and writing Corporate Communications Employee Updates: Keep teams informed about industry developments Executive Briefings: Deliver curated news summaries to leadership Client Communications: Share relevant industry insights with customers Stakeholder Relations: Maintain informed investor and partner networks Educational Institutions Student Resources: Provide current events for academic discussions Faculty Updates: Keep educators informed about relevant developments Research Support: Deliver news related to specific academic fields Parent Communications: Share educational policy and school-related news Professional Services Client Value Addition: Provide industry-specific news as a service benefit Thought Leadership: Position your firm as an informed industry expert Business Development: Share insights that demonstrate market knowledge Team Knowledge Sharing: Keep entire organization current on industry trends Community Organizations Member Engagement: Keep community members informed and engaged Local News Focus: Customize for regional or local news coverage Event Planning: Stay informed about developments affecting your community Advocacy Support: Monitor news relevant to your organization's mission 🔧 Advanced Customization Options Multi-Source News Aggregation Expand beyond NewsAPI with additional sources: RSS Feed Integration: Add specialized industry publications Social Media Monitoring: Include trending topics from Twitter/LinkedIn Government Sources: Official announcements and policy updates International Coverage: Global perspectives on major stories Intelligent Content Filtering Implement smart curation features: Sentiment Analysis: Filter positive, negative, or neutral news Relevance Scoring: Prioritize stories based on subscriber interests Duplicate Detection: Avoid sending repetitive story coverage Quality Assessment: Ensure content meets editorial standards Subscriber Segmentation Create targeted news experiences: Interest Categories: Technology, business, sports, entertainment Geographic Preferences: Local, national, or international focus Delivery Preferences: Frequency and format customization Engagement Tracking: Monitor opens, clicks, and subscriber behavior Enhanced Email Features Professional newsletter capabilities: HTML Templates: Rich formatting with images and links Call-to-Action Buttons: Drive engagement with your content or services Social Sharing: Enable easy sharing of newsletter content Analytics Integration: Track email performance and subscriber engagement 📊 Content Generation Examples Sample Email Output: Subject: 📰 Your Daily News Digest - March 15, 2024 Hi John, Please find today's top news headlines summarized below: 📈 BUSINESS & TECHNOLOGY Federal Reserve signals potential rate cuts following inflation data Major tech companies announce AI partnership for healthcare applications Renewable energy sector sees record investment levels in Q1 2024 Cryptocurrency markets stabilize after regulatory clarity announcement Supply chain disruptions ease as global shipping routes normalize 💡 These developments suggest growing economic optimism and continued technology sector innovation. The healthcare AI partnership particularly signals significant advances in medical technology accessibility. Stay informed and have a great day! Powered by AI News Digest Agent Unsubscribe | Update Preferences Breaking News Alert Format: Subject: 🚨 Breaking News Alert - Major Development Hi Sarah, BREAKING: [Headline] Key Details: [Critical point 1] [Critical point 2] [Impact analysis] Full coverage in your next scheduled digest. AI News Digest Agent 🛠️ Troubleshooting & Best Practices Common Issues & Solutions API Rate Limiting Monitor NewsAPI quota usage and upgrade plan if needed Implement intelligent caching to reduce redundant requests Stagger requests during high-traffic periods Set up alerts for approaching rate limits Email Delivery Challenges Monitor Gmail sending limits and implement delays if needed Use professional email authentication (SPF, DKIM) Maintain clean subscriber lists to avoid spam flags Implement unsubscribe functionality for compliance Content Quality Control Review AI summaries periodically for accuracy and bias Implement feedback loops for continuous prompt improvement Create editorial guidelines for consistent tone and style Monitor subscriber feedback and engagement metrics Optimization Strategies Performance Enhancement Use parallel processing for multiple news sources Implement intelligent caching for repeated content Optimize AI prompts for faster processing and better results Monitor workflow execution time and resource usage Subscriber Growth Create compelling value propositions for newsletter signups Implement referral systems for organic growth Share sample newsletters on social media and websites Collect feedback to continuously improve content quality Content Strategy A/B test different summary formats and lengths Analyze which news categories generate most engagement Experiment with sending times for optimal open rates Create themed newsletters for special events or topics 📈 Success Metrics Engagement Indicators Open Rates: Percentage of subscribers reading newsletters Click-Through Rates: Engagement with linked news sources Subscriber Growth: New signups and retention rates Forward/Share Rates: Viral coefficient of your content Content Quality Measurements Relevance Scores: Subscriber feedback on content usefulness Timeliness: How quickly breaking news reaches subscribers Accuracy: Verification of AI-summarized content Completeness: Coverage of important stories in your focus areas 📞 Questions & Support Need assistance with your AI News Digest Agent setup or optimization? 📧 Technical Support Email: Yaron@nofluff.online Response Time: Within 24 hours on business days Specialization: NewsAPI integration, AI content optimization, email deliverability 🎥 Educational Resources YouTube Channel: https://www.youtube.com/@YaronBeen/videos Complete setup and configuration tutorials Advanced customization techniques for different industries Email marketing best practices for automated newsletters Troubleshooting common integration issues Scaling strategies for growing subscriber lists 🤝 Professional Community LinkedIn: https://www.linkedin.com/in/yaronbeen/ Connect for ongoing newsletter automation support Share your news curation success stories Access exclusive templates and workflow variations Join discussions about content automation trends 💬 Support Request Best Practices Include in your support message: Your target audience and newsletter focus Current subscriber count and growth goals Specific news categories or geographic regions of interest Any technical errors or integration challenges Current content creation workflow and pain points