Query n8n credentials with AI SQL agent
This n8n workflow is a fun way to query and search over your credentials on your n8n instance. Good to know Your credentials should remain safe as this workflow does not decrypt or use any decrypted data. Example Usage "Which workflows are using Slack and Google Calendar?" "Which workflows have AI in their name but are not using openAI?" How it works Using the n8n API, it fetches all workflow data on the instance. Workflow data contains references to credentials used so this will be extracted. With some necessary reformatting, the workflows and their credentials metadata are stored to a SQLite database. Next, an AI agent is used with a custom SQL tool that reads the SQLite database created in the previous step. The AI agent is instructed to perform SQL queries against our workflow credential table when asked about credentials by the user. Requirements You'll need an n8n API key. Please note that only workflows will be scoped to your API key. Customising the workflow Add extra table fields to the SQLite database to answer even more complex queries such as: workflow status to differentiate between active and inactive workflows.
By JimleukPharmacy inventory alerts for low stock & expiring medicine with Google Sheets
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 | |------------|---------------|------------|---------------|---------------| | medicinename | stockquantity | expirydate | alertstatus | 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 SquadAI email assistant: Prioritize Gmail with ChatGPT summaries and Slack digests
This n8n workflow acts as an AI-powered Inbox Assistant that automatically summarizes and classifies Gmail emails, prioritizes important messages, and sends a daily digest to Slack. Itβs ideal for startup founders and small teams juggling investor intros, customer leads, and support queries β all from a busy Gmail inbox. Each email is processed using ChatGPT to generate a concise summary, classify the message (e.g., Support, Investor, Spam), and determine its urgency. High and medium priority messages are forwarded to Slack instantly. Lower priority emails are logged to Google Sheets for review. A daily 7 PM digest summarizes the dayβs most important messages. π‘ Use Cases Preventing missed investor or lead emails Lightweight CRM alternative using Google Sheets Slack summaries of critical Gmail activity π§ How It Works Gmail node fetches new messages ChatGPT summarizes and extracts urgency + type High/medium urgency β sent to Slack + labeled in Gmail Low urgency β logged in Google Sheets Cron node triggers a daily 7 PM Slack summary β Requirements OpenAI API Key (GPT-4 or GPT-4o recommended) Gmail access with read and label permission Slack Bot Token or Webhook URL Google Sheets integration (optional) π Customization Ideas Replace Slack with Telegram or WhatsApp Route investor leads to Airtable or Notion Add multi-language support in ChatGPT prompt Create weekly summaries via email
By DarsheelAuto-create & post social media reels with Google Veo-3 AI and GPT
π GPT-5 + Veo-3 Instagram Reel Auto-Creator & Auto-Poster Description: This n8n workflow is a fully automated short-form video content engine that takes your creative idea, turns it into a cinematic video using Google Veo-3 via Wavespeed API, writes an engaging Instagram caption with GPT-5, and instantly posts it to Instagram via Postizβall without lifting a finger. Itβs designed for content creators, social media managers, and brands who want to produce high-quality, on-brand reels at scale without manual editing or posting. Watch Step-by-step build: www.youtube.com/@automatewithmarc π‘ Key Features: π¬ Chat-Triggered Automation (You can replace this with On Schedule trigger for automated generation) β Start the workflow with a simple message describing your video idea. π§ GPT-5 Video Prompt Agent β Transforms your concept into a visually rich, cinematic prompt optimized for Veo-3. π₯ Veo-3 AI Video Generation β Creates a polished short-form reel with cinematic motion, effects, and branding. βοΈ GPT-5 Caption Writer β Crafts an impactful, scroll-stopping caption tailored for Instagram engagement. π€ Auto-Posting with Postiz β Uploads and schedules (or instantly posts) your reel to Instagram without manual steps. β³ Automated Progress Checking β Wait & retry logic ensures posting only happens when the video is fully generated. π§ Tech Stack: GPT-5 via OpenAI API β AI for prompt engineering & caption creation. Google Veo-3 (via Wavespeed API) β Next-gen text-to-video model for short-form content. Postiz API β Multi-platform social media posting automation. n8n β Orchestration & automation engine. π Ideal Use Cases: Instagram Reels / TikTok Creators who want to post daily without editing. Fitness, Fashion, Travel & Lifestyle Brands looking for high-quality, thematic reels. Social Media Agencies producing client content at scale. Event Marketers creating same-day recap videos. π Setup Instructions: Add your API keys for OpenAI (GPT-5), Wavespeed (Veo-3), and Postiz. Connect Postiz to your Instagram account. Trigger the workflow with a chat message describing your desired video. Watch your idea transform into a reelβfully captioned and posted automatically. π― Why This Workflow Stands Out: End-to-end automation from idea β video β caption β Instagram post. AI-driven creative consistency for brand identity. Scales your content production without hiring editors. SEO & engagement-ready captions crafted for social virality.
By Automate With MarcCategorize and label existing Gmail emails automatically with GPT-4o mini
π¨ Categorize and Label Existing Gmail Emails Automatically with GPT-4o mini π₯ Who's it for This workflow is perfect for individuals or teams who want to sort and label existing emails in their Gmail inbox ποΈ using AI. Ideal for cleaning up unlabeled emails in bulk β no coding required! For sorting incoming emails messages in your gmail inbox, please use this free workflow: Categorize and Label Incoming Gmail Emails Automatically with GPT-4o mini π€ What it does It manually processes a selected number of existing Gmail emails, skips those that already have labels, sends the content to an AI Agent powered by GPT-4o mini π§ , and applies a relevant Gmail label based on the email content. All labels must already exist in Gmail. βοΈ How it works βΆοΈ Manual Trigger β The workflow starts manually when you click "Execute Workflow". π₯ Gmail Get Many Messages β Pulls a batch of existing inbox emails (default: 50). π« Filter β Skips emails that already have one or more labels. π§ AI Agent (GPT-4o mini) β Analyzes the content and assigns a category. π§Ύ Structured Output Parser β Converts the AI output into structured JSON. π Switch Node β Routes each email to the right label based on the AI result. π·οΈ Gmail Nodes β Apply the correct Gmail label to the email. π Requirements Gmail account connected to n8n Gmail labels must be manually created in your inbox beforehand Labels must exactly match the category names defined in the AI prompt OpenAI credentials with GPT-4o mini access n8n's AI Agent & Structured Output Parser nodes π οΈ How to set up In your Gmail account, create all the labels you want to use for categorizing emails Open the workflow and adjust the email fetch limit in the Gmail node (e.g., 50, 100) Confirm that the Filter skips emails that already have labels Define your categories in the AI Agent prompt β these must match the Gmail labels exactly In the Switch Node, create a condition for each label/category Ensure each Gmail Label Node applies the correct existing label Save the workflow and run it manually whenever you want to organize your inbox β π¨ How to customize the workflow Add or remove categories in the AI prompt & Switch Node Adjust the batch size of emails to process more or fewer per run Fine-tune the AI prompt to suit your inbox type (e.g., work, personal, client support)
By Arlin PerezYouTube comment scraper & analyzer with GPT-4o + email summary report
How it Works This workflow automates the collection and analysis of YouTube comments from a video and sends a summary report via email, using Google Sheets, the YouTube API, OpenAI (GPT-4o), and Gmail. Whether you're a content creator, brand manager, or social media analyst, this workflow helps you automate sentiment analysis and receive insights directly in your inbox β all triggered from a simple spreadsheet. π― Use Case Ideal for: YouTubers monitoring audience sentiment Marketing teams analyzing campaign feedback Community managers summarizing engagement Setup Instructions Upload the Spreadsheet File name: Youtube_Video Sheet structure: | ID | Video Title | YouTube Video ID | Status | Add video IDs and set their Status as Pending Configure Google Sheets Nodes Connect your Google account to: Pick Video IDs from Google Sheet Update Status on Google Sheet Add API Credentials YouTube API Key β for comment + video scraping nodes OpenAI API Key β for analyzing comments Gmail Account β for sending the summary email Activate the Workflow Once live, the workflow will: Watch for new or updated rows in the spreadsheet Scrape comments using the YouTube API Analyze sentiment and key themes via GPT-4o Send a formatted HTML email with the summary Update the spreadsheet status to Mail sent π Workflow Logic Trigger: New/updated row in Google Sheet Retrieve: YouTube video metadata + comments Analyze: Comments using GPT-4o Email: Summary report via Gmail Update: Spreadsheet status to Mail sent 𧩠Node Descriptions | Node Name | Description | |-----------|-------------| | Pick Video IDs from Google Sheet | Watches the spreadsheet and retrieves pending video IDs | | If | Checks whether status is 'Pending' | | Limit | Restricts the number of processed rows | | Set Video Details | Prepares video info (e.g., title, channel) | | Get YouTube Video Details | Fetches metadata (title, channel, etc.) | | Get YouTube Video Comments | Pulls top-level comments using YouTube API | | Prepare Comments Data | Formats comment text for OpenAI | | AI Agent | Summarizes comments using OpenAI's GPT-4o | | Prepare HTML for Email | Converts summary into HTML for email body | | Gmail Account Configuration | Sends the email report via Gmail | | Update Status on Google Sheet | Marks the row as 'Mail sent' | π οΈ Customization Tips Change the AI prompt for tone, length, or custom metrics Send results to Slack or Telegram instead of Gmail Export summaries to Notion, Airtable, or PDF Schedule it daily/weekly for recurring analysis π Suggested Sticky Notes for Workflow | Node/Section | Sticky Note Content | |--------------|---------------------| | Pick Video IDs from Google Sheet | "Triggers on new YouTube videos in your spreadsheet" | | AI Agent | "Uses OpenAI to generate an analysis summary β customize prompt as needed" | | Gmail | "Sends summary report β you can update subject, recipients, or style" | | Update Status | "Marks video as processed to avoid duplicate runs" | π Required Files | File Name | Purpose | |-----------|---------| | Youtube_Video | Google Sheet to hold YouTube video IDs and status | | YoutubeCommentScraper.json | Main n8n workflow export for this automation | π§ͺ Testing Tips Add one test video with a valid YouTube video ID and status = Pending Monitor the workflow logs to confirm API responses Confirm summary delivery in your inbox Verify that status updates in the sheet π· Suggested Tags & Categories YouTube OpenAI Automation Marketing Email Analytics
By Amit MehtaAutomated weather reports with Bright Data & n8n
Description This workflow automatically collects weather data from multiple sources and compiles it into comprehensive reports. It helps you make informed decisions based on accurate weather forecasts without manually checking multiple weather services. Overview This workflow automatically scrapes weather data from multiple sources and compiles it into a comprehensive report. It uses Bright Data to access weather websites and can be configured to send you regular weather updates for your locations of interest. Tools Used n8n: The automation platform that orchestrates the workflow. Bright Data: For scraping weather websites and forecast data without getting blocked. Notification Services: Email, messaging apps, or other platforms. How to Install Import the Workflow: Download the .json file and import it into your n8n instance. Configure Bright Data: Add your Bright Data credentials to the Bright Data node. Set Up Notifications: Configure how you want to receive weather reports. Customize: Add your locations of interest and reporting frequency. Use Cases Event Planners: Get weather forecasts for upcoming outdoor events. Farmers: Monitor weather conditions for agricultural planning. Travelers: Check weather forecasts for destinations before trips. --- Connect with Me Website: https://www.nofluff.online YouTube: https://www.youtube.com/@YaronBeen/videos LinkedIn: https://www.linkedin.com/in/yaronbeen/ Get Bright Data: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) n8n automation weather weatherforecasts brightdata webscraping weatherreports weatheralerts weatherdata weathermonitoring n8nworkflow workflow nocode weatherautomation weatherscraping weathertracking weathernotifications weatherupdates forecastdata weatherplanning weatherservice outdoorevents weatherapi weatherinformation climatedata weathertech
By Yaron BeenEnrich new Intercom users with contact details and more from ExactBuyer
Use Case This workflow aims to enrich new contacts in Intercom. The more relevant the Intercom profile, the more useful it is. Once active, this n8n workflow will update contact data (phone, email) as well as location data from ExactBuyer. Setup Add a webhook url in Intercom to call this workflow Add your Exact Buyer API key Add your Intercom API key Activate workflow How to adjust this template There's plenty of interesting info that ExactBuyer returns that could be helpful. Take a look and update this workflow to add what you need.
By MutasemSummarize meeting transcripts with GPT-4 & sentiment analysis for Gmail
Who it's for Project managers, AI builders, and teams who want structured, automated meeting summaries with zero manual work. What it does This workflow monitors a Google Drive folder for new meeting notes (PDF/TXT), extracts text, summarizes it via OpenAI GPT-4o, groups tasks by sentiment, builds a styled HTML summary, and sends it via Gmail. How to set it up Connect Google Drive, OpenAI, and Gmail credentials. Point the Drive Trigger to your meeting notes folder. Paste the system prompt into the AI node. Set Gmail Email Type to HTML and Message to {{$json.email_html}}. Drop a test file and execute once. Requirements n8n account Google Drive, OpenAI, and Gmail credentials Non-scanned PDFs or plain text files Customization ideas Add Slack or Notion logging Support additional file types Translate summaries automatically Tags ai automation productivity gmail drive meeting-summary openai
By Dhinesh RavikumarAutomated gold price tracker with multiple currency conversion for Telegram π
Keep an eye on gold prices without lifting a finger! π΅οΈββοΈ --- --- This workflow checks gold prices every 15 minutes and sends you a neat little report. What it does: β¨ Fetches the live price of gold. π Converts it into your local currency AND USD. π Creates a simple table with prices for 24k, 21k, and 18k gold. π Sends the update directly to your Telegram chat! Setup is easy: Just set your local currency (like 'EGP') and your Telegram Chat ID. That's it! β
By M SayedWebsite downtime alert via LINE + Supabase log
This workflow automatically checks the status of your websites using UptimeRobot API. If any site is down or unstable, it will: Generate a natural-language alert message using GPT-4o Push the message to a LINE group (with funny IT-style encouragement) Log all DOWN status entries into your Supabase database Wait 30 minutes before repeating π§ How It Works Schedule Trigger β Runs on a fixed interval (every few minutes). UptimeRobot Node β Fetches website monitor data. Code Node (Filter) β Filters only websites with status 8 (may be down) or 9 (down). IF Node β If any site is down, proceed. LangChain LLM Node β Formats alert with a humorous message using GPT-4o. Line Notify (HTTP Request) β Sends the alert to your LINE group. Loop Over Items β Loops through all monitors. Filter Down (Status = 9) β Selects only βfully downβ sites. Supabase Node β Logs these into synlorauptimedown table. Wait Node β Delays next alert by 30 minutes to avoid spamming. βοΈ Setup Steps Required: π UptimeRobot API Key π² LINE Channel Access Token and Group ID π§ OpenAI Key (GPT-4o Mini) ποΈ Supabase Project & Table Step-by-step: Go to UptimeRobot β Get API key and ensure monitors are set up. Create a Supabase table with fields: website, status, uptime_id. Create a LINE Messaging API bot, join it to your group, and get: Access Token Group ID (userId or groupId) Add your OpenAI API Key for GPT-4o Mini (or switch to your preferred LLM). Import the workflow JSON into n8n. Set credentials in all necessary nodes. Activate the workflow.
By sayamol thiramonpaphakulAutomate post to multiple Facebook groups with Airtop, Google Sheets & Telegram
The Airtop Facebook Automations workflow solves the challenge of managing and posting content across multiple Facebook groups effortlessly. Leveraging Airtop for browser automation, Google Sheets for group management, and Telegram for notifications, this workflow automates posting repetitive updates without manual intervention. Watch it on work on Youtube Why Use Airtop Facebook Automations? π‘ Key Benefits: Save Time & Effort: Automate posting to dozens of Facebook groups with a single trigger Consistent Messaging: Avoid errors by automating precise posting steps, ensuring your message appears correctly every time Scalable Engagement: Easily maintain active presence on multiple groups simultaneously, boosting your social reach and brand awareness Integrated Notifications: Receive instant Telegram confirmation for each successful post, keeping you informed without checking Facebook manually Who Is This For? β‘ Perfect for: Social media managers looking to scale Facebook group engagement without adding workload Marketing teams aiming to streamline content distribution across communities Small business owners managing Facebook groups for promotional updates Community moderators who post recurring announcements to multiple groups What Problem Does It Solve? Posting the same message to many Facebook groups manually is time-consuming, error-prone, and inefficient. Navigating the UI repeatedly can lead to fatigue and missed deadlines. This workflow automates browser interactions linking Telegram-triggered content creation with dynamic group lists from Google Sheets, eliminating manual browser clicking and typingβsaving you hours while maintaining consistency and control. How It Works π§ Workflow Steps: β± Trigger: Listens for new messages in a Telegram chat to capture the post content π Browser Setup: Initializes the Airtop browser session with a Facebook profile π Data Retrieval: Retrieves your list of Facebook groups dynamically from Google Sheets π€ Group Processing: For each group, opens the Facebook group page, scrolls down, and interacts with the post input field π Publishing: Types and publishes the post, then sends a success message back to Telegram with group details π Loop Management: Waits 5 seconds before looping to the next group and closes the browser when done Setup Instructions π Getting Started: Import Workflow Import the provided JSON file into your n8n instance. Set Up Credentials Configure the following credentials: Airtop API: Requires your API key from airtop.ai Google Sheets OAuth2: To access your Google Sheet with the Facebook group list Telegram API: For message triggers and notifications Customize Workflow Elements Update the Google Sheet URL and sheet name with your group data Adjust the Telegram chat ID or bot to suit your notification preferences Modify post message content as needed via Telegram input Update Required Elements Facebook profile login embedded within Airtop credentials URLs for targeted Facebook group pages must match your groups Test Thoroughly Test your workflow using realistic group URLs and Telegram messages. Pre-Requirements 𧩠What You Need: Active n8n instance (Cloud or Self-hosted) Airtop account API key Google account with access to the group list spreadsheet Telegram bot and chat set up for sending and receiving messages Customization Options π οΈ Extend the Workflow: Integrate scheduling nodes to automate posts at specific times of day Add error handling to skip groups if the post fails and log results Extend support to Facebook pages or event posting for broader social media management Technical Details π§ Nodes Used: Telegram Trigger: Captures incoming messages Set: Prepares post content Airtop: Handles browser automation (Start Browser, Load URL, Interactions like scroll, click, type, publish) Google Sheets: Fetches group list SplitInBatches: Iterates over each group Telegram: Sends success messages Wait: Manages pacing between posts Support π Get Help: Made by: Khmuhtadin Tags: Automation, Facebook, Social Media, Airtop, Telegram, Google Sheets Category: Social Media Automation Custom Solutions: Contact Me
By Khairul Muhtadin