Workflow Templates

Automate Google Classroom: Topics, Assignments & Student Tracking Automate Google Classroom via the Google Classroom API to efficiently manage courses, topics, teachers, students, announcements, and coursework. Use Cases Educational Institution Management Sync rosters, post weekly announcements, and generate submission reports automatically. Remote Learning Coordination Batch-create assignments, track engagement, and auto-notify teachers on new submissions. Training Program Automation Automate training modules, manage enrollments, and generate completion/compliance reports. Prerequisites n8n (cloud or self-hosted) Google Cloud Console access for OAuth setup Google Classroom API enabled Google Gemini API key** (free) for the agent brain — or swap in any other LLM if preferred Setup Instructions Step 1: Google Cloud Project Create a new project in Google Cloud Console. Enable Google Classroom API. Create OAuth 2.0 Client ID credentials. Add your n8n OAuth callback URL as a redirect URI. Note down the Client ID and Client Secret. Step 2: OAuth Setup in n8n In n8n, open HTTP Request Node → Authentication → Predefined Credential Type. Select Google OAuth2 API. Enter your Client ID and Client Secret. Click Connect my account to complete authorization. Test the connection. Step 3: Import & Configure Workflow Import this workflow template into n8n. Link all Google Classroom nodes to your OAuth credential. Configure the webhook if using external triggers. Test each agent for API connectivity. Step 4: Customization You can customize each agent’s prompt to your liking for optimal results, or copy and modify node code to expand functionality. All operations use HTTP Request nodes, so you can integrate more tools via the Google Classroom API documentation. This workflow provides a strong starting point for deeper automation and integration. Features Course Topics List, create, update, or delete topics within a course. Teacher & Student Management List, retrieve, and manage teachers and students programmatically. Course Posts List posts, retrieve details and attachments, and access submission data. Announcements List, create, update, or delete announcements across courses. Courses List all courses, get detailed information, and view grading periods. Coursework List, retrieve, or analyze coursework within any course. Notes Once OAuth and the LLM connection are configured, this workflow automates all Google Classroom operations. Its modular structure lets you activate only what you need—saving API quota and improving performance.

🤖🎵 This workflow automates the creation, storage, and cataloging of AI-generated music using the Eleven Music API, Google Sheets, and Google Drive. Key Advantages ✅ Fully Automated Music Generation Pipeline Once started, the workflow automatically: Reads track parameters Generates music via API Uploads the file Updates your spreadsheet No manual steps needed after initialization. ✅ Centralized Track Management A single Google Sheet acts as your project control center, letting you organize: Prompts Durations Generated URLs This avoids losing track of files and creates a ready-to-share catalog. ✅ Seamless Integration with Google Services The workflow: Reads instructions from Google Sheets Saves the MP3 to Google Drive Updates the same Sheet with the final link This ensures everything stays synchronized and easy to access. ✅ Scalable and Reliable Processing The loop-with-delay mechanism: Processes tracks sequentially Prevents API overload Ensures stable execution This is especially helpful when generating multiple long tracks. ✅ Easy Customization Because the prompts and durations come from Google Sheets: You can edit prompts at any time You can add more tracks without modifying the workflow You can clone the Sheet for different projects ✅ Ideal for Creators and Businesses This workflow is perfect for: Content creators generating background music Agencies designing custom soundtracks Businesses needing AI-generated audio assets Automated production pipelines How It Works The process operates as follows: The workflow starts manually via the "Execute workflow" trigger It retrieves a list of music track requests from a Google Sheets spreadsheet containing track titles, text prompts, and duration specifications The system processes each track request individually through a batch loop For each track, it sends the text prompt and duration to ElevenLabs Music API to generate studio-quality music The generated MP3 file (in 44100 Hz, 128 kbps format) is automatically uploaded to a designated Google Drive folder Once uploaded, the workflow updates the original Google Sheets with the direct URL to the generated music file A 1-minute wait period between each track generation prevents API rate limiting The process continues until all track requests in the spreadsheet have been processed Set Up Steps Prerequisites: ElevenLabs paid account with Music API access enabled Google Sheets spreadsheet with specific columns: TITLE, PROMPT, DURATION (ms), URL Google Drive folder for storing generated music files Configuration Steps: ElevenLabs API Setup: Enable Music Generation access in your ElevenLabs account Generate an API key from the ElevenLabs developer dashboard Configure HTTP Header authentication in n8n with name "xi-api-key" and your API value Google Sheets Preparation: Create or clone the music tracking spreadsheet with required columns Fill in track titles, detailed text prompts, and durations in milliseconds (10,000-300,000 ms) Configure Google Sheets OAuth credentials in n8n Update the document ID in the Google Sheets nodes Google Drive Configuration: Create a dedicated folder for music uploads Set up Google Drive OAuth credentials in n8n Update the folder ID in the upload node Workflow Activation: Ensure all API credentials are properly configured Test with a single track entry in the spreadsheet Verify music generation, upload, and spreadsheet update work correctly Execute the workflow to process all pending track requests The workflow automatically names files with timestamp prefixes (song_yyyyMMdd) and handles the complete lifecycle from prompt to downloadable music file. Need help customizing? Contact me for consulting and support or add me on Linkedin.

This n8n workflow template creates an efficient data analysis system that uses Google Gemini AI to interpret user questions about spreadsheet data and processes them through a specialized sub-workflow for optimized token usage and faster responses. What This Workflow Does Smart Query Parsing**: Uses Gemini AI to understand natural language questions about your data Efficient Processing**: Routes calculations through a dedicated sub-workflow to minimize token consumption Structured Output**: Automatically identifies the column, aggregation type, and grouping levels from user queries Multiple Aggregation Types**: Supports sum, average, count, count distinct, min, and max operations Flexible Grouping**: Can aggregate data by single or multiple dimensions Token Optimization**: Processes large datasets without overwhelming AI context limits Tools Used Google Gemini Chat Model** - Natural language query understanding and response formatting Google Sheets Tool** - Data access and column metadata extraction Execute Workflow** - Sub-workflow processing for data calculations Structured Output Parser** - Converts AI responses to actionable parameters Memory Buffer Window** - Basic conversation context management Switch Node** - Routes to appropriate aggregation method Summarize Nodes** - Performs various data aggregations 📋 MAIN WORKFLOW - Query Parser What This Workflow Does The main workflow receives natural language questions from users and converts them into structured parameters that the sub-workflow can process. It uses Google Gemini AI to understand the intent and extract the necessary information. Prerequisites for Main Workflow Google Cloud Platform account with Gemini API access Google account with access to Google Sheets n8n instance (cloud or self-hosted) Main Workflow Setup Instructions 1. Import the Main Workflow Copy the main workflow JSON provided In your n8n instance, go to Workflows → Import from JSON Paste the JSON and click Import Save with name: "Gemini Data Query Parser" 2. Set Up Google Gemini Connection Go to Google AI Studio Sign in with your Google account Go to Get API Key section Create a new API key or use an existing one Copy the API key Configure in n8n: Click on Google Gemini Chat Model node Click Create New Credential Select Google PaLM API Paste your API key Save the credential 3. Set Up Google Sheets Connection for Main Workflow Go to Google Cloud Console Create a new project or select existing one Enable the Google Sheets API Create OAuth 2.0 Client ID credentials In n8n, click on Get Column Info node Create Google Sheets OAuth2 API credential Complete OAuth flow 4. Configure Your Data Source Option A: Use Sample Data The workflow is pre-configured for: Sample Marketing Data Make a copy to your Google Drive Option B: Use Your Own Sheet Update Get Column Info node with your Sheet ID Ensure you have a "Columns" sheet for metadata Update sheet references as needed 5. Set Up Workflow Trigger Configure how you want to trigger this workflow (webhook, manual, etc.) The workflow will output structured JSON for the sub-workflow ⚙️ SUB-WORKFLOW - Data Processor What This Workflow Does The sub-workflow receives structured parameters from the main workflow and performs the actual data calculations. It handles fetching data, routing to appropriate aggregation methods, and formatting results. Sub-Workflow Setup Instructions 1. Import the Sub-Workflow Create a new workflow in n8n Copy the sub-workflow JSON (embedded in the Execute Workflow node) Import as a separate workflow Save with name: "Data Processing Sub-Workflow" 2. Configure Google Sheets Connection for Sub-Workflow Apply the same Google Sheets OAuth2 credential you created for the main workflow Update the Get Data node with your Sheet ID Ensure it points to your data sheet (e.g., "Data" sheet) 3. Configure Google Gemini for Output Formatting Apply the same Gemini API credential to the Google Gemini Chat Model1 node This handles final result formatting 4. Link Workflows Together In the main workflow, find the Execute Workflow - Summarize Data node Update the workflow reference to point to your sub-workflow Ensure the sub-workflow is set to accept execution from other workflows Sub-Workflow Components When Executed by Another Workflow**: Trigger that receives parameters Get Data**: Fetches all data from Google Sheets Type of Aggregation**: Switch node that routes based on aggregation type Multiple Summarize Nodes**: Handle different aggregation types (sum, avg, count, etc.) Bring All Data Together**: Combines results from different aggregation paths Write into Table Output**: Formats final results using Gemini AI Example Usage Once both workflows are set up, you can ask questions like: Overall Metrics: "Show total Spend ($)" "Show total Clicks" "Show average Conversions" Single Dimension: "Show total Spend ($) by Channel" "Show total Clicks by Campaign" Two Dimensions: "Show total Spend ($) by Channel and Campaign" "Show average Clicks by Channel and Campaign" Data Flow Between Workflows Main Workflow: User question → Gemini AI → Structured JSON output Sub-Workflow: Receives JSON → Fetches data → Performs calculations → Returns formatted table Contact Information For support, customization, or questions about this template: Email**: robert@ynteractive.com LinkedIn**: Robert Breen Need help implementing these workflows, want to remove limitations, or require custom modifications? Reach out for professional n8n automation services and AI integration support.

This n8n workflow template creates an intelligent data analysis system that converts natural language questions into Google Sheets SQL queries using OpenAI's GPT-4o model. The system generates proper Google Sheets query URLs and executes them via HTTP requests for efficient data retrieval. What This Workflow Does Natural Language to SQL**: Converts user questions into Google Sheets SQL syntax Direct HTTP Queries**: Bypasses API limits by using Google Sheets' built-in query functionality Column Letter Mapping**: Automatically maps column names to their corresponding letters (A, B, C, etc.) Structured Query Generation**: Outputs properly formatted Google Sheets query URLs Real-time Data Access**: Retrieves live data directly from Google Sheets Memory Management**: Maintains conversation context for follow-up questions Tools Used OpenAI Chat Model (GPT-4o)** - SQL query generation and natural language understanding OpenAI Chat Model (GPT-4.1 Mini)** - Result formatting and table output Google Sheets Tool** - Column metadata extraction and schema understanding HTTP Request Node** - Direct data retrieval via Google Sheets query API Structured Output Parser** - Formats AI responses into executable queries Memory Buffer Window** - Conversation history management Chat Trigger** - Webhook-based conversation interface Step-by-Step Setup Instructions 1. Prerequisites Before starting, ensure you have: An n8n instance (cloud or self-hosted) An OpenAI account with API access and billing setup A Google account with access to Google Sheets The target Google Sheet must be publicly accessible or shareable via link 2. Import the Workflow Copy the workflow JSON provided In your n8n instance, go to Workflows → Import from JSON Paste the JSON and click Import Save with a descriptive name like "Google Sheets SQL Query Generator" 3. Set Up OpenAI Connections Get API Key: Go to OpenAI Platform Sign in or create an account Navigate to API Keys section Click Create new secret key Copy the generated API key Important: Add billing information and credits to your OpenAI account Configure Both OpenAI Nodes: OpenAI Chat Model1 (GPT-4o): Click on the node Click Create New Credential Select OpenAI API Paste your API key Save the credential OpenAI Chat Model2 (GPT-4.1 Mini): Apply the same OpenAI API credential This handles result formatting 4. Set Up Google Sheets Connection Create OAuth2 Credentials: Go to Google Cloud Console Create a new project or select existing one Enable the Google Sheets API Go to Credentials → Create Credentials → OAuth 2.0 Client IDs Set application type to Web Application Add authorized redirect URIs (get this from n8n credentials setup) Copy the Client ID and Client Secret Configure in n8n: Click on the Get Column Info2 node Click Create New Credential Select Google Sheets OAuth2 API Enter your Client ID and Client Secret Complete the OAuth flow by clicking Connect my account Authorize the required permissions 5. Prepare Your Google Sheet Option A: Use the Sample Data Sheet Access the pre-configured sheet: Sample Marketing Data Make a copy to your Google Drive Important**: Set sharing to "Anyone with the link can view" Critical: Set sharing to "Anyone with the link can view" for HTTP access Copy the Sheet ID from the URL Update the Get Column Info2 node with your Sheet ID and column metadata sheet 6. Configure Sheet References Get Column Info2 Node: Set Document ID to your Google Sheet ID Set Sheet Name to your columns metadata sheet (e.g., "Columns") This provides the AI with column letter mappings HTTP Request Node: No configuration needed - it uses dynamic URLs from the AI agent Ensure your sheet has proper sharing permissions 7. Update System Prompt (If Using Custom Sheet) If using your own Google Sheet, update the system prompt in the AI Agent3 node: Replace the URL in the system message with your Google Sheet URL Update the GID (sheet ID) to match your data sheet Keep the same query structure format Contact Information Robert Ynteractive For support, customization, or questions about this template: Email**: robert@ynteractive.com LinkedIn**: Robert Breen Need help implementing this workflow, want to add security features, or require custom modifications? Reach out for professional n8n automation services and AI integration support.

Feedback Sentiment Workflow (Typeform → GCP → Notion/Slack/Trello) This template ingests feedback from Typeform, runs Google Cloud Natural Language sentiment analysis, routes based on sentiment, and then creates a Notion database page and posts a Slack notification for positive items, or creates a Trello card for negative items. The flow is designed for quick setup and safe sharing using placeholders for IDs and credentials. How it Works Typeform Trigger Captures each new submission and exposes answers like Name and the long-text Feedback field. Google Cloud Natural Language Analyzes the feedback text and returns a sentiment score in: documentSentiment.score Check Sentiment Score (IF) True branch: Score > 0 → Positive False branch: Score ≤ 0 → Non-positive Add Feedback to Notion (True branch) Creates a new page in a Notion database with mapped properties. Notify Slack (after Notion) Posts the feedback, author, and score to a Slack channel for visibility. Create Trello Card (False branch) Logs non-positive items to a Trello list for follow-up. Required Accounts Google Cloud Natural Language API** enabled (OAuth2 or service credentials). Notion integration** with database access to create pages. Slack app/bot token** with permission to post to the target channel. Typeform account** with a form including: Long Text feedback question Name field Notion Database Columns Name (title):** Person name or responder label Feedback (rich_text):** Full feedback text Sentiment Score (number):** Numeric score from GCP ∈ [-1, 1] Source (select/text):** "Typeform" for provenance Submitted At (date):** Timestamp from the trigger Customization Options Sentiment Threshold:** Adjust IF condition (e.g., ≥ 0.25) for stricter positivity. Slack Routing:** Change channel, add blocks/attachments for richer summaries. Trello Path:** Point to a triage list and include labels for priority. Field Mapping:** Update the expression for feedback question to match Typeform label. Database Schema:** Add tags, product area, or customer tier for reporting. Setup Steps Connect credentials: Typeform, GCP Natural Language, Notion, Slack, Trello. Replace placeholders in workflow JSON: Form ID Database ID Slack Channel Trello List ID Map fields: Set Feedback + Name expressions from Typeform Trigger output into Notion and Slack. Adjust IF threshold for your definition of "positive". Test with a sample response and confirm: Notion page creation Slack notification Trello card logging

This workflow returns the current weather at a predefined or given city and returns it so that it can be displayed with bash-dash. By default does it return the weather in Berlin if no city got defined. That default can be changed in the "Set City" node. Example usage: \- weather london Example bash-dash config: commands[weather]="http://localhost:5678/webhook/weather"

Verified User Profile Creation - Automated Email Validation & PDF Generation Overview This comprehensive automation workflow streamlines the user onboarding process by validating email addresses, generating professional profile PDFs, and delivering them seamlessly to verified users. 🎯 What This Workflow Does: Receives User Data - Webhook trigger accepts user signup information (name, email, city, profession, bio) Validates Email Addresses - Uses VerifiEmail API to ensure only legitimate email addresses proceed Conditional Branching - Smart logic splits workflow based on email verification results Generates HTML Profile - Creates beautifully styled HTML templates with user information Converts to PDF - Transforms HTML into professional, downloadable PDF documents Email Delivery - Sends personalized welcome emails with PDF attachments to verified users Data Logging - Records all verified users in Google Sheets for analytics and tracking Rejection Handling - Notifies users with invalid emails and provides guidance ✨ Key Features: ✅ Email Verification - Prevents fake registrations and maintains data quality 📄 Professional PDF Generation - Beautiful, branded profile documents 📧 Automated Email Delivery - Personalized welcome messages with attachments 📊 Google Sheets Logging - Complete audit trail of all verified users 🔀 Smart Branching - Separate paths for valid and invalid emails 🎨 Modern Design - Clean, responsive HTML/CSS templates 🔒 Secure Webhook - POST endpoint for seamless form integration 🎯 Perfect Use Cases: User registration systems Community membership verification Professional certification programs Event registration with verified attendees Customer onboarding processes Newsletter signup verification Educational platform enrollments Membership card generation 📦 What's Included: Complete workflow with 12 informative sticky notes Pre-configured webhook endpoint Email verification integration PDF generation setup Gmail sending configuration Google Sheets logging Error handling guidelines Rejection email template 🛠️ Required Integrations: VerifiEmail - For email validation (https://verifi.email) HTMLcsstoPDF - For PDF generation (https://htmlcsstopdf.com) Gmail OAuth2 - For email delivery Google Sheets OAuth2 - For data logging ⚡ Quick Setup Time: 15-20 minutes 🎓 Skill Level: Beginner to Intermediate Benefits: ✅ Reduces manual verification work by 100% ✅ Prevents spam and fake registrations ✅ Delivers professional branded documents automatically ✅ Maintains complete audit trail ✅ Scales effortlessly with user growth ✅ Provides excellent user experience ✅ Easy integration with any form or application Technical Details: Trigger Type:** Webhook (POST) Total Nodes:** 11 (including 12 documentation sticky notes) Execution Time:** ~3-5 seconds per user API Calls:** 3 external (VerifiEmail, HTMLcsstoPDF, Google Sheets) Email Format:** HTML with binary PDF attachment Data Storage:** Google Sheets (optional) License: MIT (Free to use and modify) 🎁 BONUS FEATURES: Comprehensive sticky notes explaining each step Beautiful, mobile-responsive email template Professional PDF styling with modern design Easily customizable for your branding Ready-to-use webhook endpoint Error handling guidelines included Perfect for: Developers, No-code enthusiasts, Business owners, SaaS platforms, Community managers, Event organizers Start automating your user verification process today! 🚀

This workflow allows you to send a message in a Telegram chat via bash-dash. Example usage: - telegram I'll be late If you want to send a predefined message without typing it in the command line, you can replace the Text Expression in the Telegram node with a specific message. In this case, the dash command - telegram will send the predefined message to the chat. Example bash-dash config: commands[telegram]="http://localhost:5678/webhook/telegram"

Overview This n8n workflow automates the creation and publishing of Instagram carousel posts by downloading images from Google Drive, uploading them to Cloudinary for hosting, and publishing them as a coordinated carousel post via Facebook Graph API. This workflow is perfect for social media managers and content creators who need to publish coordinated multi-image posts from cloud-stored assets with minimal manual intervention. Key Features Multi-Image Processing: Handles multiple images for carousel posts automatically Cloud Image Hosting: Uses Cloudinary for reliable image hosting and delivery Instagram API Integration: Creates and publishes carousel posts via Facebook Graph API Google Drive Integration: Downloads images directly from Google Drive links Telegram Notifications: Sends success notifications after post publication Error Handling: Continues workflow execution even if individual images fail Technical Workflow Data Preparation: Structures input data with image links and post content Batch Processing: Loops through multiple image URLs from Google Drive Image Download: Downloads each image from Google Drive Cloud Upload: Uploads images to Cloudinary for public hosting Media Creation: Creates Instagram media objects for each image ID Collection: Collects all media IDs for carousel creation Carousel Assembly: Creates carousel post with all images and caption Publication: Publishes the complete carousel to Instagram Notification: Sends Telegram confirmation message Prerequisites Facebook Graph API credentials with Instagram Business permissions Google Drive API access for image downloads Cloudinary Account for image hosting Instagram Business Account connected to Facebook Telegram Bot for notifications Input Data Structure The workflow expects data with these fields: instagram_content: Caption text for the post Instagram Account ID: Target Instagram business account pose_X_drive_fotolink: Google Drive links for carousel images Image metadata for processing Configuration Options Wait Times: 20s between carousel creation and 15s before publishing for API rate limits Image Processing: Automatic upload to Cloudinary with preset configurations Error Handling: Individual image failures won't stop the entire carousel creation Batch Processing: Processes all images simultaneously for efficiency

Try It Out! The SOL/USDT Multi-Timeframe AI Market Analyzer and Trader with Telegram Approval is your fully automated Solana trading assistant powered by AI, AFK Crypto, and Telegram. It runs hourly by default, fetches real-time market data for the SOL/USDT pair, and uses AI-driven logic to determine optimal entry, exit, and risk management strategies. You receive a Telegram approval message that lets you confirm or reject the trade instantly. Once approved, the bot executes trades via your AFK Crypto Wallet and keeps monitoring for Take-Profit or Stop-Loss triggers — sending alerts directly to Telegram when they’re hit. This system combines automation with manual oversight, giving you AI precision with human approval control. How It Works Hourly Trigger – The workflow initiates every hour to analyze the current market status. Fetch SOL Market Data (Crypto Compare) – Retrieves multiple timeframe data (1m, 5m, 1h) for trend, momentum, and volatility analysis. AI Market Analyzer – Processes data through an AI agent to identify: Market sentiment (bullish, bearish, neutral) Recommended position: LONG / SHORT / HOLD Stop-Loss and Take-Profit levels Confidence rating and reasoning Balance Check (AFK Crypto) – Verifies wallet balance via /v1/wallets/balances?chain=solana and calculates position size based on 1% risk. Telegram Approval Message – Sends a Telegram message containing AI insights and trade details with “✅ Approve” or “❌ Decline” buttons. Trade Execution (AFK Trade API) – If approved, executes trade instantly via /v1/trade/swap using your AFK Crypto wallet. Live Trade Monitoring – Monitors SOL price in real-time. Once Take-Profit or Stop-Loss conditions are met: The position auto-closes. A Telegram notification is sent summarizing results and updated balance. How to Use Import the workflow into your n8n workspace. Add your credentials: AFK Crypto API Key – For balance and trading operations. Telegram Bot Token + Chat ID – For sending messages and approvals. Crypto Compare API Key – For fetching market data. Edit “Fetch SOL Market Data” Node: Update the endpoint if you want different timeframes or markets. Set the schedule: Default trigger = every hour (modifiable in the “Every Hour” node). Deploy and activate. The bot will send you hourly market analyses via Telegram — allowing you to approve or skip each suggested trade. (Optional) Extend This Workflow Auto Mode:** Allow the AI to auto-trade when confidence > 90%. Portfolio Sync:** Log every trade and PnL automatically to Notion or Airtable. Risk Adjuster:** Dynamically modify the 1% risk per trade based on balance or volatility. Multi-Pair Trading:** Expand to include ETH/USDT or BTC/USDT using the same logic. Requirements AFK Crypto Wallet + API Key** Telegram Bot Token + Chat ID** Crypto Compare API Key** n8n Instance** with HTTP Request, AI, and Telegram nodes enabled AFK APIs Used GET https://api.afkcrypto.com/v1/wallets/balances?chain=solana POST https://api.afkcrypto.com/v1/trade/swap Summary The SOL/USDT Multi-Timeframe AI Market Analyzer and Trader with Telegram Approval workflow is an intelligent trading automation system that merges AI analytics, Telegram decision prompts, and AFK Crypto execution. It empowers you to make data-driven trading decisions — with AI doing the heavy lifting and you retaining the final say before every trade. A perfect hybrid between automation and control, optimized for active Solana traders who value precision and security. Our Website: https://afkcrypto.com/ Check our blogs: https://www.afkcrypto.com/blog

Description This workflow intelligently scans your inbox, detects whether an email is marketing or genuine, and takes the right action automatically. Marketing Emails : Deleted instantly and logged in Google Sheets for tracking. Non-Marketing Emails : Receive a customized, polite reply crafted using AI. Tracking : Every action (delete/reply) is recorded for auditing and reference. Accounts & Tools n8n instance (self-hosted or cloud). Google account with: Gmail API access (for reading, deleting, and replying). Google Sheets API access (for logging deleted/replied emails). IMP/SMTP credentials (if using IMAP trigger instead of Gmail API). Google Gemini (PaLM) API key to classify emails and generate replies. Setup instructions Create a n8N account on cloud or install it locally. follow the quick start guide this Define your trigger point for your workflow as how or when this needs to run. Currently IMAP has been used to detect if any email is received and if so, trigger the workflow Now, we need to setup the google account which allows our workflow to read emails. Follow this guideline to setup gmail account Next step is to add an AI tool which is google gemini here. To set up and use, see this guideline Since AI response is in text, we need a parser tool to read a specific value from text Setup a categorization tool like this Next is to send or delete email and for this, an existing gmail setup is going to work In the last, we need to set a connection for sheet to keep the logs. Adding any sheet to workflow can be seen as google sheet integration How it work Once any emails is received, IMAP detects and starts the workflow. Now, email is passed to AI model to see if this email is a marketing email or not. Also, is its not a marketing email, it generates a tailored response. Currently, sender, subject and body of email is being scanned and marked as marketing based on model's feedback. Since AI response is in text format, using a formattor to parse it Next step is to read its category as if it is a marketing email Based on email type, there are 2 steps: delete email if it is a marketing email Read the response from previos node and send that as reply Last step is track this activity as which emails is deleted or replied. In terms of structure of sheet, it has 2 tabs deleted emails & replied emails and both have 2 columns Email ID subject Future Use it to categories emails for wider range like job applications, bills, customer supprt and tailor replies for each categories seperately Logging can done in wider sources like databases etc In case if we are logging on sheet, a further enhancements like follow up emails etc can be done

CSO Agent with Sales Team Description Complete AI-powered sales department with a Chief Sales Officer (CSO) agent orchestrating specialized sales team members for comprehensive revenue operations and sales automation. Overview This n8n workflow creates a comprehensive sales department using AI agents. The CSO agent analyzes sales opportunities and delegates tasks to specialized agents for lead generation, copywriting, proposals, objection handling, demos, and follow-up sequences. Features Strategic CSO agent using OpenAI O3 for complex sales strategy and decision-making Six specialized sales agents powered by GPT-4.1-mini for efficient execution Complete sales funnel coverage from lead generation to deal closure Automated proposal and contract generation Objection handling playbooks and closing techniques Demo preparation and presentation materials Follow-up and nurture campaign automation Team Structure CSO Agent**: Strategic sales oversight and team coordination (O3 model) Lead Generation Specialist**: Prospecting, research, qualification, cold outreach Sales Copywriter**: Pitch decks, proposals, sales collateral, persuasive content Proposal & Contract Specialist**: Deal structuring, terms negotiation, contracts Objection Handler**: Sales objections, responses, closing techniques Demo & Presentation Expert**: Demo scripts, presentation materials, call preparation Follow-up & Nurture Specialist**: Sequence campaigns, relationship building How to Use Import the workflow into your n8n instance Configure OpenAI API credentials for all chat models Deploy the webhook for chat interactions Send sales requests via chat (e.g., "Create a complete B2B SaaS sales campaign") The CSO will analyze and delegate to appropriate specialists Receive comprehensive sales deliverables and strategies Use Cases Complete Sales Funnels**: Lead generation → Qualification → Demo → Proposal → Close Account-Based Sales**: Personalized outreach strategies for enterprise accounts Product Launch Sales**: Go-to-market strategy with full sales enablement Objection Playbooks**: Comprehensive responses to common sales objections Demo Optimization**: Compelling presentations tailored to different audiences Follow-up Automation**: Systematic nurturing to prevent lead loss Proposal Generation**: Professional proposals with terms and pricing Sales Training**: Objection handling and closing technique development Requirements n8n instance with LangChain nodes OpenAI API access (O3 for CSO, GPT-4.1-mini for specialists) Webhook capability for chat interactions Optional: Integration with CRM systems (Salesforce, HubSpot, etc.) Cost Optimization O3 model used only for strategic CSO decisions GPT-4.1-mini provides 90% cost reduction for specialist tasks Parallel processing enables simultaneous agent execution Template library reduces redundant content generation Integration Options Connect to CRM systems for lead management Integrate with email platforms for outreach automation Link to proposal and contract management tools Export to sales enablement platforms Performance Metrics Lead qualification accuracy and conversion rates Proposal win rates and deal velocity Objection handling success rates Demo-to-close conversion optimization Follow-up engagement and response rates Contact & Resources Website**: nofluff.online YouTube**: @YaronBeen LinkedIn**: Yaron Been Tags #SalesOps #LeadGeneration #SalesEnablement #RevenueGrowth #SalesAutomation #B2BSales #SalesStrategy #ProposalAutomation #DemoOptimization #SalesAI #n8n #OpenAI #MultiAgentSystem #SalesTech #RevOps #PipelineAutomation