Generate monthly financial reports with Gemini AI, SQL, and Outlook
๐ AI-Powered Business Performance Reporting Automation Unlock executive-level insights with ZERO manual work! This n8n template empowers you to automate your entire monthly business performance reporting using dynamic SQL queries, AI-driven analysis, and beautiful HTML dashboards โ all delivered directly to your inbox. --- ๐ฏ What This Automation Does ๐ Triggers automatically every month (5th of each month) ๐งฎ Fetches financial data from SQL (ERPNext or any database) ๐ Loops over cost centers to analyze each business unit individually ๐ Generates Profit & Loss reports, WIP, Employee stats, and vertical breakdowns ๐ค Uses Google Gemini 2.5 AI to perform advanced financial analysis ๐ Delivers a polished HTML report to your email inbox ๐ง Fully modular โ replace data source with Excel, Google Sheets, or APIs --- ๐งโ๐ซ Step-by-Step Video Tutorial ๐ฅ Watch the full tutorial on YouTube: [](https://youtu.be/yatQpQZLqg4) ๐ Learn how each node works and see the AI-generated report in action. --- ๐ Useful Links ๐ Sign up for n8n Cloud (recommended for non-tech users): ๐ https://n8n.syncbricks.com ๐ Download the step-by-step Guidebook (Free): ๐ https://lms.syncbricks.com/books/n8n ๐ Explore the full course on n8n (includes templates, workflows, and AI integrations): ๐ https://lms.syncbricks.com/courses/n8n --- ๐ Requirements โ n8n (Self-hosted or Cloud) โ SQL Database (MySQL / PostgreSQL / ERPNext) โ Microsoft Outlook or Gmail (to send the report) โ Gemini API Key (for AI analysis) โ Basic understanding of your data schema --- ๐ก Why Use This Template? โฑ Saves 2-3 days of manual work every month ๐ Improves financial visibility across business units ๐ค Great for CFOs, COOs, Finance Analysts, and BI teams ๐ Scales across multiple divisions and companies ๐ง Leverages AI for actionable insights and recommendations --- ๐งฉ Customize It Your Way Replace the SQL nodes with: Excel / Google Sheets Airtable / APIs Custom Applications Swap the AI model: OpenAI GPT Claude DeepSeek Adjust the report structure or HTML style --- ๐ Get Started Now ๐ฏ Import the JSON template โ Connect your data โ Receive business insights via email. Donโt let manual reporting slow down your decision-making. ๐ Sign up for n8n Cloud ๐ Learn n8n with Amjid ๐ Download Guide --- Created by Amjid Ali | SyncBricksโข โ Automation for Everyone
By Amjid AliConvert text to speech with OpenAI
How It Works This workflow sends an HTTP request to OpenAI's Text-to-Speech (TTS) model, returning an .mp3 audio recording of the provided text. This template is meant to be adapted for your individual use case, and requires a valid OpenAI credential. Gotchas Per OpenAI's Usage Policies, you must provide a clear disclosure to end users that the TTS voice they are hearing is AI-generated and not a human voice, if you are using this workflow to provide audio output to users.
By Kevin ColeScale deal flow with a Pitch Deck AI vision, chatbot and QDrant vector store
Are you a popular tech startup accelerator (named after a particular higher order function) overwhelmed with 1000s of pitch decks on a daily basis? Wish you could filter through them quickly using AI but the decks are unparseable through conventional means? Then you're in luck! This n8n template uses Multimodal LLMs to parse and extract valuable data from even the most overly designed pitch decks in quick fashion. Not only that, it'll also create the foundations of a RAG chatbot at the end so you or your colleagues can drill down into the details if needed. With this template, you'll scale your capacity to find interesting companies you'd otherwise miss! Requires n8n v1.62.1+ How It Works Airtable is used as the pitch deck database and PDF decks are downloaded from it. An AI Vision model is used to transcribe each page of the pitch deck into markdown. An Information Extractor is used to generate a report from the transcribed markdown and update required information back into pitch deck database. The transcribed markdown is also uploaded to a vector store to build an AI chatbot which can be used to ask questions on the pitch deck. Check out the sample Airtable here: https://airtable.com/appCkqc2jc3MoVqDO/shrS21vGqlnqzzNUc How To Use This template depends on the availability of the Airtable - make a duplicate of the airtable (link) and its columns before running the workflow. When a new pitchdeck is received, enter the company name into the Name column and upload the pdf into the File column. Leave all other columns blank. If you have the Airtable trigger active, the execution should start immediately once the file is uploaded. Otherwise, click the manual test trigger to start the workflow. When manually triggered, all "new" pitch decks will be handled by the workflow as separate executions. Requirements OpenAI for LLM Airtable For Database and Interface Qdrant for Vector Store Customising This Workflow Extend this starter template by adding more AI agents to validate claims made in the pitch deck eg. Linkedin Profiles, Page visits, Reviews etc.
By Jimleuk๐ Automatically update stock portfolio from OneDrive to Excel
Seamlessly Sync and Update Data from a csv in OneDrive to Excel with n8n This workflow is perfect for users who need a reliable, automated way to transfer and organize data from OneDrive into Excelโespecially for tasks like portfolio tracking, inventory management, and record-keeping. By monitoring your OneDrive folder for new CSV files, it performs data cleaning, transformation, and real-time updates in an Excel sheet, ensuring only new or changed records are added. --- How it Works Automated Monitoring: Every minute, the workflow scans a designated OneDrive folder for new files. File Verification: It checks if the detected file is in CSV format; if not, the process stops with an error message. Data Extraction and Cleaning: CSV data is loaded, and irrelevant headers are removed before mapping to specified columns in Excel. Excel Update: The workflow maps data to your Excel sheet, updating only new or modified entries based on a unique identifier ("Ticker/ISIN"). Cleanup: To keep your OneDrive organized, processed files are deleted after updating Excel. --- Setup Steps Connect OneDrive and Excel Accounts: Link your Microsoft OneDrive and Excel accounts in n8n. Designate Folder and Worksheet: Specify the OneDrive folder for monitoring and the Excel sheet for data updates. Configure Sync Frequency and CSV Validation: Set the monitoring frequency to every minute and ensure the workflow identifies CSV files accurately. Once configured, this workflow offers a hands-free, efficient solution to keep your OneDrive and Excel data synchronized effortlessly.
By LouisAI data analyst agent and visualization agent for large spreadsheets
Purpose of workflow: This workflow transforms spreadsheet data into an interactive, AI-powered knowledge base that enables users to gain deep insights through natural language queries, searchability, and comparative analysis. How it works: Data Storage & Integration: Spreadsheet data is imported into a no-code database (NocoDB) System connects with an AI data analyst agent Agent accesses table metadata and column information Query Processing: Users input natural language questions AI agent interprets queries and converts them to database filters System retrieves relevant data using filter formulas AI synthesizes responses with analysis and insights Advanced Capabilities: Performs comparative analysis across multiple data points Handles complex multi-part queries Automatically creates visualizations: Visualization AI Agent figures out the data and the chart type and generates professional visualization using Quickchart Step by step setup: Create account on nocodb.com Create table by importing csv, copy table id Create API token https://app.nocodb.com//account/tokens In workflow, settings node, update with table id In NocoDB tool node, setup authentication with API token created in step 3 Specify the workspace and base fields after connecting to NocoDB
By Derek CheungAutomated TikTok video downloader bot (no watermark) using n8n and Telegram
Description This workflow is an n8n-based automation that allows users to download TikTok/Reels videos without watermarks simply by sending the video link through a Telegram Bot. It uses a Telegram Trigger to receive the link from the user, then makes an HTTP request to a third-party API (tiktokio.com) to process and retrieve the download link. The workflow filters the results to find the Download without watermark link, downloads the video in MP4 format, and sends it back to the user directly in their Telegram chat. Key features: Supports the best available video quality (bestvideo+bestaudio). Automatically removes watermarks. Instant response directly in Telegram chat. Fully automated โ no manual downloads required. How It Works Telegram Trigger The user sends a TikTok or Reels link to the Telegram bot. The workflow captures and stores the link for processing. HTTP Request โ MediaDL API The link is sent via POST method to https://mediadl.app/api/download. The API processes the link and returns video file data. Wait Delay The workflow waits a few seconds to ensure the API response is fully ready. Edit Fields Extracts the video file URL from the API response. Additional Wait Delay Adds a short pause to avoid connection errors during the download process. HTTP Request โ Proxy Download Downloads the MP4 video file directly from the filtered URL. Send Video via Telegram The downloaded video is sent back to the user in their Telegram chat. How to Set Up Create & Configure a Telegram Bot Open Telegram and search for BotFather. Send /newbot โ choose a name & username for your bot. Copy the Bot Token provided โ youโll need it in n8n. Prepare Your n8n Environment Log in to your n8n instance (self-hosted or n8n Cloud). Go to Credentials โ create new Telegram API credentials using your Bot Token. Import the Workflow In n8n, click Import and select the PROJECTDOWNLOADTIKTOK_REELS.json file. Configure the Telegram Nodes In the Telegram Trigger and Send Video nodes, connect your Telegram API credentials. Configure the HTTP Request Nodes Ensure the Download2 and HTTP Request nodes have the correct URL and headers (pre-configured for mediadl.app). Make sure the responseFormat is set to file in the final download node. Activate the Workflow Toggle Activate in the top right corner of n8n. Test by sending a TikTok or Reels link to your bot โ you should receive the no-watermark video in return.
By GarriSend weather alerts to your mobile phone with OpenWeatherMap and SIGNL4
Get weather alerts on your mobile phone via push, SMS or voice call. This flow gets weather information every morning and sends out an alert to your SIGNL4 on-call team. For example you can send out weather alerts in case of freezing temperatures, snow, rain, hail storms, hot weather, etc. The flow also supports automatic alert resolution. So, for example if the temperature goes up again the alert is closed automatically in the app. User cases: Dispatch snow removal teams Inform car dealers to protect the cars outside in case of hail storms Set sails if there are high winds And much more ... Can be adapted easily to other weather warnings, like rain, hail storm, etc.
By Ron๐ง Flowatch ๐๏ธ analyze and diagnose n8n workflow errors via OpenAI and email
๐ง Analyze and Diagnose n8n Workflow Errors Automatically via OpenAI and Email > โ ๏ธ This template is available on โ๏ธ Cloud & ๐ฅ๏ธ self-hosted n8n instances with the OpenAI node enabled. --- ๐ค Who is this for? This workflow is designed for n8n developers, automation engineers, and DevOps teams who want to automatically capture and analyze workflow errors, and receive professional HTML-styled diagnostics directly in their inbox. --- ๐ฅ What problem does this solve? Manually troubleshooting failed workflows in n8n can be time-consuming. This template streamlines error detection by: Capturing workflow failures using the Error Trigger node Diagnosing root causes with the help of OpenAI Sending a fully-formatted, human-readable HTML error report via email Including practical resolutions and next-step suggestions This helps you or your team resolve issues faster and avoid repeated manual debugging. --- โ๏ธ What this workflow does โก Triggers on any n8n workflow error ๐ฆ Extracts relevant error metadata including node, execution ID, and timestamps ๐ง Sends error content to OpenAI for analysis and recommendations ๐ Generates an HTML email report with inline styles and clear formatting ๐ฅ Emails the result to a system administrator or support email --- ๐ ๏ธ Setup Install the OpenAI node in your self-hosted n8n instance. Add your OpenAI API Key securely in credentials. Configure the SMTP Email node with your email credentials. Adjust the Error Trigger to monitor specific workflows or all workflows. Set your preferred admin or dev email address in the final node. --- ๐ง How to customize this workflow to your needs ๐งฉ Use a [Set node] to define your variables, such as: Default admin email Workflow filter (optional) โ๏ธ Customize the prompt sent to OpenAI if you want deeper or more specific analysis ๐จ Modify the email HTML styles to match your brand or internal format ๐พ Add additional logging (e.g., to Airtable, Google Sheets, or Notion) for long-term error tracking --- ๐ Sticky Note Title: Automated Error Reporter with AI-Powered Diagnosis Description: Captures any n8n error, sends it to OpenAI, and emails a beautiful HTML report to the administrator with steps to resolve the issue. Requires OpenAI credentials and SMTP configured.
By RealSimple SolutionsTransform raw hiring transcripts into briefs & scorecards with AI and Google Docs
Who is this template for ? Basically anyone involved in recurring recruiting processes and looking to save a considerable amount of time and energy (Talent acquisitions Managers, recruiting consultants, hiring managers, foundersโฆetc) What it does : It takes a messy and raw transcript from an โintake meetingโ between a recruiter and a Hiring manager and turns it into a clean and exhaustive brief + scorecard templates for each interview rounds It does it under 1 MINUTE while the usual โmanualโ process usually takes several hours How to customize this workflow to your needs Google doc is the default choice because it allows easy modification of the output, but you can choose to output this under any format and / or store it wherever you want I strongly suggest to choose one of the latest LLM models for better output quality Both LLM prompts can be revised to match your expectations better
By Nicolas Le GalloMonitor CISA critical vulnerability alerts with RSS feed & Slack notifications
--- How It Works: The 5-Node Monitoring Flow This concise workflow efficiently captures, filters, and delivers crucial cybersecurity-related mentions. Monitor: Cybersecurity Keywords (X/Twitter Trigger) This is the entry point of your workflow. It actively searches X (formerly Twitter) for tweets containing the specific keywords you define. Function: Continuously polls X for tweets that match your specified queries (e.g., your company name, "Log4j," "CVE-2024-XXXX," "ransomware"). Process: As soon as a matching tweet is found, it triggers the workflow to begin processing that information. Format Notification (Code Node) This node prepares the raw tweet data, transforming it into a clean, actionable message for your alerts. Function: Extracts key details from the raw tweet and structures them into a clear, concise message. Process: It pulls out the tweet's text, the user's handle (@screen_name), and the direct URL to the tweet. These pieces are then combined into a user-friendly notificationMessage. You can also include basic filtering logic here if needed. Valid Mention? (If Node) This node acts as a quick filter to help reduce noise and prevent irrelevant alerts from reaching your team. Function: Serves as a simple conditional check to validate the mention's relevance. Process: It evaluates the notificationMessage against specific criteria (e.g., ensuring it doesn't contain common spam words like "bot"). If the mention passes this basic validation, the workflow continues. Otherwise, it quietly ends for that particular tweet. Send Notification (Slack Node) This is the delivery mechanism for your alerts, ensuring your team receives instant, visible notifications. Function: Delivers the formatted alert message directly to your designated communication channel. Process: The notificationMessage is sent straight to your specified Slack channel (e.g., cyber-alerts or security-ops). End Workflow (No-Op Node) This node simply marks the successful completion of the workflow's execution path. Function: Indicates the end of the workflow's process for a given trigger. --- How to Set Up Implementing this simple cybersecurity monitor in your n8n instance is quick and straightforward. Prepare Your Credentials Before building the workflow, ensure all necessary accounts are set up and their respective credentials are ready for n8n. X (Twitter) API: You'll need an X (Twitter) developer account to create an application and obtain your Consumer Key/Secret and Access Token/Secret. Use these to set up your Twitter credential in n8n. Slack API: Set up your Slack credential in n8n. You'll also need the Channel ID of the Slack channel where you want your security alerts to be posted (e.g., security-alerts or it-ops). Import the Workflow JSON Get the workflow structure into your n8n instance. Import: In your n8n instance, go to the "Workflows" section. Click the "New" or "+" icon, then select "Import from JSON." Paste the provided JSON code (from the previous response) into the import dialog and import the workflow. Configure the Nodes Customize the imported workflow to fit your specific monitoring needs. Monitor: Cybersecurity Keywords (X/Twitter): Click on this node. Select your newly created Twitter Credential. CRITICAL: Modify the "Query" parameter to include your specific brand names, relevant CVEs, or general cybersecurity terms. For example: "YourCompany" OR "CVE-2024-1234" OR "phishing alert". Use OR to combine multiple terms. Send Notification (Slack): Click on this node. Select your Slack Credential. Replace "YOURSLACKCHANNEL_ID" with the actual Channel ID you noted earlier for your security alerts. (Optional: You can adjust the "Valid Mention?" node's condition if you find specific patterns of false positives in your search results that you want to filter out.)* Test and Activate Verify that your workflow is working correctly before setting it live. Manual Test: Click the "Test Workflow" button (usually in the top right corner of the n8n editor). This will execute the workflow once. Verify Output: Check your specified Slack channel to confirm that any detected mentions are sent as notifications in the correct format. If no matching tweets are found, you won't see a notification, which is expected. Activate: Once you're satisfied with the test results, toggle the "Active" switch (usually in the top right corner of the n8n editor) to ON. Your workflow will then automatically monitor X (Twitter) at the specified polling interval. ---
By MarthCreate an intelligent Facebook Messenger chatbot with GPT-4o-mini & message memory
Who is this for? Businesses and developers who want to automate customer support or engagement on Facebook Messenger using AI-powered responses. What does it do? Creates an intelligent Facebook Messenger chatbot that: Responds to messages using OpenAI (gpt-4o-mini) Batches rapid-fire messages into a single AI request Maintains conversation history (50 messages per user) Shows professional UX feedback (seen indicators, typing bubbles) How it works Webhook Verification - Handles Facebook's GET verification request Message Reception - Receives incoming messages via POST webhook Message Batching - Waits 3 seconds to collect multiple quick messages AI Processing - Sends combined message to OpenAI with conversation context Response Delivery - Formats and sends the AI response back to Messenger Setup Configure Facebook Graph API credential with your Page Access Token Configure OpenAI API credential with your API key Set your verify token in the "Is Token Valid?" node Register the webhook URL in Facebook Developer Console Key Features Message Batching: Combines "Hey" + "Can you help" + "with my order?" into one request Conversation Memory: Remembers context from previous messages Echo Filtering: Prevents responding to your own messages Response Formatting: Cleans markdown for Messenger's 2000-char limit
By Tristan VGenerate branded article images with GPT-4o, FAL Flux and Google Drive
๐ What this workflow does This workflow automatically turns a topic and a reference image URL into a finished, branded article image. It uses GPT-4o to generate a short, detailed image prompt, sends it to FAL Flux image-to-image for rendering, polls until the job is completed, downloads and resizes the image, overlays your company logo, and finally saves the branded result into a specified Google Drive folder. ๐ค Who is this for Content teams who need consistent, on-brand article images. Marketing teams looking to scale blog and landing page visuals. Designers who want to automate repetitive resizing and branding tasks. Anyone who needs a pipeline from topic โ AI illustration โ Google Drive asset. โ Requirements OpenAI (GPT-4o) API credentials (for image prompt generation). FAL API key for Flux image-to-image generation. Google Drive OAuth2 connection + target folder ID for saving images. A company logo file/URL (direct download link from Google Drive or any public URL). โ๏ธ How to set up Connect OpenAI GPT-4o in the โCreate promptโ node. Add your FAL API key to all HTTP Request nodes (generate image, check image finish, Get image link). Replace the logo link in โGet companyโs logoโ with your own logo URL. Configure the Google Drive node with your OAuth2 credentials and set the correct Folder ID. Update the image_url in โLink imageโ (or pass from upstream data). Test the workflow end-to-end with a sample subject and image. ๐ How it works Form/Manual Trigger โ Input subject + reference image URL. GPT-4o โ Generates a <70-word sharp/detailed prompt (no text/logos). FAL Flux (HTTP Request) โ Submits job for image-to-image generation. Polling Loop โ Wait + check status until COMPLETED. Download Image โ Retrieves generated image link. Resize Image โ Standardize to 800ร500 pixels. Get & Resize Logo โ Fetch company logo, resize for branding. Composite โ Overlay logo onto article image. Save to Google Drive โ Final branded image saved in target folder. ๐ก About Margin AI Margin AI is your AI Service Companion. We help organizations design intelligent, human-centric automation โ from content pipelines and branding workflows to customer insights and sales enablement. Our tailored AI solutions scale marketing, operations, and creative processes with ease.
By Cong Nguyen