Category: n8n Workflows

  • Automate Saas Operations With Gpt 4.1 Mini For User, Support & Billing Management 11859 – n8n Workflows – Free Template

    What This Workflow Does

    This n8n workflow automates unified user, support, and billing management for SaaS platforms using AI-powered intelligence. It combines GPT 4.1-mini capabilities with integrated tools to handle customer inquiries, route support tickets, manage user data, and streamline billing operations—all in one centralized system. The workflow reduces manual overhead by up to 70% and accelerates ticket routing by 10x.

    How It Works

    The workflow operates through an intelligent multi-step process:

    • Form submissions and scheduled triggers initiate the workflow with customer data
    • The AI agent (powered by GPT 4.1-mini and OpenAI) analyzes incoming requests and determines appropriate actions
    • A data table stores and retrieves customer, support ticket, and billing information in real-time
    • Conditional logic routes different request types to specialized handlers
    • Gmail integration sends automated responses and notifications to customers
    • The structured output parser formats AI responses into actionable data
    • Webhooks enable integration with external systems and platforms
    • MCP server connections extend functionality for advanced operations

    Use Cases

    • Automated customer support ticket creation, categorization, and routing based on issue type and priority
    • Customer onboarding automation with welcome emails and billing plan assignments
    • Intelligent FAQ responses that handle common questions before escalating to human support
    • Billing inquiry management including invoice generation, payment status checks, and subscription updates
    • Multi-tier support escalation that routes complex issues to appropriate team members with full context

    Nodes Used

    • formTrigger: Captures customer inquiries and form submissions
    • set: Transforms and prepares data for processing
    • dataTable: Centralizes storage for users, tickets, and billing records
    • @n8n/agent: Orchestrates AI decision-making and task routing
    • @n8n/lmChatOpenAi: Integrates GPT 4.1-mini for natural language processing
    • @n8n/outputParserStructured: Converts AI responses into structured data formats
    • dataTableTool: Enables AI agent to query and update customer databases
    • gmailTool: Allows AI to draft and manage email communications
    • webhook: Connects to external platforms and third-party systems
    • if: Creates conditional branches for different workflow paths
    • gmail: Sends emails directly to customers and team members
    • scheduleTrigger: Runs recurring tasks on defined schedules
    • aggregate: Combines data from multiple workflow branches
    • code: Executes custom JavaScript logic for advanced operations
    • httpRequest: Makes API calls to external services
    • @n8n/mcpTrigger: Connects to MCP servers for extended capabilities
    • stickyNote: Documents workflow logic and configuration notes

    Prerequisites

    • Active OpenAI API key with access to GPT 4.1-mini model
    • Gmail account with app-specific password enabled for authentication
    • Access to MCP Server infrastructure for advanced integrations
    • Data Table Tool credentials configured in n8n environment
    • Basic understanding of n8n workflow structure and node connections
    • Optional: Slack or Teams workspace for notification integrations

    Difficulty Level

    Intermediate to Advanced. This workflow requires familiarity with AI prompt customization, data management concepts, and API integrations. Users should understand conditional logic and be comfortable configuring OpenAI credentials and Gmail authentication. Customization for specific support categories and notification systems requires moderate technical knowledge but can be achieved without coding experience.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.

  • Automate Sales Call Grading With Fireflies.Ai, Openai, And Google Sheets 9381 – n8n Workflows – Free Template

    What This Workflow Does

    This workflow automates the grading and analysis of onboarding calls by integrating Fireflies.ai recording transcription with OpenAI’s intelligent analysis. It captures call recordings, transcribes them, analyzes performance metrics, and distributes results through email and Slack notifications while logging data in Google Sheets.

    How It Works

    The workflow operates through the following process:

    • A webhook receives notifications when new onboarding calls are recorded in Fireflies.ai
    • Call data is retrieved and processed through the Fireflies.ai integration
    • OpenAI analyzes the call transcript to extract key metrics and grading information
    • A custom code node processes and formats the analysis results
    • Results are logged to Google Sheets for record-keeping and analytics
    • Email notifications are sent with detailed grading reports
    • Slack messages post summaries for team visibility

    Use Cases

    • SaaS companies grading sales representative performance on customer onboarding calls
    • Consulting firms evaluating client discovery session quality and consultant effectiveness
    • Customer success teams assessing onboarding call completion rates and customer engagement levels
    • Training departments using call analysis to identify coaching opportunities for new employees
    • Remote teams maintaining call quality standards across distributed onboarding processes

    Nodes Used

    • Webhook: Receives incoming call notifications from Fireflies.ai
    • Fireflies.ai: Retrieves call recordings and transcription data
    • OpenAI: Performs intelligent analysis and grading of call transcripts
    • Code: Processes and formats the analysis output into actionable metrics
    • Google Sheets: Stores grading results and historical call data
    • Gmail: Sends detailed email reports with grades and feedback
    • Slack: Posts notifications and summaries to team channels
    • Sticky Note: Provides workflow documentation and setup notes

    Prerequisites

    • Active Fireflies.ai account with webhook integration capability
    • OpenAI API key generated from your OpenAI platform account
    • Google Sheets document created for storing call grades and metrics
    • Gmail account configured in n8n for sending email reports
    • Slack workspace with bot permissions for posting notifications
    • n8n instance with webhook capabilities enabled

    Difficulty Level

    Intermediate. This workflow requires setup of multiple external API credentials and integrations. Users should be comfortable connecting third-party services, configuring webhook URLs, and understanding basic API authentication. Some familiarity with JSON data handling and Google Sheets structure is helpful but not required.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.

  • Automate Sales Call Research And Follow Ups With Gpt 4, Tavily, Google Sheets 7491 – n8n Workflows – Free Template

    What This Workflow Does

    This n8n automation streamlines sales preparation by automatically researching companies, enriching prospect data, and generating personalized follow-up communications. When a sales call is scheduled, the workflow pulls company information, conducts web research using AI, and creates customized email and SMS templates directly in Google Sheets—eliminating manual research and saving hours of preparation time.

    How It Works

    The workflow follows these sequential steps:

    • A manual trigger initiates the automation when a new sales call is added to Google Sheets
    • The n8n agent coordinates the research process using GPT-4 and web search capabilities
    • Tavily conducts real-time web searches to gather company intelligence and industry insights
    • GPT-4 analyzes the research data and generates personalized follow-up emails and SMS messages
    • An output parser structures the generated content into a consistent format
    • The HTTP request tool handles any additional API calls or data enrichment needs
    • Results are automatically populated into designated Google Sheets tabs for easy access and review

    Use Cases

    • B2B Sales Teams: Sales representatives automatically receive researched company profiles and talking points before client calls, enabling more informed and confident conversations
    • Recruitment Agencies: Recruiters gain instant background information on hiring companies and candidates, improving pitch relevance and interview preparation quality
    • Consulting Firms: Consultants access industry trends and company-specific challenges before discovery calls, demonstrating expertise and accelerating proposal development
    • SaaS Account Executives: Account managers receive competitive intelligence and company growth data to personalize outreach and identify upsell opportunities
    • Insurance Brokers: Brokers quickly identify company risk profiles and industry-specific insurance needs before client meetings, improving quote accuracy and customer satisfaction

    Nodes Used

    • Manual Trigger: Initiates the workflow on demand when sales calls are scheduled
    • n8n Agent: Orchestrates the entire research and content generation process using AI reasoning
    • LM Chat OpenAI: Leverages GPT-4 to analyze research data and generate personalized communications
    • Output Parser Structured: Formats AI-generated content into consistent, usable data structures
    • Google Sheets: Serves as the central data repository for prospect information and generated content
    • Google Sheets Tool: Enables direct data reads and writes to spreadsheet tabs
    • Tool HTTP Request: Handles supplementary API calls for data enrichment
    • Sticky Note: Provides inline documentation and workflow instructions for team members

    Prerequisites

    • Active n8n account with workflow execution credits
    • OpenAI API key for GPT-4 access
    • Google Cloud project with Sheets API enabled and appropriate authentication configured
    • Tavily API key for web search functionality
    • Pre-configured Google Sheet with Meeting Data and Follow-Ups tabs
    • Basic understanding of n8n workflow structure and node connections
    • Proper IAM permissions for Google Sheets access and modification

    Difficulty Level

    Intermediate to Advanced. This workflow requires familiarity with API authentication, n8n agent configuration, and Google Sheets integration. Users should be comfortable setting up multiple API credentials and understanding how to structure data flows between nodes. Prior experience with GPT-4 prompting and web API usage is beneficial.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.

  • Automate Sales Cold Calling Pipeline With Apify, Gpt 4O, And Whatsapp 5449 – n8n Workflows – Free Template

    What This Workflow Does

    This n8n workflow creates an intelligent company knowledge base system that combines document scraping, AI-powered embeddings, and conversational chatbot capabilities. It automatically processes documents from Google Drive, chunks them intelligently, stores them in a vector database, and enables users to query the knowledge base through multiple channels including web chat, WhatsApp, and webhooks.

    How It Works

    The workflow operates through several integrated stages:

    • Documents are automatically triggered from Google Drive or manually uploaded
    • Content is loaded and cleaned using the default data loader
    • Text is split into manageable chunks using recursive character splitting
    • OpenAI embeddings convert text chunks into vector representations
    • Vectors are stored in Supabase for efficient retrieval
    • User queries are reranked using Cohere for relevance optimization
    • An AI agent powered by OpenAI LLM provides intelligent responses
    • Conversation memory is maintained in PostgreSQL for context awareness
    • Results are delivered through multiple channels: web chat, WhatsApp, Google Sheets, or HTTP responses

    Use Cases

    • Internal company knowledge base providing employees instant access to policies, procedures, and documentation
    • Customer support chatbot trained on product documentation, FAQs, and support articles
    • Sales enablement tool that helps teams quickly find relevant company information and lead details
    • Lead intelligence system that processes potential customer data and provides qualified prospect information
    • Multi-channel customer service bot accessible via web chat, WhatsApp, and other platforms simultaneously

    Nodes Used

    • Google Drive Trigger and Node: Document source and file management
    • Document Default Data Loader: Content extraction and preparation
    • Text Splitter Recursive Character: Intelligent text chunking
    • OpenAI Embeddings: Vector representation generation
    • Supabase Vector Store: Persistent vector database storage
    • Cohere Reranker: Relevance ranking and result optimization
    • OpenAI LLM Chat: Conversational AI responses
    • PostgreSQL Memory: Chat history and context management
    • n8n Agent: Orchestration and decision-making logic
    • Chat Trigger: Web interface for user interactions
    • WAHA Trigger: WhatsApp integration and messaging
    • Google Sheets: Data input and output
    • HTTP Request and Webhook: External integrations and API calls

    Prerequisites

    • Active n8n instance or n8n Cloud account
    • Google Drive account with documents to index
    • OpenAI API key for embeddings and LLM capabilities
    • Cohere API key for advanced reranking functionality
    • Supabase project with vector support enabled
    • PostgreSQL database for conversation memory storage
    • WhatsApp Business Account (optional, for messaging integration)
    • Google Sheets access for data management (optional)

    Difficulty Level

    Advanced. This workflow requires familiarity with vector databases, embeddings, multiple API integrations, and configuration of authentication credentials across various services. It combines sophisticated AI/ML components with complex data pipelines and multiple trigger types. Best suited for users with experience in automation workflows and AI integration.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.

  • Automate Sales Follow Ups With Gpt 4O Mini, Hubspot, Slack, Teams & Telegram 8468 – n8n Workflows – Free Template

    What This Workflow Does

    The Smart Follow-Up Engine is an automated workflow that intelligently manages contact follow-ups across multiple communication channels. It enriches contact data from HubSpot, generates personalized follow-up messages using AI, and delivers them through Slack, Telegram, Microsoft Teams, and Monday.com simultaneously. This ensures no leads fall through the cracks and every prospect receives timely, contextual engagement.

    How It Works

    The workflow operates through several key stages:

    • Scheduling: A schedule trigger initiates the workflow at predetermined intervals
    • Data Setup: The Set node defines initial contact information including name, email, and interaction context
    • Contact Enrichment: HubSpot Contact Lookup searches and retrieves comprehensive contact details from your CRM database
    • AI Message Generation: The LM Chat OpenAI node creates personalized, context-aware follow-up messages based on contact history
    • Multi-Channel Distribution: The AI Agent orchestrates message delivery across Slack, Telegram, and Microsoft Teams
    • Team Collaboration: Monday.com integration logs follow-up activities for project tracking and team coordination
    • Documentation: Sticky Note captures workflow execution details for auditing and analysis

    Use Cases

    • Sales Pipeline Management: Automatically follow up with prospects after demos or initial consultations, keeping them engaged without manual intervention
    • Customer Onboarding: Send timely follow-up messages to newly signed customers with onboarding resources and support information
    • Lead Nurturing Campaigns: Deliver personalized educational content to warm leads based on their specific interests and interaction history
    • Event Follow-ups: Reach out to conference attendees or webinar participants with customized messages referencing their areas of interest
    • Win-back Campaigns: Re-engage inactive customers with personalized messages highlighting new features or special offers

    Nodes Used

    • Schedule Trigger: Initiates the workflow on a recurring schedule
    • Set: Configures initial data structure with contact information and context
    • HubSpot: Searches and retrieves contact records from HubSpot CRM
    • LM Chat OpenAI: Generates personalized follow-up messages using GPT models
    • Agent: Orchestrates workflow logic and decision-making processes
    • Slack: Sends follow-up notifications to internal team channels
    • Telegram: Delivers messages via Telegram for instant team communication
    • Microsoft Teams: Posts follow-up summaries to Teams channels
    • Monday.com: Logs follow-up activities and updates project boards
    • Sticky Note: Documents workflow execution and audit trail

    Prerequisites

    • Active n8n instance with access to automation features
    • HubSpot account with API credentials and contact database
    • OpenAI API key for GPT-powered message generation
    • Slack workspace with bot integration permissions
    • Telegram bot token and channel access
    • Microsoft Teams account with webhooks enabled
    • Monday.com account with API access
    • Proper authentication credentials for all integrated services
    • Understanding of workflow scheduling and cron expressions

    Difficulty Level

    Intermediate to Advanced

    This workflow requires familiarity with multiple third-party integrations, API authentication, and AI prompt engineering. Users should have experience with CRM systems, understand how to structure contact data, and be comfortable configuring complex multi-node sequences. However, the workflow provides a solid template that can be adapted to simpler use cases by disabling unnecessary notification channels.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.

  • Automate Seo Blog Post Creation And Publishing With Openai & WordPress 7038 – n8n Workflows – Free Template

    What This Workflow Does

    This n8n workflow automates the entire process of creating and publishing SEO-optimized blog posts using OpenAI. It generates high-quality content, optimizes it for search engines, and automatically publishes it directly to WordPress without manual intervention.

    How It Works

    The workflow combines multiple AI models and WordPress integration to streamline content creation:

    • Triggers via schedule, Telegram command, or manual activation
    • Uses OpenAI and alternative LLM providers to generate blog post content
    • Processes and structures the generated content with chain LLM capabilities
    • Applies SEO optimization using AI-powered output parsing
    • Automatically publishes the final post to your WordPress site via HTTP requests
    • Sends notifications through Telegram upon completion

    Use Cases

    • Content marketing agencies automating bulk blog post creation for multiple client websites
    • E-commerce businesses generating product-related SEO content at scale
    • News and media outlets publishing timely, optimized articles automatically
    • SaaS companies maintaining consistent blog publishing schedules without manual effort
    • Affiliate marketers creating niche content optimized for search rankings

    Nodes Used

    • Schedule Trigger – Initiates workflow on a defined schedule
    • Telegram Trigger – Allows manual triggering via Telegram commands
    • OpenAI – Primary AI model for content generation
    • LM Chat OpenAI – Advanced chat-based content creation
    • LM Chat OpenRouter – Alternative LLM provider integration
    • LM Chat Azure OpenAI – Azure-hosted OpenAI models
    • Chain LLM – Sequential processing of AI tasks
    • Output Parser Structured – Converts raw AI output into structured data
    • If Node – Conditional logic for workflow branching
    • HTTP Request – API calls to WordPress endpoints
    • WordPress Node – Native WordPress integration for post publishing
    • Set Node – Variable assignment and data transformation
    • Code Node – Custom JavaScript for advanced logic
    • Sticky Note – Workflow documentation and comments

    Prerequisites

    • Active n8n account or self-hosted n8n instance
    • OpenAI API key or alternative LLM provider credentials (OpenRouter, Azure OpenAI)
    • WordPress site with REST API enabled
    • WordPress user account with post publishing permissions
    • Telegram bot token if using Telegram trigger functionality
    • Basic understanding of n8n workflow configuration
    • API credentials properly stored in n8n environment variables

    Difficulty Level

    Intermediate to Advanced. While the workflow comes pre-configured for basic use, customization requires knowledge of OpenAI prompts, WordPress REST API, and n8n node configuration. Users comfortable with API integrations and automation concepts will find setup straightforward.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.

  • Automate Restaurant Reservations With Ai On Whatsapp And Google Sheets 6379 – n8n Workflows – Free Template

    What This Workflow Does

    This workflow automates restaurant reservation management by integrating WhatsApp messaging with artificial intelligence and Google Sheets data storage. It receives customer messages through WhatsApp, processes them using an AI agent powered by OpenAI, and stores reservation details in Google Sheets for easy management and tracking.

    How It Works

    The workflow operates through a series of intelligent steps that handle customer interactions seamlessly:

    • WhatsApp messages are received through the Facebook Developer App integration
    • Messages are filtered to process only text-based inquiries
    • The AI agent analyzes the message content and generates appropriate responses
    • Reservation data is extracted and stored in Google Sheets
    • Confirmation messages are sent back to customers via WhatsApp
    • A memory buffer maintains conversation context for better AI responses
    • Scheduled triggers enable automated follow-ups and reminders

    Use Cases

    • Small to medium-sized restaurants automating their booking system without hiring additional staff
    • Fine dining establishments managing high-volume reservation requests during peak hours
    • Multi-location restaurant chains coordinating reservations across different branches
    • Casual dining venues collecting customer preferences and dietary restrictions automatically
    • Restaurant groups generating analytics on booking patterns and customer behavior

    Nodes Used

    • WhatsApp Trigger – Initiates workflow when messages arrive
    • WhatsApp Node – Sends messages back to customers
    • AI Agent (@n8n/agent) – Processes and understands customer requests
    • LM Chat OpenAI (@n8n/lmChatOpenAi) – Powers AI responses using OpenAI technology
    • Google Sheets Tool – Manages reservation data storage and retrieval
    • Google Sheets – Direct spreadsheet connection for data management
    • Calculator Tool (@n8n/toolCalculator) – Performs numerical operations for party sizes and table calculations
    • Filter Node – Routes messages based on specific criteria
    • Memory Buffer Window (@n8n/memoryBufferWindow) – Maintains conversation history
    • Schedule Trigger – Enables automated follow-ups and reminder messages
    • If Node – Creates conditional logic for different scenarios
    • Sticky Note – Provides workflow documentation and notes

    Prerequisites

    • Active WhatsApp Business Account
    • Facebook Developer App with proper configuration
    • Facebook Business Manager access
    • OpenAI API key with active credits
    • Google account with Google Sheets access
    • n8n account with workflow automation capabilities
    • Basic knowledge of webhook configurations
    • Restaurant reservation data structure and requirements

    Difficulty Level

    Intermediate – This workflow requires configuration of multiple third-party integrations including Facebook Developer App setup, OpenAI API connection, and Google Sheets authentication. While the n8n interface handles most of the automation logic, users should be comfortable with API credentials, webhook setup, and basic troubleshooting of messaging services.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.

  • Automate Seo Content Creation With Google Serp, Claude Ai, And WordPress 7503 – n8n Workflows – Free Template

    What This Workflow Does

    The Keyword to Blog Post Automation Template is a comprehensive workflow that transforms keyword research into fully-formed blog posts. By integrating multiple automation tools, this template automatically generates SEO-optimized content directly from keyword inputs stored in a spreadsheet, eliminating manual content creation tasks and streamlining your content production pipeline.

    How It Works

    The workflow begins by receiving content ideas through a webhook trigger whenever you mark a keyword as “Prioritized = yes” in your Excel spreadsheet. The system then processes each keyword through an intelligent chain of AI operations:

    • Data is split and processed individually for parallel execution
    • Claude AI generates comprehensive blog post content based on the keyword
    • The output is parsed into a structured format with title, metadata, and body content
    • The finalized post is automatically published to your WordPress website
    • All activity is logged and tracked in Google Sheets for record-keeping

    Use Cases

    • Content agencies managing multiple client blog calendars and needing to scale content production without proportional staff increases
    • E-commerce businesses automating product-related blog posts for SEO improvement and organic traffic growth
    • SaaS companies creating feature-focused blog content that targets specific customer search intent
    • Digital publishers maintaining consistent publishing schedules across multiple niche websites
    • Marketing teams rapidly testing blog content around trending keywords and time-sensitive topics

    Nodes Used

    • Webhook – Receives trigger signals from your content preparation workflow
    • Split Out – Divides batch keyword data into individual items for processing
    • Aggregate – Combines processed results back into consolidated data
    • LM Chat Anthropic – Claude AI engine for intelligent content generation
    • Output Parser Structured – Converts AI responses into formatted data fields
    • Chain LLM – Orchestrates multiple AI operations in sequence
    • HTTP Request – Handles API communications with external services
    • Code – Custom JavaScript for data transformation and logic
    • WordPress – Direct node for automated post publishing and management
    • Google Sheets – Spreadsheet integration for keyword management and logging

    Prerequisites

    • An active n8n instance with workflow execution permissions
    • Google Sheets document containing keywords with a “Prioritized” column
    • WordPress website with API access and authentication credentials
    • Anthropic API key for Claude AI access
    • Google Sheets API credentials for spreadsheet integration
    • Basic understanding of workflow automation concepts

    Difficulty Level

    Intermediate. This workflow requires some technical setup including API credential configuration and basic understanding of data flow automation, but the template is pre-built and ready for customization without requiring advanced coding knowledge.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.

  • Automate Restaurant Sales & Inventory Forecasting With Gemini Ai & Google Sheets 5983 – n8n Workflows – Free Template








    Restaurant Sales & Inventory Forecasting with Gemini AI | n8n Workflow

    What This Workflow Does

    This n8n workflow automates weekly forecasting of restaurant sales and raw material requirements using historical data from Google Sheets and artificial intelligence predictions powered by Google Gemini. The system analyzes past sales patterns and material consumption, generates accurate forecasts, and automatically delivers predictions to stakeholders via email. This automation enables restaurants to optimize inventory management, reduce food waste, and improve operational efficiency through data-driven planning.

    How It Works

    The workflow operates on a scheduled basis, triggering automatically at specified intervals. Here is the step-by-step process:

    • Schedule trigger activates the workflow at a designated time each week
    • Google Sheets node retrieves historical sales data and material usage records
    • Code node processes and prepares the data for AI analysis
    • Gemini AI analyzes patterns in the historical data to identify trends
    • The AI agent generates forecasts for upcoming sales volumes and material requirements
    • Think tool structures the forecast insights for clear presentation
    • Gmail node sends the forecast report to designated stakeholders

    Use Cases

    • Weekly Inventory Planning: Restaurants can automatically receive weekly forecasts to determine exact quantities of ingredients to order, preventing both stockouts and excess inventory
    • Food Cost Management: Use AI predictions to align purchasing with expected demand, reducing spoilage and improving profit margins
    • Staff Scheduling Optimization: Forecast expected customer volumes help managers schedule appropriate staffing levels to match anticipated business
    • Supplier Coordination: Share accurate demand forecasts with suppliers to negotiate better terms and ensure reliable delivery of materials
    • Menu Planning: Identify seasonal trends and popular dishes through sales forecasting to make informed decisions about menu changes and promotions

    Nodes Used

    • Sticky Note: Documentation and workflow notes
    • Schedule Trigger: Initiates workflow execution at specified intervals
    • Google Sheets: Retrieves historical sales and inventory data
    • Code: Processes and transforms data for analysis
    • Gemini AI (@n8n/lmChatGoogleGemini): Performs artificial intelligence analysis and forecasting
    • Agent (@n8n/agent): Orchestrates the workflow logic and decision-making
    • Think Tool (@n8n/toolThink): Structures and formats forecast insights
    • Gmail: Sends forecast reports to stakeholders

    Prerequisites

    • n8n instance with access to workflow creation and editing
    • Google Sheets account containing historical sales and material usage data
    • Google Gemini API key configured in n8n credentials
    • Gmail account configured for sending automated emails
    • Historical data spanning at least several weeks to enable accurate pattern recognition
    • Properly formatted data in Google Sheets with consistent column headers
    • Email addresses of intended forecast recipients

    Difficulty Level

    Intermediate to Advanced: This workflow requires familiarity with n8n node configuration, Google Sheets API integration, and AI prompt engineering. Users should have experience connecting external APIs and understanding basic JavaScript for data transformation. Prior knowledge of restaurant operations or inventory management is helpful but not required.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.


  • Automate Seo Keyword & Serp Analysis With Dataforseo And Google Sheets 10137 – n8n Workflows – Free Template

    What This Workflow Does

    This n8n workflow automates SEO data collection by integrating with the DataforSEO API. It allows users to submit keyword queries along with location and language preferences, then automatically retrieves comprehensive SEO intelligence data and stores it in Google Sheets for analysis and reporting.

    How It Works

    The workflow follows a structured process to gather and organize SEO data:

    • A form trigger captures user input including the target keyword, desired operation type, location, and language preferences
    • A switch node evaluates the operation type selected by the user to determine which SEO analysis to perform
    • The workflow dynamically creates a new Google Sheet with a title combining the keyword and operation type for organized data storage
    • An HTTP request node sends the collected parameters to the DataforSEO API with proper authentication
    • The returned API data is processed through filter and conditional nodes to extract relevant information
    • Results are automatically populated into the corresponding Google Sheet for easy access and further analysis

    Use Cases

    • Competitive keyword analysis across multiple locations and languages to identify ranking opportunities
    • Automated tracking of keyword rankings over time by running regular workflow executions and comparing historical data
    • Multi-location SEO reporting for agencies managing clients in different geographic markets
    • Bulk keyword research operations that process large keyword lists and organize results by region and language
    • Content strategy development by analyzing search intent and competitor data for specific keywords

    Nodes Used

    • Form Trigger: Captures user input for keyword, operation type, location, and language
    • HTTP Request: Sends API calls to DataforSEO endpoints with specified parameters
    • Switch: Routes workflow execution based on the selected operation type
    • Set: Transforms and prepares data for downstream processes
    • Split Out: Distributes data across multiple execution paths when needed
    • Google Sheets: Creates sheets and stores API results for analysis
    • Filter: Removes irrelevant data points from API responses
    • If: Applies conditional logic to handle different data scenarios
    • Sticky Note: Provides workflow documentation and navigation guidance

    Prerequisites

    • Active n8n instance with workflow creation permissions
    • DataforSEO API account with valid credentials and active subscription
    • Google Sheets API enabled and authenticated with appropriate Google account
    • Basic understanding of SEO terminology and available DataforSEO operations
    • Knowledge of workflow parameters: target keywords, supported locations, language codes, and operation types

    Difficulty Level

    Intermediate. This workflow requires familiarity with API integration, Google Sheets automation, and basic n8n node configuration. While the workflow structure is straightforward, successful implementation depends on properly configuring DataforSEO credentials and understanding the specific API operations and parameters available.

    This workflow template is shared under the n8n fair-code license. Free to use and modify.