Qualify new leads in Google Sheets via OpenAI's GPT-4
This n8n workflow was developed to evaluate and categorize incoming leads based on certain criteria. The workflow is triggered by adding a new row in a Google Sheets document. The workflow uses the OpenAI node to process the lead information. The system query contains detailed qualification rules and the response format. The user message contains the data for the individual lead. The JSON response from the OpenAI node is then processed by the Edit Fields node to extract the response. This response is merged together with the original lead data by the Merge node. Finally, the Google Sheets node updates the original lead entry in the Google Sheets document with the qualification result ("qualified" or "not qualified") in a separate column. This allows for easy tracking and sorting of the qualified leads.
By YuliaGenerate personalized sales emails with LinkedIn data & Claude 3.7 via OpenRouter
How it works The automation loads rows from a Google Sheet of leads that you want to contact. It makes a Google search via Apify for LinkedIn links based on the First name / Last name / Company. Another Apify actor fetches the right LinkedIn profile based on the first profile which is retuned The same process is done for the company that the lead works for, giving extra context. If the lead has a current company listed on their LinkedIn, we use that URL to do the lookup, rather than doing a separate Google search. A call is made to OpenRouter to get an LLM to generate an email based on a prompt designed to do personalized outreach. An email is sent via a Gmail node. Set up steps Connect your Google Sheets + Gmail accounts to use these APIs. Make an account with Apify and enter your credentials. Set your details in the "Set My Data" node to customize the workflow to revolve around your company + value proposition. I would recommend changing the prompt in the "Generate Personalized Email" node to match the tone of voice that you want your agent to have. You can change the guidelines to e.g. change whether the agent introduces itself, and give more examples in the style you want to make the output better.
By Adam JanesPersonal shopper chatbot for WooCommerce with RAG using Google Drive and openAI
This workflow combines OpenAI, Retrieval-Augmented Generation (RAG), and WooCommerce to create an intelligent personal shopping assistant. It handles two scenarios: Product Search: Extracts user intent (keywords, price ranges, SKUs) and fetches matching products from WooCommerce. General Inquiries: Answers store-related questions (e.g., opening hours, policies) using RAG and documents stored in Google Drive. --- How It Works Chat Interaction & Intent Detection Chat Trigger: Starts when a user sends a message ("When chat message received"). Information Extractor: Uses OpenAI to analyze the message and determine if the user is searching for a product or asking a general question. Extracts: search (true/false). keyword, priceRange, SKU, category (if product-related). Example: json { "search": true, "keyword": "red handbags", "priceRange": { "min": 50, "max": 100 }, "SKU": "BAG123", "category": "women's accessories" } Product Search (WooCommerce Integration) AI Agent: If search: true, routes the request to the personal_shopper tool. WooCommerce Node: Queries the WooCommerce store using extracted parameters (keyword, priceRange, SKU). Filters products in stock (stockStatus: "instock"). Returns matching products (e.g., "red handbags under €100"). General Inquiries (RAG System) RAG Tool: If search: false, uses the Qdrant Vector Store to retrieve store information from documents. Google Drive Integration: Documents (e.g., store policies, FAQs) are stored in Google Drive. Downloaded, split into chunks, and embedded into Qdrant for semantic search. OpenAI Chat Model: Generates answers based on retrieved documents (e.g., "Our store opens at 9 AM"). Set Up Steps Configure the RAG System Google Drive Setup: Upload store documents . Update the Google Drive2 node with your folder ID. Qdrant Vector Database: Clean the collection (update Qdrant Vector Store node with your URL). Use Embeddings OpenAI to convert documents into vectors. Configure OpenAI & WooCommerce OpenAI Credentials: Add your API key to all OpenAI nodes (OpenAI Chat Model, Embeddings OpenAI, etc.). WooCommerce Integration: Connect your WooCommerce store (credentials in the personal_shopper node). Ensure product data is synced and accessible. Customize the AI Agent Intent Detection: Modify the Information Extractor’s system prompt to align with your store’s terminology. RAG Responses: Update the tool description to reflect your store’s documents. --- Notes This template is ideal for e-commerce businesses needing a hybrid assistant for product discovery and customer support. Need help customizing? Contact me for consulting and support or add me on Linkedin.
By DavideSuspicious login detection
This n8n workflow is designed for security monitoring and incident response when suspicious login events are detected. It can be initiated either manually from within the n8n UI for testing or automatically triggered by a webhook when a new login event occurs. The workflow first extracts relevant data from the incoming webhook payload, including the IP address, user agent, timestamp, URL, and user ID. It then splits into three parallel processing paths. In the first path, it queries GreyNoise's Community API to retrieve information about the investigated IP address. Depending on the classification and trust level received from GreyNoise, the alert is given a High, Medium, or Low priority. This priority is assigned based on the best practices documentation from GreyNoise on how to apply their data to analysis. Once a priority is assigned, a message is sent to a Slack channel to notify users about the alert. The second path involves fetching geolocation data about the IP address using IP-API's Geolocation API and merging it with data from the UserParser node. This data is then combined with the data obtained from GreyNoise. In the third path, the UserParser node queries the Userparser IP address and user agent lookup API to obtain information about the user's IP and user agent. This data is merged with the IP-API data and GreyNoise data. The workflow then checks if the IP address is considered an unknown threat by examining both the noise and riot fields from GreyNoise. If it is considered an unknown threat, the workflow proceeds to retrieve the last 10 login records for the same user from a Postgres database. If there are any discrepancies in the login information, indicating a new location or device/browser, the user is informed via email. Potential issues when setting up this workflow include ensuring that credentials are correctly entered for GreyNoise and UserParser nodes, and addressing any discrepancies in the data sources that could lead to false positives or negatives in threat detection. Additionally, the usage of hardcoded API keys should be replaced with credentials for security and flexibility. Thorough testing and validation with sample data are crucial to ensure the workflow performs as expected and aligns with security incident response procedures.
By n8n TeamAmazon affiliate marketing automation
Who this is for This workflow is for Amazon affiliate marketers and social media managers who want to quickly turn product links into engaging Facebook posts with AI-generated captions and images — fully automated. --- What this workflow does This workflow starts every time a new Product Link is added to a connected Google Sheet. It then: Extracts the ASIN from the product link. Fetches product details from Amazon using RapidAPI. Generates a short, scroll-stopping Facebook caption with OpenRouter AI. Creates a product image prompt and sends it to Google Gemini for high-quality image generation. Uploads the creative directly to Facebook via the Facebook Graph API. Marks the Google Sheet row as “Done ✅” after posting. The Facebook post includes: Product image (AI-enhanced) Short, benefit-focused caption with emojis Affiliate link --- Setup To set this template up, follow the sticky notes inside the workflow and: Google Sheets → Connect your sheet and ensure the columns “Product Link” & “Facebook Upload” exist. RapidAPI → Add your API key in the “Amazon Product Details” node. OpenRouter → Add credentials for caption generation. Google Gemini → Add your API key for image generation. Facebook Graph API → Connect your Facebook account for posting. --- How to customize this workflow to your needs Change the Facebook caption prompt to match your tone or branding. Adjust the AI image generation prompt to fit your preferred photography style. Modify the Google Sheet update logic if you want to track additional info (e.g., posting date, engagement stats). Switch Facebook posting to Instagram or another platform by replacing the final API call.
By Rakin JakariaVoice-to-email response system with Telegram, OpenAI Whisper & Gmail
This workflow gives you the ability to reply to a long email with a voice note, rather than having to type everything out. ChatGPT will format your audio response and create an email draft for you. How it works When a new email arrives in your inbox, the workflow checks if it needs a response, and it it does, it sends a message to you on Telegram via a VoiceEmailer bot. When you reply to that message with an audio message, the second part of this workflow is triggered. It checks if the message is in the right format, transcribes the audio, and creates a draft response that shows up in the same email thread. Set up steps Add your credentials for Gmail and OpenAI Create an Telegram bot following the instructions here. Connect your telegram credentials so the workflow will use your bot. Turn on the workflow, and message the bot from your telegram. Find the Chat ID from the Executions tab of your workflow, and enter it in as a variable.
By Adam JanesReceive messages from a queue via RabbitMQ and send an SMS
This workflow allows you to receive messages from a queue via RabbitMQ and send an SMS.
By Harshil AgrawalSend private welcome messages to new WhatsApp group members with Evolution API
Who's it for This template is perfect for community managers, business owners, and WhatsApp group administrators who want to create a welcoming experience for new members. Whether you're running a support group, managing a business community, or moderating a hobby group, this automation ensures every new member feels valued from the moment they join. How it works The workflow automatically detects when someone joins your WhatsApp group and sends them a personalized welcome message directly to their private chat. It uses Evolution API to interface with WhatsApp Business and includes a natural delay to make the interaction feel more human. The entire process is hands-off once configured, ensuring consistent engagement with new members 24/7. What it does Monitors group activity - Receives real-time notifications when members join or leave Filters for your specific group - Ensures messages are only sent for your designated group Validates new joins - Confirms the event is a member joining (not leaving) Adds natural timing - Waits a customizable period before sending the message Sends private welcome - Delivers your welcome message directly to the new member's chat Requirements Evolution API instance (self-hosted or cloud service) WhatsApp Business account connected to Evolution API Group admin permissions for the WhatsApp group n8n instance (self-hosted or cloud) How to set up Import the workflow into your n8n instance Configure the Set Variables node with: Your WhatsApp group ID (format: xxxxxxxxxxxxx@g.us) Evolution API key Instance name from Evolution API Evolution API URL Custom welcome message Delay time in minutes Copy the webhook URL from the Webhook node Configure Evolution API to send group notifications to your webhook URL Test the workflow by having someone join your group Activate the workflow for continuous operation For a detailed video tutorial on setting up this workflow, check out: https://youtu.be/WO2MJoQqLvo How to customize the workflow Welcome message: Edit the message in the Set Variables node to match your group's tone Timing: Adjust the wait time to send messages immediately or after several minutes Multiple groups: Duplicate the workflow and change the group ID for each group Rich media: Extend the HTTP Request node to send images or documents with the welcome Conditional messages: Add IF nodes to send different messages based on time of day or member count Follow-up sequence: Chain additional HTTP Request nodes to create a welcome series
By Anderson AdelinoPersonalized AI assistant with voice support, email/calendar & web tools integration
✨ Intro This workflow shows how to go beyond a “plain” AI chatbot by: 🧠 Adding a Personality Layer — Link an extra LLM to inject a custom tone and style. Here, it’s Nova, a sassy, high-fashion assistant. You can swap in any personality without changing the main logic. 🎨 Custom Styling with CSS — Easily restyle the chatbot to match your brand or project theme. Together, these make your bot smart, stylish, and uniquely yours. ⚙️ How it Works 📥 Route Input Chat trigger sends messages to a Switch. If a Telegram video note exists → runs the audio path. Otherwise → runs the text path. 🎤 Audio Path Telegram Get a File → OpenAI Speech-to-Text → pass transcript to the agent. 💬 Text Path Chat text is normalized and sent to the agent. 🛠 Agent Brain Uses tools like Gmail 📧, Google Calendar 📅, Google Drive 📂, Airtable 📋, SerpAPI 🌐, Wikipedia 📚, Hacker News 📰, and Calculator ➗. 🧾 Memory Keeps the last 20 messages for context-aware replies. 💅 Optional Personality Polish An LLM Chain adds witty or cheeky tone on top of the agent’s response. 🛠 Setup Steps ⏱ Time Required ~10–15 minutes (+5 minutes for each Google/Airtable connection). 🔑 Connect Credentials OpenAI (and/or Anthropic) Telegram Bot Gmail, Google Calendar, Google Drive Airtable SerpAPI 📌 Configure IDs Set Airtable base/table. Set Calendar email. Adjust Drive search query defaults if needed. 🎙 Voice Optional Disable Telegram + Transcribe nodes if you only want text chat. 🎭 Choose Tone Edit Chat Trigger’s welcome text/CSS for custom look. Or disable persona chain for neutral voice. 🚀 Publish Activate workflow and share the chat URL. 💡 Detailed behavior notes are available as sticky notes inside the workflow.
By Carl FungCreate & track LinkedIn posts with Google Sheets, GPT-5.1, Unsplash, and Sona
Automate LinkedIn content creation by managing ideas in Google Sheets, generating professional AI-written posts, intelligently selecting relevant Unsplash images, sending drafts for email approval, and publishing directly to LinkedIn. How it works Step 1: Scheduled Sheet Check Workflow runs daily at midnight (customizable to hourly/weekly) Fetches posts from Google Sheet marked with Status = "Ready" Processes one post per run, updates status to "In Progress" Step 2: AI Content Generation GPT-5.1 creates engaging LinkedIn post based on your inputs Generates content with proper hashtags, formatting, and tone Follows your specified content type (tip, story, announcement, etc.) Step 3: Quality Validation Automatically checks character limits (3000 max) Validates minimum hashtag requirements (3+) Loops back to regenerate if quality checks fail Step 4: Email Approval Workflow Formats post as HTML email with professional styling Sends preview to your Gmail for review Waits for your approval response before proceeding Nothing posts without explicit confirmation Step 5: Smart Image Handling If you provided image URL: Downloads from Google Drive, Dropbox, or direct links If no URL is provided: Fetch 10 images from Unsplash and use AI to select the best one. If "Include Image?" is "No": Posts text-only content Automatically converts share links to downloadable formats Step 6: LinkedIn Publishing & Tracking Posts approved content directly to your LinkedIn profile Uses appropriate API endpoint based on whether image is included Updates Google Sheet status to "Posted" for successful posts Marks "Rejected" posts in sheet for review and editing What you'll get Batch content planning: Queue multiple posts in advance via Google Sheets Consistent posting schedule: Automated daily publishing without manual work Professional AI content: GPT-5.1 generates engaging, platform-optimized posts Full approval control: Review every post before it goes live Flexible image options: Your images, AI-generated, or text-only Quality assurance: Built-in checks prevent poorly formatted posts Status tracking: Monitor what's ready, in progress, rejected, or posted Smart link conversion: Automatically handles Google Drive and Dropbox share links Requirements Accounts & credentials: OpenAI API key (requires paid plan for GPT-5.1) Gmail account (for approval workflow) Google account (for Sheets integration) LinkedIn account (for publishing) Unsplash API key (for getting images) Google Sheet setup: Create a sheet with these columns: Topic/Subject (required) - Main idea for the post Content Type (required) - e.g., "Tip", "Story", "Announcement" Tone (required) - e.g., "Professional", "Casual", "Inspirational" Target Audience (optional) - Who you're writing for Additional Notes (optional) - Specific points to include Image link for your post (optional) - URL to your image Include Image? (required) - "Yes" or "No" Status (required) - "Ready" to trigger workflow Setup steps Import workflow - Click "Use workflow" to add to your n8n instance Connect credentials: Google Sheets: Authenticate and select your sheet from dropdown OpenAI: Add your API key in both AI nodes Gmail: Authenticate and update recipient email in approval node LinkedIn: Authenticate (your profile auto-populates) Create your content sheet - Add the required columns and fill with post ideas Test the workflow: Add one test row with Status = "Ready" Run workflow manually Check email for approval Verify post appears on LinkedIn Configure schedule - Default is daily at midnight; adjust Schedule Trigger node for different frequency Start batching - Add multiple ideas to your sheet and let automation handle the rest Tips for best results Be specific in Topic/Subject: "5 ways to improve team productivity" beats "productivity tips" Mix content types and tones to keep your feed engaging Use Additional Notes for data points, statistics, or specific examples. You can also include links that the AI can use for the posts. Start with text-only posts to validate content quality before adding images Review rejected posts carefully and refine your inputs Batch 10-20 ideas at once for weeks of automated content
By Sona LabsAI client onboarding agent: Auto welcome email generator
AI Client Onboarding Agent: Auto Welcome Email Generator This workflow automates welcoming new clients. When someone submits a form, their details are pulled from Google Sheets, a personalized onboarding checklist is generated using Google Gemini, and an email is sent directly to the client. It also includes error handling to ensure nothing is missed. --- 🟢 Section 1 – Trigger & Client Data Capture Nodes: ⏰ Trigger on New Client Form Submission → Fires when a new row is added in Google Sheets (from the client’s form). 🧍 Extract and Structure Client Data → Collects and formats client details: name, email, company, services, extra info. ✅ Beginner view: This is the doorway. When a client fills the form, their info is automatically pulled into the workflow. --- 📑 Section 2 – Checklist & Personalization Nodes: 📋 Client Checklist → Creates a default onboarding checklist (account setup, welcome call, docs, etc.). 🧠 Personalize Using Gemini → Sends client details + checklist to Google Gemini AI → generates a tailored onboarding email body. ✅ Beginner view: This is where the magic happens. Instead of a boring generic email, each client gets a customized message that feels personal. --- 📤 Section 3 – Delivery & Completion Nodes: 📧 Send Email to Client → Sends the personalized onboarding email directly to the client’s inbox. ✅ Execution Completed → Marks the workflow as successfully finished. ✅ Beginner view: Think of this as the final handshake with the client — they get a warm, professional onboarding email without you lifting a finger. --- 🚨 Section 4 – Error Handling Nodes: ⚠️ Error Handler → Captures any failure in the workflow. ❌ Execution Failure → Defines fallback/alert action if something breaks. ✅ Beginner view: This is your safety net. If an email fails or Gemini is unavailable, the workflow won’t just stop — you can set it up to alert you. --- 📊 Summary Table | Section | Key Nodes | Purpose | Beginner Benefit | | ----------------- | ----------------------------------- | -------------------------------------- | ------------------------------ | | 🟢 Trigger & Data | Google Sheets Trigger, Data Extract | Capture client info | Auto-collects form submissions | | 📑 Checklist & AI | Checklist, Gemini | Generate personalized onboarding email | Each client feels special | | 📤 Delivery | Gmail, Execution Completed | Send email & close flow | Client gets email instantly | | 🚨 Error Handling | Error Trigger, Failure Node | Catch issues | Ensures nothing is missed | --- 🌟 Why This Workflow Rocks Saves hours → no manual onboarding emails Personalized at scale → Gemini tailors messages per client Error-proof → built-in error handling keeps you safe Scalable → works for 10 or 10,000 clients --- 👉 Example Flow in Action: A client named Sarah fills the onboarding form. Workflow captures her details → “Sarah, MarketingPro Agency, Needs Analytics Setup.” Gemini creates a custom email: > Hi Sarah, welcome aboard! Here’s your onboarding plan tailored for Analytics Setup… Gmail sends it instantly. You get notified only if something fails. ---
By Yaron BeenAutomatically transcribe Telegram voice messages with OpenAI Whisper & Google Workspace
🎙️ VoiceScribe AI: Telegram Audio Message Auto Transcription with OpenAI Whisper > Automatically transcribe Telegram voice messages and store them as structured logs in Google Sheets, while backing up the audio in Google Drive. 🧑💼 Who’s it for Journalists, content creators, or busy professionals who often record voice memos or short interviews on the go. Anyone who wants to turn voice recordings into searchable, structured notes. ⚙️ How it works / What it does User sends a voice message to a Telegram bot. n8n checks if the message is an audio voice note. If valid, it downloads the audio file and: Transcribes it using OpenAI Whisper (or your LLM of choice). Uploads the original audio to Google Drive for safekeeping. The transcript and audio metadata are merged. The workflow: Logs the data into a Google Sheet. Sends a formatted confirmation message to the user via Telegram. If the input is not audio, the bot politely informs the user that only voice messages are accepted. ✅ Features Accepts only Telegram voice messages. Transcribes via OpenAI Whisper. Logs DateTime, Duration, Transcript, and Audio URL to Google Sheets. Sends user feedback message via Telegram with download + transcript link. 🚀 How to set up Prerequisites Telegram Bot connected to n8n (via Telegram Trigger) Google Drive & Google Sheets credentials configured OpenAI or Whisper API credentials (for transcription) Steps Telegram Trigger Start the flow when a new message is sent to your bot. Check Message Type Use a conditional node to confirm it's a voice message. Download Voice Message Download the .oga file from Telegram. Transcribe Audio Send the binary audio to OpenAI Whisper or your transcription service. Upload to Google Drive Backup the original audio file. Merge Outputs Combine transcription with Drive metadata. Transform to Row Format Prepare structured JSON for Google Sheets. Append to Google Sheet Store the transcript log (DateTime, Duration, Transcript, AudioURL). Send Confirmation to User Inform the user via Telegram with their transcript and download link. Unsupported Message Handler Reply to users who send non-audio messages. 📄 Example Output in Google Sheet | DateTime | Duration | Transcript | AudioURL | |-----------------------|----------|--------------------------------------------|------------------------------------------------------------| | 2025-08-07T13:12:19Z | 27 | Dự án Outlet Activation là... | https://drive.google.com/uc?id=xxxx&export=download | 🧠 How to customize the workflow Swap Whisper with Deepgram, AssemblyAI, or other providers. Add speaker name detection or prompt-based tagging via GPT. Route transcripts into Notion, Airtable, or CRM systems. Add multi-language support or summarization steps. 📦 Requirements | Component | Required | |---------------------|----------| | Telegram API | ✅ | | Google Drive API | ✅ | | Google Sheets API | ✅ | | OpenAI Whisper API | ✅ | | n8n Cloud or Self-hosted | ✅ | Created with ❤️ using n8n
By Trung Tran