Invoke an AWS Lambda function
Companion workflow for AWS Lambda docs
Send structured logs to BetterStack from any workflow using HTTP request
Send structured logs to BetterStack from any workflow using HTTP Request Who is this for? This workflow is perfect for automation builders, developers, and DevOps teams using n8n who want to send structured log messages to BetterStack Logs. Whether you're monitoring mission-critical workflows or simply want centralized visibility into process execution, this reusable log template makes integration easy. What problem is this workflow solving? Logging failures or events across multiple workflows typically requires duplicated logic. This workflow solves that by acting as a shared log sender, letting you forward consistent log entries from any other workflow using the Execute Workflow node. What this workflow does Accepts level (e.g., "info", "warn", "error") and message fields via Execute Workflow Trigger Sends the structured log to your BetterStack ingestion endpoint via HTTP Request Uses HTTP Header Auth for secure delivery Includes a manual trigger for testing and a sample call to demonstrate usage Comes with clear sticky notes to help you get started Setup Copy your BetterStack Logs ingestion URL. Create a Header Auth credential in n8n with your Authorization: Bearer YOURAPIKEY. Replace the URL in the HTTP Request node with your BetterStack endpoint. Optionally modify the test data or log levels for custom scenarios. Use Execute Workflow in any of your workflows to send logs here.
Automated product ad image creation with OpenAI, Gemini & Google Workspace
How it works This workflow automates the generation of ad-ready product images by combining product and influencer photos with AI styling. It runs on a scheduled trigger, fetches data from Google Sheets, and retrieves product and influencer images from Google Drive. The images are processed with OpenAI and OpenRouter to generate enhanced visuals, which are then saved back to Google Drive. Finally, the result is logged into Google Sheets with a ready-to-publish status. Step-by-step Trigger & Data preparation Schedule Trigger – Runs workflow automatically on a set schedule. Google Sheets (Get the Raw) – Retrieves today’s product and model URLs. Google Drive (Download Product Image) – Downloads the product image. Google Drive (Download Influencer Image) – Downloads the influencer image. Extract from File (Binary → Base64) – Converts both product and model images for AI processing. AI analysis & image generation OpenAI (Analyze Image) – Creates an ad-focused visual description (lighting, mood, styling). HTTP Request (OpenRouter Gemini) – Generates an AI-enhanced image combining product + influencer. Code Node (Cleanup) – Cleans base64 output to remove extra prefixes. Convert to File – Transforms AI output into a proper image file. Save & update Google Drive (Upload Image) – Uploads generated ad image to target folder. Google Sheets (Append/Update Row) – Stores the Drive link and updates publish status. Why use this? Automates the entire ad image creation process without manual design work. Ensures product visuals are consistent, styled, and ad-ready. Saves final creatives in Google Drive for easy access and sharing. Keeps campaign tracking organized by updating Google Sheets automatically. Scales daily ad production efficiently for multiple products or campaigns.
Jira ticket creation from Google Forms with sheet updates and email notifications
Description Automated workflow that creates Jira issues directly from Google Forms. The flow validates and normalizes the data, creates the Jira issue, writes the key back to the Google Sheet, and sends a Gmail notification. Context This template bridges lightweight Google Forms with enterprise Jira. It enables instant ticket creation while keeping Jira the single source of truth. The flow is idempotent (no duplicates) and production-friendly, with clean field normalization and safe mappings. Target Users Product / Ops teams running request portals on Google Forms Engineering managers who need quick Jira integration without custom UI Project managers who track intake in Google Sheets but want Jira as the system of record Orgs that want controlled ticket creation without exposing Jira directly Technical Requirements Jira Cloud project + API email + API token + “Create issues” permission Google Form + response Sheet Gmail credential for notifications Workflow Steps Trigger when a row is added Normalize Fields – Trim/clean text Create Jira Issue – POST to Jira REST; safe mappings Update Google Sheet – Match by Horodateur or rowNumber; write jirakey, issueurl, status, updated_at. Send Gmail – HTML email with key, title, link, priority, requester. Key Features Real-time (no polling): Forms → trigger→ n8n Idempotent updates using the Form timestamp (“Horodateur”) Clean normalization: summary/description/labels all standardized once Safe Jira mappings: priority via ID Notification: branded HTML email with all key fields Expected Output Google Form to create the issue Sheet updated with jirakey, issueurl, status, updated_at A valid Jira issue in the configured project Email sent to stakeholders / requester How it works ⏰ Trigger – As soon as a row is added, the workflow is triggered 🧱 Normalize – Clean summary/description/labels; pick reporter_email 🧾 Create – POST to /rest/api/3/issue, capture { id, key, self } 📗 Update – Write jirakey, issueurl, status, updated_at back to the Sheet ✉️ Notify – Send Gmail HTML confirmation to stakeholders/requester Tutorial video: Watch the Youtube Tutorial video About me : I'm Yassin, IT Project Manager, Agile & Data specialist. Scaling tech products with data-driven project management. 📬 Feel free to connect with me on Linkedin
Build a WhatsApp customer support bot with LangChain, OpenAI, and CRM integration
Full Customer Support WhatsApp AI Bot (Self-Hosted, Evolution API) 🧑💼 Who’s it for This template is for businesses using WhatsApp for customer communication who want to automate support using AI and real-time CRM data — especially in retail, food & beverage, e-commerce, or service sectors. It’s ideal for self-hosted n8n users with access to OpenAI and a CRM with API endpoints. --- 💡 What It Does This workflow creates a multi-intent AI chatbot that handles WhatsApp conversations and connects to your CRM using HTTP APIs. It uses LangChain’s AI Agent to dynamically classify and respond to customer queries in real time. 🔄 Supported Use Cases: 📍 Branch inquiries (nearest location, hours, contact) 🍰 Menu & product info (availability, categories, images) 🛒 Order creation & tracking ⚠️ Complaint submission and follow-up ⭐ Loyalty points lookup ✨ Concierge & custom orders Each user message is routed using AI to the appropriate path, where a tailored system prompt and real-time API call generate a smart, emoji-rich reply. --- 🚀 Key Advantages Plug-and-play AI support bot with 6 distinct customer intents No code logic building — uses natural language instructions via LangChain Connects to your CRM using httpRequestTool nodes Smart classification with OpenAI (via LangChain agent) Sticky notes and prompt modularity for easy customization Real-time replies using dynamic data from your API Short, branded, emoji-friendly replies with support for Arabic NLP patterns --- 🔧 How It Works 🧲 A Webhook (via evolution-api node) receives incoming WhatsApp messages. 🧠 An AI Router Agent classifies the message intent using GPT-4. 🧰 Based on the intent, a specific system prompt is injected. 🧠 A LangChain Agent uses tools (CRM APIs) to fetch data. 💬 A final reply is generated and sent back via WhatsApp. Everything is modular, explainable, and built with clarity in mind using sticky notes and renamed nodes. --- 🛠️ Requirements ✅ Self-hosted n8n (required for community nodes) ✅ evolution-api node (for WhatsApp messaging) ✅ OpenAI API Key ✅ Your own CRM HTTP API endpoints for: Order creation/status Menu & category lookup Complaints Branch search Loyalty points --- ⚙️ Setup Instructions 🔌 Install the evolution-api node via n8n community nodes. 🔐 Replace all YOURAUTHORIZATIONTOKEN_HERE with your real credentials. 🧠 Add your OpenAI credentials in n8n. 🛠️ Update all CRM URLs to point to your environment. 📲 Connect the webhook URL to your WhatsApp provider. --- 🎨 How to Customize Edit the intent categories in the AI router prompt. Modify each system prompt for tone, brand, or language (supports Arabic). Add more tools or branches (e.g., shipping, feedback, upselling). Use n8n’s credentials manager for production security. --- 🧠 User Experience & Design Sticky notes provide full visual explanation of logic. Prompts ensure short, relevant, context-aware replies. User session memory improves continuity across messages. Optimized for performance and ease of onboarding. --- 🔍 SEO Tags whatsapp support bot, n8n chatbot, gpt-4 ai support, langchain agent, self-hosted n8n, crm integration, customer support automation, evolution-api, loyalty bot, menu chatbot, orders automation, arabic whatsapp bot, real-time crm bot, openai n8n workflow
Email list validation and cleanup with Google Sheets and VerifiEmail
🧼 Email Subscription Cleaner A fully automated workflow that cleans, validates, and restructures your subscriber list using Google Sheets and VerifiEmail. Perfect for marketers, SaaS teams, or anyone maintaining an email database. --- 🚀 What This Workflow Does In one automated run, it: Accepts a cleaning request via Webhook Extracts list settings, preferences, and options Fetches all subscribers from Google Sheets Normalizes emails and formats subscriber fields Performs real-time verification using VerifiEmail Classifies each subscriber as: remove (invalid / disposable / role), keep (valid & safe), tag (special cases) Deletes bad emails directly from the source sheet Stores all valid emails in a clean, curated CleanSubscribers sheet Returns a structured JSON summary to the caller --- 🔍 Why This Template Is Useful Improves deliverability Removes spam traps, bots, disposable domains Cleans and reorganizes messy lists Reduces bounce rates Builds a healthier mailing list for campaigns No CSV download/upload required — runs directly on Google Sheets --- 🧠 How It Works (In Simple Steps) Webhook receives batch-clean request Extract Inputs parses settings (listId, priority, options) Fetch Subscribers reads rows from Google Sheets Normalize each subscriber’s fields Validate Email quality (MX check, disposable, provider data) Merge subscriber info + validation results Classify each subscriber into keep/remove/tag Clean Up: remove → deletes the row keep → appends to clean list Respond with a clean JSON summary Fast, simple, reliable — perfect for weekly or on-demand cleanup. --- 🔧 Setup Required Connect 2 credentials: Google Sheets (read / delete / append) VerifiEmail (API key) Update: Sheet name (SubscriberList) Clean list sheet (CleanSubscribers) Optional tag rules in “Classify Email” No other configuration needed. --- 🏁 Perfect For Newsletters Marketing teams Event lists SaaS mailing lists CRM cleanup Lead verification Removing dead/invalid emails automatically --- 🏷️ Tags email, cleanup, validation, google-sheets, verifiemail, marketing, automation, list-cleaner, webhook