by Harsh Maniya
✨ Automate Daily Hindu Festival Posts on X (Twitter) with AI 🐦 This workflow automates the entire process of creating and publishing culturally rich social media content about Hindu festivals. It starts by building a comprehensive festival calendar for the year in a Google Sheet, then runs daily to post engaging, bilingual updates on X (formerly Twitter). 🗓️ The workflow uses a sophisticated dual-AI system: Google Gemini acts as a content generator creating multiple post options ✍️, while OpenAI's GPT-4o Mini acts as a discerning social media manager, selecting the very best post for publication. 🧠 This ensures your content is not only automated but also high-quality and optimized for engagement. How it works ⚙️ This workflow operates in two distinct stages: Part 1: Data Population (One-Time Manual Run) 🔍 Fetch Festival Data: Manually trigger the workflow to scrape a list of 2025 Hindu festivals from a public calendar using the Jina AI Reader API. ✨ Enrich with AI: For each festival, a Google Gemini model researches and extracts key details: The festival's name in Hindi. A concise description of its significance in English. A Hindi translation of the description. 📝 Store in Google Sheets: The enriched data for the entire year is then systematically organized and saved in a designated Google Sheet, creating a content calendar. Part 2: Daily Automated Posting ⏰ Daily Trigger: A Schedule Trigger node activates the workflow every morning at 8 AM. ✔️ Check for Festivals: The workflow gets today's date and checks the Google Sheet to see if there is a corresponding festival. 🎨 Generate Post Options: If a festival is scheduled for the day, Google Gemini generates three distinct and engaging post options for X. Each post is crafted to be concise, use a mix of English and Hindi, and include relevant emojis and hashtags. 🏆 Select the Best Post: OpenAI's GPT-4o Mini then evaluates the three generated posts based on criteria like clarity, engagement potential, and effective use of language. It selects the single most impactful post. 🚀 Publish to X: The winning post is automatically published to your connected X account. Features ⭐ 🤖 Fully Automated Content Pipeline: From data collection to final publication, no manual intervention is needed after the initial setup. 🧠 Dual-AI System: Leverages Google Gemini for creative generation and OpenAI GPT-4o Mini for critical selection, ensuring high-quality output. 🗣️ Bilingual Content: Creates posts that blend English and Hindi to enhance cultural connection and broaden audience reach. 🎯 Dynamic and Contextual: Posts are automatically tailored to the specific festival of the day. 🗓️ Centralized Content Calendar: Uses Google Sheets as a reliable, easy-to-manage database for your yearly social media plan. Prerequisites 🛠️ Before you can use this workflow, you will need to: Have an n8n instance set up. Create a new, empty Google Sheet. Obtain credentials for the following services: Jina AI: Get a free Bearer Token from the Jina AI API page. Google: Set up Google credentials (OAuth2) for the Google Sheets and Google Gemini nodes. OpenAI: Get an API key from your OpenAI Platform dashboard. X (Twitter): Set up X credentials (OAuth2) to allow n8n to post on your behalf. How to use this template 🚀 🔑 Set up Credentials: In n8n, go to the "Credentials" section and add new credentials for Jina AI, Google (for both Sheets and Gemini), OpenAI, and X using the API keys and tokens you obtained. 📊 Configure the Google Sheet: Create a new Google Sheet. In the first row, create the following headers exactly as written: Name of the Festival Date English Description (Note the trailing space) Hindi Description Open the "Add all Rows at once" and "Fetch Data of Matched Date" nodes in the workflow and connect them to your Google account and select the Sheet you just created. ▶️ Populate the Data (Manual Step): Click the "Execute workflow" button on the When clicking ‘Execute workflow’ node. This will run the first part of the workflow, filling your Google Sheet with festival data for 2025. This only needs to be done once. ✅ Activate the Workflow: Save the workflow and then activate it using the toggle at the top right of the n8n canvas. The workflow will now run automatically every day to post about the day's festival. Extending the Workflow 💡 🖼️ Add Image Generation: Integrate a node like DALL-E or Midjourney to generate a unique image for each festival and include it in the tweet. 🌐 Cross-Platform Posting: Duplicate the final "Post to X" node and adapt it to post on other platforms like Facebook, LinkedIn, or Telegram. 🎨 Change the Tone: Modify the prompts in the "Generate Posts" and "Select Best Post" nodes to change the style of your social media content—make it more formal, humorous, or poetic. 📅 Use a Different Year: Update the URL in the "Get Festival Data" node to fetch data for a different year. The current URL is https://r.jina.ai/https://www.calendarlabs.com/2025-hindu-calendar.
by Joseph LePage
This workflow creates an automated system for monitoring and receiving notifications about new videos from your favorite YouTube channels through RSS feeds, with customizable email and Telegram notifications. 🌟 Key Features 📡 RSS Feed Management Accepts custom YouTube channel IDs or uses default channels Automatically creates RSS feeds for each YouTube channel Monitors channels for new video uploads Labels and filters recent videos within a 3-day window (change this as required) 📨 Multi-Channel Notification System Sends Telegram notifications with video thumbnails and links Delivers customized email notifications in two formats: Individual emails for each new video Single digest email containing all new videos ⚙️ Content Processing Fetches detailed video information using YouTube API Creates responsive HTML email templates with video previews Includes video thumbnails, titles, descriptions, and direct links Maintains professional formatting across different email clients 🛠️ Setup Requirements 🔑 API Configuration YouTube Data API credentials Gmail account for sending notifications Telegram bot token and chat ID OpenAI API key for content processing 📋 Channel Management Add YouTube channel IDs through form input Configure default channel list Set notification preferences Adjust monitoring schedule This workflow is perfect for content creators, marketers, or anyone wanting to stay updated with their favorite YouTube channels through automated, professionally formatted notifications delivered via email and Telegram.
by Sebastian/OptiLever
SWOT Analysis Generator That Produces PDF Reports In n8n Want to skip the manual work and instantly generate SWOT analyses for your business plans, investor decks, or strategy docs? 🚀 This workflow lets you automate the entire SWOT (Strengths, Weaknesses, Opportunities, Threats) process—using AI and no-code tools! Whether you're using this for yourself or creating documents for clients, this workflow will save you hours of time and help identify the key components of growing any business. Tools We’ll Be Using: OpenAI API**: Powers AI-driven extraction and generation of SWOT sections, introductions, conclusions, and more. n8n**: The no-code automation platform that orchestrates this workflow. Google Sheets**: Stores your company data and report outputs (download the provided "SWOT Analysis" template and fill it out). APITemplate.io**: Converts HTML reports into downloadable, multi-page PDFs. DeepSeek API* *(optional): An alternative to OpenAI for specific reasoning tasks. Gmail OAuth2**: Sends the final report via email. If you’re building a business, doing client work, or just want faster strategic planning—this will save you HOURS. How It Works This n8n workflow transforms structured company data from a Google Sheet into a fully formatted, investor-grade SWOT report in both HTML and PDF formats. Here’s the process in a few high-level steps: Load Data: Pulls company information from the "Company Info Input" tab in the "SWOT Analysis" Google Sheet. AI Analysis: Uses AI (via OpenAI or DeepSeek) to categorize data into Strengths, Weaknesses, Opportunities, and Threats, and generates detailed narrative sections for each. Create Report Sections: Produces a strategic introduction, conclusion, table of contents, and title page using AI. Format and Combine: Converts all sections into styled HTML and merges them into a single document. Generate PDF: Converts the HTML into a polished, multi-page PDF using APITemplate.io. Save and Share: Saves the report back to Google Sheets and emails the PDF to a specified recipient. The result is a professional, investor-ready SWOT report with minimal manual effort, ready for sharing or review. Setup Steps Setting up this workflow typically takes 15-30 minutes, depending on your familiarity with the tools. Here’s what you’ll need to do: Configure Credentials**: Set up API keys and OAuth2 credentials for Google Sheets, OpenAI, APITemplate.io, Gmail, and optionally DeepSeek. Prepare Your Google Sheet**: Download the provided "SWOT Analysis" template, fill out the "Company Info Input" tab with your company data, and ensure it’s accessible. Import the Workflow**: Copy the workflow JSON into your n8n instance and connect your credentials. Detailed instructions for each step, including credential setup and customization options, are available in the sticky notes within the workflow. Refer to these for step-by-step guidance. Benefits Efficiency**: Automates the entire SWOT report generation process, saving hours of manual work. Professional Output**: Delivers fully styled HTML and PDF reports with headings, paragraphs, and custom layouts. AI-Driven Insights**: Ensures clarity and relevance in every section through targeted AI analysis. Seamless Sharing**: Automatically saves reports to Google Sheets and emails them to stakeholders. This workflow is perfect for entrepreneurs, consultants, or strategists looking to streamline their SWOT analysis process and deliver high-quality, professional reports effortlessly.
by Elay Guez
Stock Analysis Agent (Hebrew, RTL, GPT-4o) Overview Get comprehensive stock analysis with this AI-powered workflow that provides actionable insights for your investment decisions. On a weekly basis, this workflow: Analyzes stock data from multiple sources (Chart-img, Twelve Data API, Alphavantage) Performs technical analysis using advanced indicators (RSI, MACD, Bollinger Bands, Resistance and Support Levels) Scans financial news from Alpha Vantage to capture market sentiment Uses OpenAI's GPT-4o to identify patterns, trends, and trading opportunities Generates a fully styled, responsive HTML email (with proper RTL layout) in Hebrew Sends detailed recommendations directly to your inbox Perfect for investors, traders, and financial analysts who want data-driven stock insights - combining technical indicators with news sentiment for more informed decisions. Setup Instructions Estimated setup time: 15 minutes Required credentials: OpenAI API Key Chart-img API Key (free tier) Twelve Data API Key (free tier) Alpha Vantage API Key (free tier) SMTP credentials (for email delivery) Steps: Import this template into your n8n instance. Add your API keys under credentials. Configure the SMTP Email node with: Host (e.g., smtp.gmail.com), Port (465 or 587), Username (your email), Password (app-specific password or login). Activate the workflow. Fill in the Form. Enjoy! (Check your Spam mailbox) Customization Tips Modify the analysis timeframe (daily, weekly, monthly) Add integrations with trading platforms or portfolio management tools Adjust the recommendation criteria based on your risk tolerance Why Use This? This is more than just stock data. It's an intelligent financial assistant that combines technical analysis with market sentiment to provide actionable recommendations - automatically. Important Note: This report is being generated automatically and does not constitute an investment recommendation. Please consult a licensed investment advisor before making any investment decisions.
by Niranjan G
How it works This workflow acts like your own personal AI assistant, automatically fetching and summarizing the most relevant Security, Privacy, and Compliance news from curated RSS feeds. It processes only the latest articles (past 24 hours), organizes them by category, summarizes key insights using AI, and delivers a clean HTML digest straight to your inbox—saving you time every day. Key Highlights Handles three independent tracks: Security, Privacy, and Compliance Processes content from customizable RSS sources (add/remove easily) Filters fresh articles, removes duplicates, and sorts by recency Uses AI to summarize and format insights in a digestible format Sends polished HTML digests via Gmail—one per category Fully modular and extensible—adapt it to your needs Personalization You can easily tailor the workflow: 🎯 Customize feeds: Add or remove sources in the following Code nodes: Fetch Security RSS, Fetch Privacy Feeds, and Fetch Compliance Feeds 🔧 Modify logic: Adjust filters, sorting, formatting, or even AI prompts as needed 🧠 Bring your own LLM: Works with Gemini, but easily swappable for other LLM APIs Setup Instructions Requires Gmail and LLM (e.g., Gemini) credentials Prebuilt with placeholders for RSS feeds and email output Designed to be readable, maintainable, and fully adaptable
by Lucas Peyrin
How it works This workflow automates the process of checking for and applying updates to a self-hosted n8n instance running on Docker. It runs on a schedule, checks for new versions, summarizes the release notes with AI, and asks for your approval via Telegram before updating. Scheduled Check: The workflow runs hourly, triggered by a Schedule node. Version Discovery: It first confirms it's running in a Docker environment. It uses SSH to connect to the host machine and inspects the running n8n container to find its current version tag (e.g., latest or next). It then queries the Docker Hub API to compare the image digest (a unique ID for an image version) of the running version against the latest available version for that tag. Update Detection: If the digests do not match, it means a new image has been pushed for your version tag (e.g., a new latest image is available), and an update is needed. AI-Powered Release Notes: It fetches the official release notes for the new version from the GitHub API. An AI model (LLM) summarizes these technical notes into a concise, human-readable overview of the key features and fixes. Manual Approval: It sends a message to a Telegram chat with the AI-generated summary and two buttons: "✅ Update" and "❌ Ignore". The workflow then pauses and waits for your response. Execute Update: If you approve the update, the workflow uses SSH to run a docker compose command on your server, which pulls the new image, stops the old containers, and starts the new ones. Set up steps Setup time: ~5-10 minutes SSH Credentials: Go to Credentials and create a new SSH credential with the username, host, and password/private key for the server where your n8n Docker instance is running. Select this credential in the Get n8n Current Version and Update Docker nodes. Telegram Bot Credentials: Create a Telegram Bot and get its API token. Go to Credentials and create a new Telegram credential with your bot's token. Select this credential in the Send a text message node. AI Model Credentials: Ensure you have credentials for an AI provider (like Google AI, OpenAI, etc.) set up. Select your desired credential in the Google Gemini Chat Model node (or replace it with your preferred LLM node). Configure Paths and Commands: Open the Docker Path node. Set the docker_path to the absolute path of your docker-compose.yml file on the server (e.g., /root/n8n). If you use workers, adjust the worker_command to include the correct --scale argument for your setup. If not, you can leave it blank. Set Your Chat ID: Open the Approve Update Telegram node and enter your personal Telegram Chat ID in the Chat ID field. This ensures the approval message is sent to you. Activate the workflow. It will now check for updates every hour. To enable fully automatic updates (without manual approval): Delete the nodes from Get n8n Releases to Approved ? and connect the Needs Update ? node directly to the Update Docker node.
by Milan Vasarhelyi - SmoothWork
Video Introduction Invoice Processing Automation This template is the automation behind a simple incoming invoice automation tool (AP automation) tool built in Airtable. Link to the Airtable base, and all other tools used, is in notes on the left of the automation. How it works See how it works on video: Full Video Walkthrough 1) We get an email with an invoice attachment: 2) Processes and adds the data to an Airtable interface: 3) Once we approved it and Due date approaches, it shows among Due invoices, where we can track if it's paid. Looking for customization or a custom business app? 📞 Book a Call | 💬 DM me on Linkedin
by Matthieu
LinkedIn Profile Tracker Automation Who is this for? This template is ideal for sales teams, recruiters, business development professionals, and relationship managers who need to monitor changes in their network's LinkedIn profiles. Perfect for agencies tracking client personnel changes, HR teams monitoring talent movements, sales professionals staying updated on prospect job changes, and content teams tracking influencer activity. What problem does this workflow solve? Manually checking LinkedIn profiles for updates like job changes, status modifications, profile edits, or latest posts is extremely time-consuming and easy to miss. This automation eliminates the need for constant manual monitoring while ensuring you never miss important changes that could signal new business opportunities, relationship updates, or content engagement opportunities. What this workflow does This workflow automatically monitors a list of LinkedIn profiles on a weekly schedule, detects any changes in: Personal information** (name, headline, summary) Job status** (hiring/open to work flags) Latest work experience** (new positions, company changes) Recent posts** (latest content activity) When changes are detected, it immediately sends Slack notifications with before/after comparisons and updates your tracking database to maintain historical records of all profile evolution. Setup Create a Ghost Genius API account and get your API key for LinkedIn profile scraping Configure HTTP Request nodes with Header Auth credentials using your Ghost Genius API key Set up your Google Sheets database with columns: Firstname, Lastname, LinkedIn URL, ID Tagline, Summary, Latest experience Open to work?, Hiring?, Latest post Configure Slack webhook integration for real-time notifications Set up credentials for Google Sheets and Slack following n8n documentation Add LinkedIn profile URLs to your Google Sheet to start monitoring How to customize this workflow Modify the schedule trigger** to check profiles daily, bi-weekly, or monthly based on your monitoring needs Customize Slack notification messages** to include additional context, mentions, or custom formatting Add email notifications** alongside Slack alerts for critical changes like job transitions Set up filtered notifications** to only alert on specific types of changes (e.g., job changes only, posts from key influencers) Add post content analysis** to detect mentions of your company or competitors Integrate with CRM systems** to automatically update lead records when profile changes occur
by Mohan Gopal
🎥 AI Tour Video Generator with GPT-4o, RunwayML & ElevenLabs for Social Media' This n8n workflow generates 20-second faceless videos for social media by combining AI-generated images, audio, and video clips for a given tour destination. The output is a ready-to-publish video file, which can be pushed to social platforms and logged in a tracking sheet. ⚙️ Workflow Overview This system is divided into 4 main sections: 🧠 Generate Image Prompts 🎨 Generate Media (Images, Videos, Audio) 🛠️ Render & Upload 📈 Future Enhancements 🔌 Integration Setup Table | Integration | Service Used | Setup Instruction | |--------------------|----------------------------|------------------------------------------------------------------------------------| | OpenAI | GPT-4o (Prompt Generation) | Get API Key and configure in n8n | | Google Sheet | Idea I/O tracking | Connect Google account with OAuth/Credentials in n8n | | Piapia API | AI Image Generation | Sign up at piapia.ai and get API key | | Runway API | AI Video Generation | Register at runwayml.com for access | | ElevenLabs | AI Voice Generation | Sign up at elevenlabs.io for API key | | CreateMate API | Render Final Video | Visit createmate.ai to access API | | Google Drive | Upload/Share Final Video | Use n8n Google Drive node to configure credentials | ✅ Required Services & Tools Ensure you have active accounts with the following tools and services: ✅ OpenAI (GPT-4o + Embeddings) ✅ Google Sheets (for destination ideas and tracking) ✅ Piapia API (Image generation) ✅ RunwayML API (Video generation) ✅ ElevenLabs API (Voiceover TTS) ✅ Google Drive (Storage & Sharing) ✅ CreateMate (Video Rendering) ✅ Social Media Scheduler (Optional - Zapier, Buffer, Make.com) 🧠 1. Generate Image Prompts > Purpose: Prepares the content idea and generates visual prompts. | Step | Node Name | Function | |--------------|------------------------|-----------------------------------------------| | 🔁 Trigger | Schedule or Manual | Starts the workflow | | 📥 Grab Idea | Read Sheet | Pulls destination idea from Google Sheet | | ✍️ Set Content | Manual Input | Adds structure/narrative to the idea | | 🔀 Split | Split Out | Breaks input into chunks | | 🤖 GPT Agent | Image Prompt Agent | Uses GPT-4o to generate creative image prompts| | 🧹 Clean | Remove \n | Cleans up formatting | | 📌 Save | Set Prompts | Finalizes prompts for next stage | 🖼️ 2. Generate Media 🎨 Generate Images | Step | Function | |----------------|-----------------------------------------------------------| | Generate Image | Calls Piapia API with AI-generated prompts | | Wait | Adds delay for rendering (90 sec) | | Get Images | Retrieves final images for video | 🎥 Generate Videos | Step | Function | |----------------|-----------------------------------------------------------| | Generate Video | Calls RunwayML to generate video clips from the prompts | | Wait | 2-minute delay to allow video generation | | Get Videos | Fetches completed video clips | 🔊 Generate Audio | Step | Function | |------------------|----------------------------------------------------------| | Update Status | Logs progress in Google Sheet | | Sound Agent | Gemini or GPT generates narration text | | Set Audio | Formats narration for voice synthesis | | Generate Audio | Uses ElevenLabs for realistic voiceover | | Upload to Drive | Saves final audio to Google Drive | | Share File | Creates sharable URL for audio file | 🛠️ 3. Render & Upload > Purpose: Combines all elements (image, video, audio) into a single output and prepares for social media. | Step | Function | |-----------------|----------------------------------------------------------------| | Merge | Combines images, videos, and audio | | Split Out Parts | Breaks content for rendering | | Render Video | Uses CreateMate to render the final 20-second video | | Wait | Short delay to complete rendering | | Download Video | Saves output video locally or on Drive | | Update Sheet | Logs final video URL/status in Google Sheet | | Social Upload | (Coming Soon) Post to Instagram, YouTube Shorts, TikTok, etc. | 🧩 Pre-Conditions Before running the workflow: ✅ Google Sheet should be created with destination ideas ✅ All API keys must be configured in n8n ✅ Google Drive folder must exist for output videos ✅ Sufficient credit/quota must be available on AI platforms ✅ Internet access must be stable for external API calls 🚀 Outcome A polished 20-second travel destination video Combines AI visuals, short clips, and AI narration Ready for instant social media upload Fully automated** from idea to video file 🧠 Tech Stack Summary | Component | Tools Used | |-----------------|-------------------------------| | Language Model | GPT-4o (OpenAI), Gemini (Google) | | Image Generator | Piapia API | | Video Generator | RunwayML | | Audio Generator | ElevenLabs | | Storage | Google Drive | | Video Composer | CreateMate API | | Orchestration | n8n | 📈 Future Enhancements ✅ Smart Enhancements Dynamic hashtags & captions via AI Auto-post to TikTok, Instagram, YouTube via Buffer/Zapier Scene detection + matching B-roll Multilingual narration (e.g., Arabic, French, Malay) A/B testing of video versions to analyze performance 🧪 Testing Add-ons Add preview screen before upload Error tracking & retry flow Manual override before publishing 🧰 Customization Guide | Element | How to Customize | |----------------------|-------------------------------------------------------------------| | ✏️ Prompt Format | Change structure inside Set Content or Prompt Agent | | 🌍 Destination Ideas | Modify Google Sheet for different destinations/categories | | 🎨 Image Style | Customize prompt to Piapia (e.g., “in Pixar style”, “3D render”) | | 🎙️ Voiceover Script | Adjust tone/structure in the Sound Agent | | 📆 Posting Schedule | Use Zapier/Buffer for timed posting | | 🎯 Target Duration | Adjust number of clips or frame duration | 🙌 Community Value This workflow is ideal for: 📸 Travel content creators 🌍 Destination marketers 🏛️ Tourism boards 🧳 Travel SMEs looking for automation Feel free to fork, remix, or request a JSON export in the comments below!
by Amjid Ali
Overview This workflow template automates lead management and customer inquiry processing by integrating ERPNext, AI agents, and email notifications. It streamlines the process of capturing leads, analyzing inquiries, and generating actionable responses. The workflow uses ERPNext to capture inquiries, analyzes them with AI, and notifies the appropriate team or individual, all while maintaining a professional approach. What This Template Does ERPNext Webhook Integration: Captures leads and inquiries through ERPNext webhooks. Triggers the workflow when a new lead is created. AI-Powered Inquiry Analysis: Uses AI to extract key details from lead notes (e.g., customer name, organization, inquiry summary). Classifies inquiries as valid or invalid based on relevance to products, services, or solutions. Contact Assignment: Matches inquiries to the appropriate contact(s) using a Google Sheets database or ERPNext contact information. Handles multiple contacts if required. Email Notifications: Generates professional email notifications for valid inquiries. Sends emails to the appropriate contact(s) with inquiry details and action steps. Invalid Lead Handling: Identifies invalid inquiries (e.g., unrelated to products or services) and flags them for follow-up or dismissal. Custom Email Formatting: Converts plain text into professionally formatted HTML emails. Ensures that communication is clear, concise, and visually appealing. How It Works Step 1: Capture Lead Data Webhook in ERPNext:** Create a webhook in ERPNext for the "Lead" DocType. Set the trigger to on_insert to capture new leads in real-time. Lead Details:** The workflow fetches lead details, including notes, contact information, and the source of the lead. Step 2: Validate and Analyze Inquiry AI Agent for Analysis:** An AI agent analyzes the lead notes to extract key details and classify the inquiry as valid or invalid. The analysis includes checking the relevance of the inquiry to products, services, or solutions offered by the company. Invalid Leads:** If the inquiry is invalid, the workflow flags it and stops further processing. Step 3: Assign Contact(s) Google Sheets Integration:** Uses a Google Sheets database to map products, services, or solutions to responsible contacts. Ensures that inquiries are directed to the right person or team. Multiple Contacts:** Handles cases where multiple contacts are responsible for a particular product or service. Step 4: Generate and Send Email Notifications AI-Generated Emails:** The workflow generates a professional email summarizing the inquiry. Emails include details like customer name, organization, inquiry summary, and action steps. Custom HTML Formatting:** Emails are converted to HTML for a polished and professional appearance. Send Notifications:** Sends email notifications through Microsoft Outlook or another configured email client. Optionally, notifies via WhatsApp or SMS for urgent inquiries. Step 5: Post-Inquiry Actions ERPNext Record Updates:** Updates the lead record in ERPNext with relevant details, including inquiry status and contact information. Setup Instructions Prerequisites ERPNext: A configured ERPNext instance with lead data and a webhook for the "Lead" DocType. Google Sheets: A sheet mapping products, services, or solutions to responsible contacts. AI Integration: Credentials for OpenAI or other supported AI platforms. Email Client: Credentials for Microsoft Outlook or another email client. Step-by-Step Setup ERPNext Configuration: Create a webhook for the "Lead" DocType in ERPNext. Test the webhook with sample data to ensure proper integration. Workflow Import: Import the workflow template into n8n. Configure nodes with your API credentials for ERPNext, Google Sheets, and AI tools. Google Sheets Integration: Prepare a Google Sheet with columns for product, service, or solution and the responsible contact(s). Link the sheet to the workflow. AI Agent Configuration: Customize the AI agent’s prompts to align with your business’s products and services. Adjust criteria for valid and invalid inquiries as needed. Email Setup: Configure the email client node with your email service credentials. Customize the email template for your organization. Testing: Run the workflow with sample leads to validate the entire process. Check email notifications, contact assignments, and record updates in ERPNext. Dos and Don’ts Dos: Test Thoroughly:** Test the workflow with various scenarios before deploying in production. Secure Credentials:** Keep API and email credentials secure to avoid unauthorized access. Customize Prompts:** Tailor AI prompts to match your business needs and language style. Use Professional Email Templates:** Ensure emails are clear and well-formatted. Don’ts: Skip Validation:** Always validate inquiry data to avoid sending irrelevant notifications. Overload the Workflow:** Avoid adding unnecessary nodes that can slow down processing. Ignore Errors:** Monitor logs and address errors promptly for a smooth workflow. Resources GET n8n Now N8N COURSE n8n Book YouTube Tutorial:** Watch the full step-by-step tutorial on setting up this workflow: SyncBricks YouTube Channel Courses and Training:** Learn more about ERPNext and AI automation through my comprehensive courses: SyncBricks LMS Support and Contact:** Email: amjid@amjidali.com Website: SyncBricks LinkedIn: Amjid Ali
by Jimleuk
This n8n template builds a meeting assistant that compiles timely reminders of upcoming meetings filled with email history and recent LinkedIn activity of other people on the invite. This is then discreetly sent via WhatsApp ensuring the user is always prepared, informed and ready to impress! How it works A scheduled trigger fires hourly to check for upcoming personal meetings. When found, the invite is analysed by an AI agent to pull email and LinkedIn details of the other invitees. 2 subworkflows are then triggered for each invitee to (1) search for last email correspondence with them and (2) scrape their LinkedIn profile + recent activity for social updates. Using both available sources, another AI agent is used to summarise this information and generate a short meeting prep message for the user. The notification is finally sent to the user's WhatsApp, allowing them ample time to review. How to use There are a lot of moving parts in this template so in it's current form, it's best to use this for personal rather than team calendars. The LinkedIn scraping method used in this workflow requires you to paste in your LinkedIn cookies from your browser which essentially let's n8n impersonate you. You can retrieve this from dev console or ask someone technical for help! Note: It may be wise to switch to other LinkedIn scraping approaches which do not impersonate your own account for production. Requirements OpenAI for LLM Gmail for Email Google Calendar for upcoming events WhatsApp Business account for notifications Customising this workflow Try adding information sources which are relevant to you and your invitees. Such as company search, other social media sites etc. Create an on-demand version which doesn't rely on the scheduled trigger. Sometimes you want to know prepare for meetings hours or days in advance where this could help immensely.
by n8n Team
This workflow let's a bot in Slack notify a specific channel when a new product in WooCommerce is published and live on the site. Prerequisites WooCommerce account Slack and a Slack bot How it works Listen for WooCommerce product creation If permalink starts with https://[your-url-here].com/product/ Slack bot notifies channel that a new product has been added. Please note, you must update the URL in the IF node to match your url. If your WooCommerce doesn't use the slug /product/, that will need to be updated too.