Workflow Templates

AI-Powered Customer Feedback: Triage and Insight-Driven Chat This n8n workflow creates a two-phase system for handling customer feedback received via a Jotform submission. The first agent quickly triages the issue, and the second agent engages in a persistent, conversational exchange over email to collect the information necessary for a resolution. Phase 1: Triage and Initial Action (AI Agent) This phase is triggered by a new submission on the Jotform. The goal is to immediately categorize the feedback and take the appropriate initial action. Jotform Trigger: The workflow starts instantly when a user submits your designated feedback form. AI Agent (Triage): This agent (powered by Google Gemini) is tasked with two primary jobs: Sentiment Analysis and Response Drafting: It reads the feedback (q6_typeA6) and the user's name (q3_name.first). If Positive: It uses the Send a message in Gmail tool to send a concise, appreciative thank you note. If Negative: It uses the Send a message in Gmail tool to send an initial, empathetic response acknowledging the issue and stating that a team member will follow up with questions. It also uses the Create an issue in Jira Software tool to log the bug or issue immediately. Data Structuring: It uses the Structured Output Parser to extract key data points, most importantly the threadId of the initial email, which is crucial for the follow-up conversation agent. Phase 2: Conversational Insight Gathering (AI Agent (Chat)) This phase takes over for all negative feedback, engaging the customer in a back-and-forth exchange to collect essential details required for the development or support team. Gmail Trigger: This node is set to poll for new, unread emails (which are expected to be replies from the customer). Simple Memory: This node is vital for the conversational aspect. It is configured to use the unique email threadId as its session key, allowing the AI Agent to remember the entire history of the conversation (previous questions asked and details provided) across multiple emails. AI Agent (Chat): This is the 2nd agent and the core of the conversational process. Role: It acts as a dedicated feedback assistant. Goal: Its instruction is to reply and ask for specific, missing information needed for the ticket, such as: what device they were using, if they know the steps to reproduce the issue, and to confirm that the team will send a free coupon for credits as a thank you for their help. Tool: It uses the Reply to a message in Gmail tool to continue the conversation directly within the original email thread. Resolution: The agent is trained to look for confirmation that all necessary information has been provided. Once it determines the issue details are complete, it will send a final thank you email and automatically use the Jira tool to summarize and update the existing Jira issue with the new insights, closing the loop on the data collection process. Requirements To implement and run this automated customer feedback workflow, the following accounts and credentials are required: 1. Automation Platform n8n Instance:** A running instance of n8n (Cloud or self-hosted) to host and execute the workflow. Sign up for n8n using: https://n8n.partnerlinks.io/pe6gzwqi3rqw 2. Service Credentials You must set up and connect the following credentials within your n8n instance: Google Gemini API Key:* Required to power both *AI Agent** nodes for sentiment analysis and conversational follow-up. Gmail OAuth2/API Key:** Required for: The Send a message in Gmail tool (for initial replies). The Gmail Trigger (to detect new replies). The Reply to a message in Gmail tool (for the ongoing conversation). Jotform API Key:* Required for the *Jotform Trigger** node to instantly receive and process new form submissions. Sign up for Jotform using: https://www.jotform.com/?partner=zainurrehman Jira Software Credentials:* Required for the *Create an issue in Jira Software* tool (for the first agent) and the *Jira Tool** (for the second agent to update the ticket). 3. External Configurations Jotform Setup:** A live Jotform must be configured with specific fields to capture the user's name, email, and the feedback text. Jira Setup:* You need a designated *Jira Project* and a defined *Issue Type** for the workflow to create and update tickets.

This workflow automates multi-platform content creation by transforming form submissions into tailored blog posts, LinkedIn posts, and Facebook posts using AI and web research What Makes This Different: Multi-Platform Content Generation** - Creates optimized content for blog, LinkedIn, and Facebook simultaneously AI-Powered Content Adaptation** - Uses OpenAI to tailor content for each platform's unique audience and format Web Research Integration** - Leverages Tavily API to gather relevant, up-to-date information on any topic Form-Based Input** - Simple form interface for content subject and target audience specification Automated Workflow** - End-to-end automation from form submission to content delivery Slack Integration** - Delivers all generated content via Slack notification for easy review and sharing Key Benefits of Automated Content Creation: Time Efficiency** - Generates three different content pieces in one workflow execution Platform Optimization** - Each content piece is specifically crafted for its intended platform Research-Backed Content** - Incorporates current web information for accurate, relevant content Consistent Brand Voice** - AI ensures consistent tone and messaging across all platforms Scalable Content Production** - Handles multiple content requests without manual intervention Centralized Delivery** - All content delivered to one location for easy management Who's it for This template is designed for content marketers, social media managers, small business owners, marketing agencies, and content creators who need to produce consistent, high-quality content across multiple platforms. It's perfect for businesses that want to streamline their content creation process, maintain a consistent brand voice, and leverage AI to create platform-specific content that resonates with their target audience. How it works / What it does This workflow creates an automated content creation system that transforms form submissions into multi-platform content. The system: Receives form submissions with content subject and target audience through n8n form trigger Extracts search parameters from form data to prepare for web research Searches the web using Tavily API to gather relevant, current information on the topic Processes search results by splitting and aggregating content for AI processing Generates platform-specific content using OpenAI agents for LinkedIn, Facebook, and blog formats Aggregates all content into a single output with all three platform versions Sends Slack notification with all generated content for review and distribution Key Innovation: Multi-Platform AI Content Generation - Unlike traditional content tools that create one piece of content, this system automatically generates three different versions optimized for each platform's unique audience, format requirements, and engagement patterns, all based on current web research and AI-powered adaptation. How to set up 1. Configure Form Trigger Set up n8n form trigger with "Content Subject" and "Target Audience" fields Configure form settings and validation rules Test form submission functionality Ensure proper data flow to subsequent nodes 2. Configure OpenAI API Set up OpenAI API credentials in n8n Ensure proper API access and quota limits Configure the OpenAI Chat Model node for content generation Test AI model connectivity and response quality 3. Configure Tavily API Get your API key**: Sign up at tavily.com and obtain your API key from the dashboard Add API key to workflow**: In the "Search Web" HTTP Request node, replace "ADD YOU API KEY HERE" with your actual Tavily API key Example configuration**: { "api_key": "your-actual-api-key-here", "query": "{{ $json.query.replace(/\"/g, '\\\"') }}", "search_depth": "basic", "include_answer": true, "topic": "news", "include_raw_content": true, "max_results": 3 } Configure search parameters**: Ensure max_results is set to 3 and search_depth to "basic" for optimal performance Test API connectivity**: Run a test execution to verify search results are returned correctly 4. Configure Slack Integration Set up Slack API credentials in n8n Configure Slack channel ID for content delivery Set up proper message formatting for content display Test Slack notification delivery 5. Test the Complete Workflow Submit test form with sample content subject and target audience Verify web search returns relevant results Check that AI generates appropriate content for all three platforms Confirm Slack notification contains all generated content Requirements n8n instance** with form trigger and HTTP request capabilities OpenAI API** access for AI-powered content generation Tavily API** credentials for web search functionality Slack workspace** with API access for content delivery Active internet connection** for real-time API interactions How to customize the workflow Modify Content Generation Parameters Adjust the number of web search results (currently set to 3) Add more search depth options (basic, advanced, comprehensive) Implement content length controls for different platforms Add content tone and style preferences Enhance AI Capabilities Customize AI prompts for specific industries or niches Add support for multiple languages Implement brand voice consistency across all platforms Add content quality scoring and optimization Expand Content Sources Integrate with additional research APIs (Google Search, Bing, etc.) Add support for internal knowledge base integration Implement trending topic detection Add competitor content analysis Improve Content Delivery Add email notifications alongside Slack Implement content scheduling capabilities Add content approval workflows Implement content performance tracking Business Features Add content analytics and performance metrics Implement A/B testing for different content versions Add content calendar integration Implement team collaboration features Key Features Multi-platform content generation** - Creates optimized content for blog, LinkedIn, and Facebook AI-powered content adaptation** - Tailors content for each platform's unique requirements Web research integration** - Incorporates current, relevant information from web searches Form-based input** - Simple interface for content subject and target audience specification Automated workflow** - End-to-end automation from form submission to content delivery Platform-specific optimization** - Each content piece follows platform best practices Slack integration** - Centralized delivery of all generated content Scalable content production** - Handles multiple content requests efficiently Technical Architecture Highlights AI-Powered Content Generation OpenAI integration** - Advanced language model for content creation Platform-specific prompts** - Tailored AI instructions for each social platform Content optimization** - AI ensures platform-appropriate formatting and tone Quality consistency** - Maintains brand voice across all generated content Web Research Integration Tavily API** - Comprehensive web search with content extraction Real-time data** - Access to current, relevant information Content aggregation** - Combines multiple sources for comprehensive coverage Search optimization** - Efficient query construction for better results Form-Based Input System n8n form trigger** - Simple, user-friendly input interface Data validation** - Ensures required fields are properly filled Parameter extraction** - Converts form data to search and generation parameters Error handling** - Graceful handling of incomplete or invalid inputs Multi-Platform Output LinkedIn optimization** - Professional tone with industry-specific formatting Facebook adaptation** - Engaging, shareable content with appropriate length Blog formatting** - Comprehensive, SEO-friendly long-form content Unified delivery** - All content delivered through single Slack notification Use Cases Content marketing agencies** needing efficient multi-platform content creation Small businesses** requiring consistent social media presence across platforms Marketing teams** looking to streamline content production workflows Solo entrepreneurs** needing professional content without hiring writers E-commerce brands** requiring product-focused content for multiple channels Professional services** needing thought leadership content across platforms Event organizers** requiring promotional content for different social channels Educational institutions** needing content for student engagement and recruitment Business Value Time Efficiency** - Reduces content creation time from hours to minutes Cost Savings** - Eliminates need for multiple content creators or agencies Consistency** - Maintains brand voice and messaging across all platforms Scalability** - Handles unlimited content requests without additional resources Quality Assurance** - AI ensures professional-quality content every time Multi-Platform Reach** - Maximizes content distribution across key social channels Research Integration** - Incorporates current information for relevant, timely content This template revolutionizes content creation by combining AI-powered writing with real-time web research, creating an automated system that produces high-quality, platform-optimized content for blog, LinkedIn, and Facebook from a simple form submission.

Deploy a Multi-Tool AI Assistant on WhatsApp with Google Gemini Deploy a true AI assistant on WhatsApp. This n8n workflow uses a sophisticated hierarchical agent structure to not only handle conversations but also manage your emails and calendar directly from your chat, all powered by Google Gemini. Key Features Powered by Google Gemini:** Utilizes the advanced capabilities of Google's Gemini models for understanding complex commands and generating natural, human-like responses. Intelligent Task Delegation (Hierarchical Agents):* Features a central *Personal Agent** that understands the user's intent and intelligently delegates tasks to specialized sub-agents for email, calendar, or general chat. Full Email & Calendar Management:** Connects directly to your Google Workspace to send emails, create drafts, apply labels, create/update/delete calendar events, check your availability, and more. Context-Aware Conversations:** Employs memory at multiple levels, allowing the assistant to remember the context of your requests for a coherent and intuitive user experience. Seamless WhatsApp Integration:** Connects directly with the WhatsApp Business API to send and receive messages, engaging users on one of the world's most popular messaging platforms. Easy to Deploy & Customize:** Get your assistant running with minimal configuration and easily extend its capabilities by adding new tools or modifying the prompts of the existing agents. How It Works The workflow uses an advanced agent-based model to process incoming messages: The Whatsapp Trigger node listens for and receives new messages sent to your WhatsApp Business number. The message is passed to the main Manager Agent. The Personal Agent analyzes the message to understand the user's intent (e.g., "send an email," "check my schedule," or just "hello"). Based on the intent, it routes the task to the appropriate sub-agent: the Email Tool, the Calendar Tool, or the general Chatbot Model. The selected sub-agent executes the task using its own dedicated tools (e.g., the Email Tool uses Gmail nodes to send a message). The result or response from the sub-agent is passed back to the Send message (WhatsApp) node, which delivers the reply to the user. Prerequisites An active n8n instance. A Meta Business Account and a configured Meta App with the "WhatsApp Business" product added. A Google Gemini API Key. A Google Account with pre-configured OAuth2 credentials in n8n for Gmail and Google Calendar. Step-by-Step Setup Guide 1. Configure WhatsApp Credentials: In your n8n instance, add new "WhatsApp Business" credentials. You will need a Permanent Access Token and a Phone Number ID from your Meta App's "WhatsApp > API Setup" dashboard. 2. Set Up the WhatsApp Trigger: Open the Whatsapp Trigger node. In the "Webhook URL" section, copy the Test URL. Go to your Meta App's dashboard under "WhatsApp > Configuration". Click "Edit" in the Webhooks section. Paste the n8n Test URL into the Callback URL field. Create and enter a Verify token (a simple password of your choice). Enter this same token in the Whatsapp Trigger node in n8n. Subscribe to the messages webhook event. Once verified, copy the Production URL from n8n and paste it into the same Callback URL field in the Meta dashboard. 3. Configure the Google Gemini Nodes: You must add your Google Gemini API Key to the credentials for all the Google Gemini Chat Model nodes. This includes the one in the Chatbot Model, Email Tool, and Calendar Tool. 4. Configure the Google Tools (Email & Calendar): Email Tool:* Open the group of nodes labeled *Email Tool**. For every Gmail node (Send Email, Create Draft, Get Labels, etc.), select your pre-configured Google OAuth2 credential. Calendar Tool:* Open the group of nodes labeled *Calendar Tool**. For every Google Calendar node (Create Event, Get all event, etc.), select your pre-configured Google OAuth2 credential. 5. Activate and Test: Save and activate the workflow. Send a message to your configured WhatsApp Business number.

Transform any website into a custom logo in seconds with AI-powered analysis—no design skills required! 📋 What This Template Does This workflow receives a website URL via webhook, captures a screenshot and fetches the page content, then leverages OpenAI to craft an optimized prompt based on the site's visuals and text. Finally, Google Gemini generates a professional logo image, which is returned as a binary response for immediate use. Automates screenshot capture and content scraping for comprehensive site analysis Intelligently generates tailored logo prompts using multimodal AI Produces high-quality, context-aware logos with Gemini's image generation Delivers the logo directly via webhook response 🔧 Prerequisites n8n self-hosted or cloud instance with webhook support ScreenshotOne account for website screenshots OpenAI account with API access Google AI Studio account for Gemini API 🔑 Required Credentials ScreenshotOne API Setup Sign up at screenshotone.com and navigate to Dashboard → API Keys Generate a new access key with screenshot permissions In the workflow, replace "[Your ScreenshotOne Access Key]" in the "Capture Website Screenshot" node with your key (no n8n credential needed—it's an HTTP query param) OpenAI API Setup Log in to platform.openai.com → API Keys Create a new secret key with chat completions access Add to n8n as "OpenAI API" credential type and assign to "OpenAI Prompt Generator" node Google Gemini API Setup Go to aistudio.google.com/app/apikey Create a new API key (free tier available) Add to n8n as "Google PaLM API" credential type and assign to "Generate Logo Image" node ⚙️ Configuration Steps Import the workflow JSON into your n8n instance Assign the required credentials to the OpenAI and Google Gemini nodes Replace the placeholder API key in the "Capture Website Screenshot" node's query parameters Activate the workflow to enable the webhook Test by sending a POST request to the webhook URL with JSON body: {"websiteUrl": "https://example.com"} 🎯 Use Cases Marketing teams prototyping brand assets**: Quickly generate logo variations for client websites during pitches, saving hours on manual design Web developers building portfolios**: Auto-create matching logos for new sites to enhance visual consistency in demos Freelance designers iterating ideas**: Analyze competitor sites to inspire custom logos without starting from scratch Educational projects on AI design**: Teach students how multimodal AI combines text and images for creative outputs ⚠️ Troubleshooting Screenshot fails (timeout/error)**: Increase "timeout" param to 120s or check URL accessibility; verify API key and quotas at screenshotone.com Prompt generation empty**: Ensure OpenAI credential has sufficient quota; test node isolation with a simple query Logo image blank or low-quality**: Refine the prompt in "Generate Logo Prompt" for more specifics (e.g., add style keywords); check Gemini API limits Webhook not triggering**: Confirm POST method and JSON body format; view execution logs for payload details

Overview Auto-translate YouTube uploads to Japanese and post to Slack (DeepL + Slack) Who’s it for Marketing or community teams that follow English-speaking creators but share updates with Japanese audiences; language learners who want JP summaries of newly released videos; internal comms teams curating industry channels for a JP workspace. What it does This workflow detects new YouTube uploads, retrieves full metadata, translates the title and description into Japanese using DeepL, and posts a formatted message to a Slack channel. It also skips non-English titles to avoid unnecessary translation. How it works ・RSS watches a channel for new items. ・YouTube API fetches the full snippet (title/description). ・Text is combined into a single payload and sent to DeepL. ・The translated result + original metadata is merged and posted to Slack. Requirements ・YouTube OAuth (for reliable snippet retrieval) ・DeepL API key (Free or Pro) ・Slack OAuth How to set up ・Duplicate this template. ・Open the Config (Set) node and fill in YT_CHANNEL_ID, TARGET_LANG, SLACK_CHANNEL. ・Connect credentials for YouTube, DeepL, and Slack (don’t hardcode API keys in HTTP nodes). ・Click Execute workflow and verify one sample post. How to customize ・Change TARGET_LANG to any language supported by DeepL. ・Add filters (exclude Shorts, skip videos under N characters). ・Switch to Slack Blocks for richer formatting or thread replies. ・Add a fallback translator or retry logic on HTTP errors. Notes & limits DeepL Free/Pro have different endpoints/quotas and monthly character limits. YouTube and Slack also enforce rate limits. Keep credentials in n8n’s credential store; do not commit keys into templates. Rotate keys if you accidentally exposed them.

This workflow is your all-in-one AI Content Strategist, designed to generate comprehensive, data-driven content briefs by analyzing top-ranking competitors. It operates through a simple chat interface. You provide a target keyword, and the workflow automates the entire research process. First, it scrapes the top 10 Google search results using the powerful Bright Data SERP API. Then, for each of those results, it performs a deep dive, using the Bright Data Web Unblocker to reliably extract the full content from each page, bypassing any anti-bot measures. Finally, all the gathered data—titles, headings, word counts, and page summaries—is synthesized by a Large Language Model (LLM) to produce a strategic content plan. This plan identifies search intent, core topics, and crucial content gaps, giving you a clear roadmap to outrank the competition. This template is indispensable for SEO specialists, content marketers, and digital agencies looking to scale their content production with strategies that are proven to work. Why Use This AI Content Strategist Workflow ? Data-Driven Insights: Base your content strategy on what is actually ranking on **Google, not guesswork. Automated Competitive Analysis: Instantly understand the structure, length, and key themes of the **top-performing articles for any keyword. Strategic Gap Detection: The **AI analysis highlights poorly covered topics and missed opportunities, allowing you to create content that provides unique value. Massive Time Savings: Condenses hours of **manual research into a fully automated process that runs in minutes. How It Works Chat Interaction Begins: The workflow is initiated via a chat UI. The user enters a target keyword to start the analysis. Google SERP Scraping (Bright Data): The "Google SERP" node uses Bright Data's SERP API to fetch the top 10 organic results, providing the URLs for the next stage. Individual Page Scraping (Bright Data): The workflow loops through each URL. The "Access and extract data" node uses the Bright Data Web Unblocker to ensure successful and complete HTML scraping of every competitor's page. Content Extraction & Aggregation: A series of Code nodes clean the raw HTML and extract structured data (title, meta description, headings, word count). The Aggregate node then compiles the data from all 10 pages into a single dataset. AI Synthesis (OpenRouter): The "Analysis" node sends the entire compiled dataset to an LLM via OpenRouter. The AI performs a holistic analysis to identify search intent, must-cover topics, and differentiation opportunities. Strategic Brief Generation: The "Format Output" node takes the AI's structured JSON analysis and transforms it into a clean, human-readable Markdown report, which is then delivered back to the user in the chat interface. 🔑 Prerequisites To use this workflow, you will need active accounts with both Bright Data (for web scraping) and OpenRouter (for AI model access). Setting Up Your Credentials: Bright Data Account: Sign up for a free trial account on their website. Inside your Bright Data dashboard, you will need to activate both the SERP API and the Web Unblocker products to create the necessary Zones. In n8n, navigate to the Credentials section, add a new "Brightdata API" credential, and enter your API key. In the workflow, select your newly created credential in both the "Google SERP" node and the "Access and extract data from a specific URL" node. OpenRouter Account: Sign up for an account at OpenRouter.ai. Navigate to your account settings to find your API Key. In n8n, go to Credentials, add a new "OpenRouter API" credential, and paste your key. In the workflow, select this credential in all three "OpenRouter Chat Model" nodes. Phil | Inforeole 🇫🇷 Contactez nous pour automatiser vos processus

📧 Auto-Send AI Follow-Up Emails to Zoom Attendees This workflow automatically emails personalized follow-ups to every Zoom meeting participant once the meeting ends. ⚙️ How It Works Zoom Webhook → Captures meeting.ended event + participant list. Normalize Data → Extracts names, emails, and transcript (if available). AI (GPT-4) → Drafts short, professional follow-up emails. Gmail → Sends thank-you + recap email to each participant. 🛠️ Setup Steps 1. Zoom App Enable meeting.ended event. Include participant email/name in webhook payload. Paste workflow webhook URL. 2. Gmail Connect Gmail OAuth in n8n. Emails are sent automatically per participant. 3. OpenAI Add your OpenAI API key. Uses GPT-4 for personalized drafting. 📊 Example Output Email Subject: Follow-Up: Marketing Strategy Session Email Body: Hi Sarah, Thank you for joining our Marketing Strategy Session today. Key points we discussed: Campaign launch next Monday Budget allocation approved Need design assets by Thursday Next steps: I'll follow up with the creative team and share the updated timeline. Best, David ⚡ With this workflow, every attendee feels valued and aligned after each meeting.

This workflow helps HR teams run smoother monthly Q\&A sessions with employees. Who’s it for** HR teams and managers who want to centralize employee questions, avoid duplicates, and keep meetings focused. How it works** Employees submit questions through a styled form. Questions are stored in a database. HR selects a date range to review collected questions. An AI Agent deduplicates and clusters similar questions, then generates a meeting script in Markdown format. The Agent automatically creates a Google Calendar event (with a Google Meet link) on the last Friday of the current month at 16:00–17:00. The script is returned as a downloadable .txt file for HR to guide the session. Requirements** MySQL (or compatible DB) for storing questions Google Calendar credentials OpenAI (or another supported LLM provider) How to customize** Adjust meeting day/time in the Set node expressions Change database/table name in MySQL nodes Modify clustering logic in the AI Agent prompt Replace the form styling with your company’s branding This template ensures no repeated questions, keeps HR better prepared with a structured script, and automates meeting scheduling in just one click.

How it works This workflow for trip weather forecasting is event-driven, starting when a calendar event is created or updated, and provides timely weather alerts and forecasts tailored to your travel dates and locations. Overall, this workflow efficiently integrates calendar travel plans with real-time and updated weather intelligence for ultimate travel preparedness and peace of mind. From the creator If you’re jetting off frequently, bouncing between time zones, juggling meetings, and squeezing every drop of life out of travel, you need this flow. This ain’t your grandma’s weather app. It’s a bulletproof system that scans your calendar, mines your trips, and delivers laser-targeted weather intel and urgent alerts, right when you need it. No more surprises**. No more scrambling**. Just real-time weather mastery that saves your schedule. You’re not just traveling: you’re dominating. This flow makes sure the only thing you worry about is your next move, not whether the weather’s gonna ruin it. Time to upgrade from a tourist to a boss. Step-by-step 📅 Google Calendar Triggers (Event Created/Updated): The workflow starts immediately upon creation or update of any calendar event, enabling real-time detection of new or changed travel plans. ✈ Identify Trips: Filters these calendar events to detect travel-related trips by matching keywords such as "trip," "flight," or "vacation" in titles or descriptions. 📍Extract Locations: Parses each trip event’s details to extract start and end dates and the trip destination from the summary/description/location fields. 🌐 Build interrogation URL: Constructs a Visual Crossing API request URL dynamically based on the extracted trip location and dates, including daily forecasts and alerts. Fetches the detailed weather forecast and alert data for the trip location and duration right after detecting the event. Formats the raw weather data into a readable summary 🌤️🌪🌀 including temperatures, precipitation probabilities, conditions, and eventual severe weather alerts. 📲 📧 Send Forecast: Sends the forecast summary with alerts via Telegram to keep the user informed instantly. ⌛One day before the trip: Pauses the workflow until exactly one day before the trip start date, ensuring a timely second fetch when more accurate or updated weather data is available and the updated forecast is sent. Optional You can replace the Telegram node with email, WhatsApp, Slack, SMS notifications, or add multiple notification nodes to receive them across all desired channels.

E.ON W1000 → n8n → Home Assistant (Spook) “Integration” This workflow processes emails from the E.ON portal containing 15-minute +A -A (import/export) data and daily 1.8.0 2.8.0 meter readings. It extracts the required columns from the attached XLSX file, groups the 15-minute values by hour, then: updates the Spook/Recorder statistics under the IDs sensor.grid_energy_import and sensor.grid_energy_export, and sets the current meter readings for the entities input_number.grid_import_meter and input_number.grid_export_meter. > You may need to modify the workflow if there are changes in how E.ON sends scheduled exports. If the exported data format changes, please report it on Github! Requirements n8n (cloud or self-hosted) HACS addon available here: Rbillon59/home-assistant-addons Official n8n Docker Compose template Simplified n8n Docker Compose template available on Github (For Gmail) Gmail API authentication (OAuth2) read-only email access to the account receiving the messages Setup guide available here (For IMAP) IMAP provider credentials Home Assistant access via Long-Lived Access Token or API key Setup guide available here Spook integration Documentation and installation guide available here E.ON Portal Setup Create a scheduled export on the E.ON portal with the following parameters: Under the Remote Meter Reading menu, click on the + new scheduled export setting button. Specify POD identifier(s): choose one of the PODs you want to query. Specify meter variables: select the following: +A Active Power Consumption -A Active Power Feed-In DP_1-1:1.8.0*0 Active Power Consumption Daily Reading DP_1-1:2.8.0*0 Active Power Feed-In Daily Reading Export sending frequency: daily Days of historical data to include: recommended 7 days to backfill missed data. Email subject: by default, use [EON-W1000]. If processing multiple PODs with the workflow, give each a unique identifier. Home Assistant Preparation Create the following input_number entities in configuration.yaml or via Helpers: input_number: grid_import_meter: name: grid_import_meter mode: box initial: 0 min: 0 max: 9999999999 step: 0.001 unit_of_measurement: kWh grid_export_meter: name: grid_export_meter mode: box initial: 0 min: 0 max: 9999999999 step: 0.001 unit_of_measurement: kWh > If you name the entities differently, make sure to reflect these changes in the workflow. Create the following template_sensor entities in configuration.yaml or via Helpers: input_number: grid_import_meter: name: grid_import_meter mode: box initial: 0 min: 0 max: 9999999999 step: 0.001 unit_of_measurement: kWh grid_export_meter: name: grid_export_meter mode: box initial: 0 min: 0 max: 9999999999 step: 0.001 unit_of_measurement: kWh >If you name the entities differently, make sure to reflect these changes in the workflow. create the following template_sensor entities in config.yaml or via Helpers: template: sensor: name: "grid_energy_import" state: "{{ states('input_number.grid_import_meter') | float(0) }}" unit_of_measurement: "kWh" device_class: energy state_class: total_increasing name: "grid_energy_export" state: "{{ states('input_number.grid_export_meter') | float(0) }}" unit_of_measurement: "kWh" device_class: energy state_class: total_increasing > If you name the entities differently, make sure to reflect these changes in the workflow. n8n import and authentication importing the workflow In n8n → Workflows → Import from File/Clipboard → paste the JSON. Select the downloaded JSON and paste it into a new workflow using Ctrl+V. Set up n8n Credentials The credentials must be configured in the Home Assistant and Gmail nodes. The setup process is described in the Requirements section.

Portrait Photo Upscaler Workflow Overview Automated workflow that retrieves portrait photos from Airtable, upscales them using AI, and stores the enhanced images in Google Drive with organized folder structure. Features Automated Folder Creation**: Creates timestamped folders in Google Drive AI-Powered Upscaling**: Uses Replicate's Real-ESRGAN for 2x image enhancement Batch Processing**: Handles multiple images efficiently with loop processing Error Handling**: Continues processing even if individual images fail Airtable Integration**: Retrieves images from specified database records Prerequisites Required Credentials Google Drive OAuth2 API**: For folder creation and file uploads Airtable Token API**: For accessing image records Replicate HTTP Header Auth**: For AI upscaling service Airtable Setup Column name: PortraitFotoAuswahl Column type: Attachment field containing image files Required: Valid Airtable Base ID and Table ID Workflow Steps Manual Trigger: Initiates the workflow execution Create Folder: Generates new Google Drive folder with custom name Get Airtable Record: Retrieves specified record containing portrait images Extract URLs: Processes attachment URLs from Airtable field Loop Processing: Iterates through each image for individual processing AI Upscaling: Enhances images using Replicate's Real-ESRGAN (2x scale) Download Results: Retrieves processed images from Replicate Upload to Drive: Stores enhanced images in created folder Configuration Required Inputs Folder Name**: Custom name for Google Drive folder Record ID**: Airtable record identifier containing images Base ID**: (configurable) Table ID**: (configurable) Upscaling Settings Scale Factor**: 2x (configurable) Face Enhancement**: Disabled (configurable) Model**: Real-ESRGAN v1.3 Technical Details Node Configuration Error Handling**: Continue on individual failures Response Format**: File binary for image processing Naming Convention**: LoRa{timestamp}.png Batch Processing**: Automatic item splitting API Endpoints Replicate**: https://api.replicate.com/v1/predictions Model Version**: nightmareai/real-esrgan:f121d640bd286e1fdc67f9799164c1d5be36ff74576ee11c803ae5b665dd46aa Use Cases Portrait photography enhancement Batch image processing for portfolios Automated content preparation workflows Quality improvement for archived images Output Enhanced images stored in Google Drive Organized folder structure with timestamps Preserved original filenames with processed variants Failed processes continue without stopping workflow Template Benefits Scalable**: Processes unlimited images in single execution Reliable**: Built-in error handling and continuation logic Organized**: Automatic folder management and file naming Professional**: High-quality AI upscaling for commercial use

This n8n template turns a small, targeted HubSpot list into tailored outreach. It scans each contact’s recent Gmail conversations, builds a lightweight persona with AI (tone, goals, pain points, decision style), then drafts a concise sales email aligned to your offer—saved to Gmail as a reviewable draft. Perfect for SDRs and founders who want personalization at scale without writing from scratch. This template was originally created by Jim Le. How it works Manual trigger** starts a controlled run. HubSpot search** pulls a focused list of contacts (e.g., hs_buying_role = DECISION_MAKER). Batch loop** processes contacts one by one. Gmail fetch** grabs up to 20 recent threads from each contact. AI persona extraction** (Information Extractor + Gemini) analyzes messages to capture: decision-making style, communication preferences, goals/motivations pain points, work style, personality traits, buying behavior, values, market awareness Variables node* sets core fields (first name, last name, email) and the *offer** you want to pitch. AI email generation* (Gemini) mirrors the contact’s tone and priorities; outputs *subject* + *HTML body**. Gmail draft** is created for the contact so a rep can skim, tweak, and send. How to use Connect HubSpot on the “Get Contacts” node and refine the filter to your segment. Connect Gmail on both read and draft nodes (same account recommended). Add Gemini key to both Gemini nodes. In Variables, update product_to_sell with your offer and confirm the contact field mappings. (Optional) Tweak the persona attributes or the email prompt for tone/length/CTA. Click Test workflow. Review drafts in Gmail, edit if needed, then send. Requirements HubSpot** (OAuth2) for contact targeting Gmail** (read + draft) Google Gemini** (API key) for persona + copy generation Notes & customization Tighter targeting:** Change the HubSpot filter (e.g., industry, territory, lifecycle stage) to keep the list small and measurable. Richer inputs:** Increase Gmail limit or include received/sent filters to capture more context (mind rate limits). Brand voice:** Add a short style guide to the email generator’s system prompt (e.g., sentence length, jargon rules, sign-off). Offer variants:** Replace product_to_sell per segment, or branch by industry to load different value props. Compliance & privacy:** Limit stored outputs to essentials; avoid copying sensitive content from threads verbatim. Auto-send option:** Swap the draft step for “send email” if you want hands-off delivery for known segments.