by Rahul Joshi
Description: Keep your databases clean and reliable with this intelligent n8n workflow template! Effortlessly detect duplicate records, generate structured logs, and receive instant email updates—no manual review needed. This automation retrieves records from Google Sheets, runs a custom deduplication engine to detect duplicate entries (based on email and phone), saves detailed logs to Google Drive, and notifies your team via email. Perfect for businesses, analysts, and data teams who need to maintain clean datasets and ensure accuracy in customer or lead management systems. What This Template Does: 📊 Fetches data from Google Sheets for duplicate analysis 🧠 Identifies duplicate entries using email + phone logic 📂 Generates detailed duplication logs and saves them in Google Drive 📧 Sends automated email notifications to your team with process details 🌟 100% automated: just run the workflow and get instant results Built-in Logic Ensures: ✔️ Duplicate detection is accurate and structured ✔️ Logs are organized for easy access and auditing ✔️ Team members stay informed with timely notifications Requirements: Google Sheets containing your dataset Google Drive account for log storage SMTP/Gmail account for notifications n8n instance (self-hosted or cloud) Perfect For: Data teams maintaining large customer or lead databases Businesses ensuring accuracy in CRM records Analysts and operations teams wanting hands-free duplicate management
by moosa
This workflow tracks new Shopify orders in real-time and logs them to a Google Sheet, while also sending a structured order summary to a Discord channel. Perfect for keeping your team and records updated without checking your Shopify admin manually. ✅ Features: Trigger: Listens to orders/create event via the **Shopify Trigger node Authentication: Uses **Shopify Access Token, generated via a custom/private Shopify app Google Sheets Logging**: Automatically appends order details to a sheet with the following columns: Order Number Customer Email Customer Name City Country Order Total Currency Subtotal Tax Financial Status Payment Gateway Order Date Line Item Titles Line Item Prices Order Link Discord Alerts**: Sends a clean and formatted summary to your Discord server Line Item Extraction**: Breaks down item titles and prices into readable format using code Multi-currency Compatible**: Displays currency type dynamically (not hardcoded) 🧩 Nodes Used: Shopify Trigger (Access Token) Code — extract line_item_titles and line_item_prices Google Sheets — Append row Code (JavaScript) — Format Discord message Discord — Send message 📒 Sticky Notes: 🛠️ Use your own Google Sheet link and Discord webhook 🔄 You can duplicate and adapt this for orders/updated or refunds/create events 🔐 No hardcoded API keys — credentials managed via UI 🖼️ Sample Outputs 📄 Google Sheet Entry | Order Number | Customer Email | Customer Name | City | Country | Order Total | Currency | Subtotal | Tax | Financial Status | Payment Gateway | Order Date | Line Item Titles | Line Item Prices | Order Link | |--------------|------------------|----------------|-----------|----------|--------------|----------|----------|--------|-------------------|------------------|------------------------------|----------------------------------------------------------------------------------------------------|----------------------------------|------------| | 1003 | abc123@gmail.com | test name | test city | Pakistan | 2522.77 | PKR | 2174.8 | 347.97 | paid | bogus | 2025-07-31T13:45:35-04:00 | Selling Plans Ski Wax, The Complete Snowboard, The Complete Snowboard, The Collection Snowboard: Liquid | 24.95, 699.95, 699.95, 749.95 | View Order | 💬 Discord Message Preview > Tested with Shopify's "Bogus" gateway — works without real card info in a development store.
by Jitesh Dugar
Verified Corporate Training Certificate with CEUs – Fully Automated & Verifiable A production-ready, secure, and professional automation that instantly issues accredited CEU certificates the moment a training is completed. What it does Accepts form/webhook submissions (name, email, course, CEUs, hours, etc.) Validates all required fields and checks email deliverability (blocks disposable/temporary emails) Generates a unique Certificate ID + scannable QR code for lifelong verification Renders a beautiful, branded PDF certificate using HTML → PDF Automatically uploads the certificate to Google Drive Sends a polished, personalized email with the PDF attached Notifies your team in Slack Logs every issuance in Google Sheets (perfect for audits & accreditation) Returns instant success/failure response to the caller Key Features Real-time email validation via Verif.Email API Unique, tamper-proof Certificate ID (e.g., CERT-CEU-1739981234567-AB3XF9) Embedded QR code linking to public verification page High-resolution, print-ready PDF with custom branding Full audit trail in Google Sheets Slack notification for organizers Zero manual work – 100% automated Ideal for Corporate training departments Continuing Education (CEU) providers Professional certification bodies Compliance & accreditation teams Required Credentials (one-time setup) verifi.email API https://pdfmunk.com Google Drive + Gmail Google Sheets Slack (optional) Deploy in under 5 minutes and start issuing trusted, verifiable certificates instantly. Tags: certificate, CEU, training, verification, QR code, PDF, automation, compliance, education, corporate
by Oneclick AI Squad
This n8n workflow monitors pharmacy inventory stored in a Google Sheet, checks daily for low stock or near-expiry medicines, and sends alerts to the pharmacist via email, ensuring timely restocking and waste prevention. Why Use It This workflow automates inventory management for pharmacies, reducing the risk of stockouts or expired medicines, saving time, minimizing losses, and ensuring compliance with safety standards by providing proactive alerts. How to Import It Download the Workflow JSON: Obtain the workflow file from the n8n template or create it based on this document. Import into n8n: In your n8n instance, go to "Workflows," click the three dots, select "Import from File," and upload the JSON. Configure Credentials: Set up Google Sheets, email (e.g., SMTP), and optional SMS (e.g., Twilio) credentials in n8n. Run the Workflow: Activate the scheduled trigger and test with a sample Google Sheet. System Architecture Daily Stock Check (9 AM)**: Automated trigger to monitor inventory levels Fetch Stock Data**: Retrieves current medicine data from Google Sheets Wait For All Data**: Ensures complete data retrieval before processing Check Expiry Date and Low Stock**: Analyzes inventory for alerts Update Google Sheet**: Records alert status and timestamps Send Email Alert**: Notifies pharmacist of low stock and expiry issues Google Sheet File Structure Sheet Name**: PharmacyInventory Range**: A1:E20 (or adjust based on needs) | A | B | C | D | E | |------------|---------------|------------|---------------|---------------| | medicine_name | stock_quantity | expiry_date | alert_status | last_checked | | Paracetamol | 15 | 2025-09-15 | Notified | 2025-08-08 | | Aspirin | 5 | 2025-08-20 | Pending | 2025-08-07 | | Ibuprofen | 20 | 2026-01-10 | - | 2025-08-08 | Columns**: medicine_name: Name of the medicine. stock_quantity: Current stock level (e.g., number of units). expiry_date: Expiry date of the medicine (e.g., YYYY-MM-DD). alert_status: Status of the alert (e.g., Pending, Notified, - for no alert). last_checked: Date of the last inventory check. Customization Ideas Adjust Thresholds**: Change the low stock threshold (e.g., from 10 to 5) or expiry window (e.g., from 30 to 15 days). Add SMS Alerts**: Integrate Twilio or another SMS service for additional notifications. Incorporate Barcode Scanning**: Add a node to import inventory updates via barcode scanners. Dashboard Integration**: Connect to a dashboard (e.g., Google Data Studio) for real-time inventory tracking. Automated Restock Orders**: Add logic to generate purchase orders for low stock items. Requirements to Run This Workflow Google Sheets Account**: For storing and managing inventory data. Email Service**: Gmail, SMTP, or similar for email alerts. n8n Instance**: With Google Sheets and email connectors configured. Cron Service**: For scheduling the daily trigger. Internet Connection**: To access Google Sheets and email APIs. Optional SMS Service**: Twilio or similar for SMS alerts (requires additional credentials). Want a tailored workflow for your business? Our experts can craft it quickly Contact our team
by Oneclick AI Squad
This workflow utilizes Philips IntelliVue Device details to automatically track patient vitals, such as heart rate and oxygen levels. It quickly spots critical health issues and sends alerts to healthcare staff for fast action. The system saves data for records and helps improve patient care with real-time updates. It’s simple to set up and adjust for different needs. Essential Information Processes data from Philips IntelliVue Devices to monitor vitals instantly. Filters and categorizes conditions as critical or non-critical based on thresholds. Sends clinical alerts for critical conditions and logs data for review. Runs every 30 seconds to ensure timely updates. System Architecture Data Collection Pipeline: Poll Device Data Every 30s**: Continuously retrieves vitals from Philips IntelliVue Devices. Fetch from IntelliVue Gateway**: Retrieves data via HTTP GET requests. Processing Pipeline: Process Device Data**: Analyzes and validates the data stream. Alert Generation Flow: Validate & Enrich Data**: Ensures accuracy and adds patient context. Save to Patient Database**: Stores data for records. Check Alert Status**: Applies rules to trigger alerts. Send Clinical Alert**: Notifies staff for critical conditions. Implementation Guide Import workflow JSON into n8n. Configure the Philips IntelliVue Devices gateway URL and test with sample data. Set up alert credentials (e.g., email). Test and adjust rule thresholds. Technical Dependencies Philips IntelliVue Devices for vitals data. n8n for automation. Email or messaging API for alerts. Database for data storage. Customization Possibilities Adjust Switch node rules for critical thresholds. Customize alert messages. Modify database schema. Add logging for analysis.
by Paul Roussel
Who's it for This workflow is perfect for app developers, SaaS founders, and mobile growth teams who need constant UGC-style video ads without hiring creators or agencies. If you're spending $500+ per creator and waiting weeks for videos, this automates the entire process for $2-5 per video in 8 minutes. How it works Upload an app screen recording, and this n8n workflow handles everything: Gemini AI analyzes the recording and generates a UGC ad structure (hook, problem, solution, CTA with word limits). It describes the ideal actor, emotional journey, and visual style. Sora 2 then generates a hyper-realistic AI actor delivering the script naturally. VideoBGRemover removes the actor's background and composites them picture-in-picture over your screen recording with audio mixing. The result is a scroll-stopping UGC ad ready for TikTok, Instagram, and Facebook. Set up steps Setup takes ~10 minutes and requires 3 API keys: Get your Gemini API key from Google AI Studio Get your FAL AI key for Sora 2 access Get your VideoBGRemover API key at https://videobgremover.com/n8n Add all three keys to n8n environment variables Connect Google Drive for output storage Test with the included sample screen recording The workflow includes 7 detailed sticky notes explaining each section (Gemini analysis, Sora generation, VideoBGRemover composition, output handling). Requirements Google Gemini API key (for video analysis) FAL AI API key (for Sora 2 access) VideoBGRemover API key Google Drive account (for final video storage) App screen recordings in vertical format (9:16 recommended, 4-12 seconds) How to customize Modify the Gemini prompt to adjust ad tone, script word limits, or actor descriptions. Change composition settings in the VideoBGRemover node (position, size, audio mix). Add your own post-processing nodes for branding, captions, or multi-platform exports.
by Arkadiusz
What this workflow does This template automates the entire process of documenting Sprint Reviews in Scrum: Input Collection – Through a friendly form, users upload the transcript file (meeting notes, sprint review transcript, or VTT captions) and specify the sprint name and domain. Transcript Parsing – A Code node formats the transcript into clean [HH:MM:SS] Speaker: text lines, supporting VTT, Zoom, or custom timestamp formats used in Scrum events. AI-Driven Summary – The AI Agent (LangChain + OpenAI) produces a well-structured AI summarization in Markdown, including: A 3–5 bullet Executive Summary of sprint review highlights A Presentation Recap table (Timestamp | Presenter | Topics) A list of Action Items with owners (if recognizable from the transcript) Preview – The summary renders as a styled card with custom CSS for easy readability in n8n. Archive – Automatically appends a record to Google Sheets, saving the date, domain, sprint, transcript file name, and the AI-generated sprint review summary. Why it’s useful Zero manual summarizing** – AI extracts key insights from transcript files into Markdown you can instantly share with your Scrum team and stakeholders. Easy setup** – drag-and-drop import, plus form-based input for non-technical users during sprint reviews. Centralized tracking** – all past sprint summaries live in one spreadsheet for retrospectives, audits, and continuous improvement. Flexible and extendable** – you can switch to Airtable, Slack, or Notion, or refine the summary template to match your Scrum workflow. Ideal for Scrum Masters** wanting quick sprint review summaries for stakeholders Agile Coaches** analyzing sprint review transcripts, presentation patterns, and follow-up tasks Product Owners** keeping a searchable log of sprint outcomes and action items Prerequisites / Credentials OpenAI API Key** — required for the AI Agent node (or any other Agent for summarization) Google Sheets OAuth2 credentials** — required for saving sprint review data to Sheets (Optional) Ensure LangChain / AI Agent nodes are installed in your n8n instance How to Use This Template Import the workflow JSON into your n8n instance. Set up credentials: For the OpenAI LLM node, provide your OpenAI API key In Google Sheets, configure OAuth2 and specify your spreadsheet ID (replace YOUR_SHEET_ID) Create a new sheet with the following columns: Date Domain Sprint name Content VTT file Transcript Enable and run the workflow. Fill out the form: upload transcript file, enter sprint & domain, click Create Summary. View the AI-generated Markdown sprint review summary in the preview card. Verify the new entry appears in your Google Sheet with all sprint details.
by Madame AI
Product Hunt Launch Monitor - Scraping & Summarization of Product Hunt Feedbacks This n8n template provides automated competitive intelligence by scraping and summarizing Product Hunt launch feedback with a specialized AI analyst. This workflow is essential for product managers, marketing teams, and founders who need to quickly gather and distill actionable insights from competitor launches to inform their own product strategy and positioning. Self-Hosted Only This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only. How it works The workflow can be triggered manually but is designed to be easily switched to a Schedule Trigger for continuous competitive monitoring. A Google Sheet node fetches a list of product names you wish to monitor, which the workflow processes in a loop. A BrowserAct node then initiates a web scraping task to collect all the public comments from the specified Product Hunt launch page. An AI Agent, powered by Google Gemini, acts as a competitive intelligence analyst, processing the raw comments. The AI distills the feedback into a structured format, providing a concise Summary, pinpointing key Positive and Negative feedback, and generating Recommendations for a similar product to be successful. The structured analysis is saved to a Google Sheet for easy review and tracking. Finally, a Slack notification confirms that the Product Hunt results have been processed and updated. Requirements BrowserAct** API account for web scraping BrowserAct* "Product Hunt Launch Monitor*" Template BrowserAct** n8n Community Node -> (n8n Nodes BrowserAct) Gemini** account for the AI Agent Google Sheets** credentials for input and saving the analysis Slack** credentials for sending notifications Need Help? How to Find Your BrowseAct API Key & Workflow ID How to Connect n8n to Browseract How to Use & Customize BrowserAct Templates How to Use the BrowserAct N8N Community Node Workflow Guidance and Showcase Steal Your Competitor's Weaknesses (Product Hunt + BrowserAct + n8n)
by Evoort Solutions
Spotify Music Downloader: Effortless Music Downloading from Spotify Description: The Spotify Music Downloader is an automation flow that allows users to easily download music from Spotify tracks. By leveraging the powerful Spotify Downloader API, the flow downloads Spotify tracks, uploads them to Google Drive, and logs the details to Google Sheets for better management. With this tool, you can save time and effort while enjoying the convenience of direct downloads and automatic organization. Use Case: Music Enthusiasts**: Easily download your favorite Spotify tracks and store them in Google Drive. Content Creators**: Automate the process of storing and tracking downloaded music files. Organizational Automation**: Store download links and file sizes in Google Sheets to track downloads systematically. Spotify Users**: Provides a hassle-free way to access and organize your Spotify music offline. Benefits: Simple & Automated**: Easily download and organize music from Spotify with minimal effort. Seamless Integration**: Directly integrates with Google Drive for storage and Google Sheets for tracking. Fast: Uses the **Spotify Downloader API to quickly fetch and download the tracks. Track Downloads**: Keep a record of each download, including size, download link, and other details. Google Drive Storage**: Automatic storage of downloaded tracks in your Google Drive, making it easy to access files anytime. Node-by-Node Explanation: On Form Submission: The flow starts when the user submits a Spotify track URL through a form. HTTP Request (Spotify Downloader API): Sends a request to the Spotify Downloader API to retrieve the music file associated with the given Spotify URL. If (Link Validation): Ensures that the provided Spotify URL is not empty. If1 (Success Validation): Checks if the API response was successful. Download Music: Downloads the music file from the provided Spotify link using the fetched download URL. Google Drive: Uploads the downloaded music file to Google Drive. Google Sheets: Logs the successful download details (like URL, download link, size, and timestamp) to Google Sheets. Code (File Size Calculation): Calculates the file size of the downloaded music file in MB. Wait: Introduces a delay to ensure that the upload process to Google Drive is complete before continuing. Wait1: Another wait node to allow additional time between the various steps in the flow. Google Sheets1 (Success Logs): Adds a new record for a successful download to a Google Sheet. Google Sheets2 (Failed Logs): Records failed download attempts in a secondary Google Sheet. By utilizing this flow, you can automate the process of downloading music from Spotify and storing it in Google Drive while keeping track of every download in Google Sheets. It's an ideal solution for music lovers, content creators, or anyone looking to automate their music download and storage process with ease. Create your free n8n account and set up the workflow in just a few minutes using the link below: 👉 Start Automating with n8n Save time, stay consistent, and grow your LinkedIn presence effortlessly!
by Jaures NYA
This workflow automates the process of generating personalized UGC (User-Generated Content) images based on form submissions. It accepts a form with a character type (e.g., male/female) and an uploaded image, merges them, sends them to an AI model (Google Gemini via OpenRouter) for creative generation, and posts the resulting content as a Telegram photo message. Who’s it for This automation template is designed for marketers, AI creators, content teams, or interactive community platforms that want to let users submit content (image + character type), enrich it with AI-generated descriptions, and instantly publish results to Telegram — without writing a single line of code. How it works Trigger: Workflow starts when a form is submitted by a user. Extract file: The uploaded image file is converted to a Base64 string. Merge data: The character type and image data are combined into one payload. Format to Data URL: The image is wrapped as a proper data:image/... format for API use. Prepare payload: The text and image are mapped into a structure compatible with Gemini API. Generate AI content: Sends the input to Google Gemini (via OpenRouter) to generate a UGC description. Transform response: Cleans and extracts the result from Gemini’s response. Convert back to file: Transforms the Base64 image back into a real image file. Send to Telegram: The image and its AI-generated description are sent as a photo message to your Telegram channel. How to use Set up a form with a dropdown for character type (e.g., Male/Female) and an image upload field. Configure the Gemini API access through OpenRouter. Connect your Telegram bot and channel to receive the final result. Start the workflow → users submit the form, and their data is processed and shared as AI-enhanced UGC. Requirements OpenRouter API key to access Google Gemini. A Telegram Bot connected to your Telegram channel. ❓ Need help Contact me for consulting and support: LinkedIn / YouTube / Skool
by Asuka
Who is this for This template is designed for e-commerce businesses, customer support teams, and marketing professionals who need to monitor and analyze customer reviews at scale. It's especially useful for teams dealing with multilingual reviews (Japanese to English) and those who want instant alerts for critical feedback. What it does This workflow automatically processes customer reviews stored in Google Sheets using OpenAI GPT. For each review, it performs: Translation** from Japanese to English Sentiment analysis** with a score from -1.0 to +1.0 Importance classification** (High/Medium/Low) based on urgency Category tagging** (Quality, Price, Shipping, Support, Features, Usability, Other) Key phrase extraction** for quick summary Results are written back to the spreadsheet, and Telegram notifications are sent based on priority level. How to set up Connect your Google Sheets account and select your review spreadsheet Configure OpenAI API credentials Set up Telegram Bot and enter your Chat ID in both notification nodes Adjust the schedule trigger interval as needed Requirements Google Sheets with columns: ReviewID, Keyword (review text), ProcessStatus OpenAI API key Telegram Bot Token and Chat ID How to customize Modify the AI prompt in "AI Agent - Review Analysis" to change analysis criteria or add new fields Adjust the sentiment threshold (-0.5) in "Check Importance & Sentiment" node Customize notification messages in Telegram nodes Change the source/target language by editing the prompt
by Dele Odufuye
N8n OpenAI-Compatible API Endpoints Transform your n8n workflows into OpenAI-compatible API endpoints, allowing you to access multiple workflows as selectable AI models through a single integration. What This Does This workflow creates two API endpoints that mimic the OpenAI API structure: /models - Lists all n8n workflows tagged with aimodel (or any other tag of your choice) /chat/completions - Executes chat completions with your selected workflows, supporting both text and stream responses Benefits Access Multiple Workflows: Connect to all your n8n agents through one API endpoint instead of creating separate pipelines for each workflow. Universal Platform Support: Works with any application that supports OpenAI-compatible APIs, including OpenWebUI, Microsoft Teams, Zoho Cliq, and Slack. Simple Workflow Management: Add new workflows by tagging them with aimodel . No code changes needed. Streaming Support: Handles both standard responses and streaming for real-time agent interactions . How to Use Download the workflow JSON file from this repository Import it into your n8n instance Tag your workflows with aimodel to make them accessible through the API Create a new OpenAI credential in n8n and change the Base URL to point to your n8n webhook endpoints . Learn more about OpenAI Credentials Point your chat applications to your n8n webhook URL as if it were an OpenAI API endpoint Requirements n8n instance (self-hosted or cloud) Workflows you want to expose as AI models Any OpenAI-compatible chat application Documentation For detailed setup instructions and implementation guide, visit https://medium.com/@deleodufuye/how-to-create-openai-compatible-api-endpoints-for-multiple-n8n-workflows-803987f15e24. Inspiration This approach was inspired by Jimleuk’s workflow on n8n Templates.