🚀 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: 📌 Learn how each node works and see the AI-generated report in action.
Tags
CalculatorCCodeGoogle Gemini Chat Model
HTML
Microsoft OutlookRelated workflows
See all AI Automation→
Qualify leads and send personalized audio follow-ups with Gemini and Smallest.ai
Quick Overview This workflow receives lead submissions via a webhook, uses Google Gemini to qualify the lead and write a personalized spoken follow-up script, and for qualified leads generates an MP3 with Smallest.ai, shares it from Google Drive, emails it via Gmail, logs outcomes to Google Sheets, and alerts sales in Slack. How it works Receives a POST webhook request containing a lead’s name, email, and message. Sends the lead details to a Google Gemini–powered AI agent to determine whether the lead is qualified and, if so, generate a short personalized audio script. Parses the agent’s JSON response and routes the workflow based on the qualified flag. If the lead is qualified, Smallest.ai synthesizes the script into an MP3 and uploads it to Google Drive. Shares the Google Drive audio file publicly and sends the lead a Gmail message with a link to listen. Appends the qualified lead record (including the audio link and timestamp) to Google Sheets and posts a notification to a Slack channel. If the lead is unqualified, appends the lead details and timestamp to Google Sheets without generating audio or sending email. Setup Enable the webhook and copy the generated /lead-capture URL i
Create narrated blog audio from RSS with Google Gemini, Smallest.ai and WordPress
Quick Overview This workflow polls a blog RSS feed, rewrites new posts into a spoken-word script using Google Gemini, generates an MP3 with Smallest.ai, uploads it to Google Drive, and updates the matching WordPress post to embed a public audio player. How it works Polls an RSS feed every minute to detect newly published or updated blog items. Extracts the post body and strips HTML, scripts, styles, and common entities to produce clean plain text. Uses Google Gemini to rewrite the text into a single, conversational narration script with an intro/outro and length limits. Sends the rewritten script to Smallest.ai to synthesize an English MP3 audio file. Uploads the MP3 to Google Drive and updates sharing so anyone with the link can play it. Updates the corresponding WordPress post to embed an HTML5 audio player pointing to the Google Drive link and includes the article text below it. Setup Set the RSS feed URL in the RSS Feed Trigger node and confirm the feed provides the fields used for the post content and GUID. Add credentials for Google Gemini (Google AI / Gemini) and select that connection in the chat model used by the rewrite step. Add your Smallest.ai API credentials and verif
Create a Gmail morning audio briefing with Google Gemini and Google Drive
Quick Overview This workflow runs every weekday at 7 AM to fetch up to 10 unread Gmail messages from the last day, summarize them into a narrated script with Google Gemini, convert the script to an MP3 using Smallest.ai, upload it to Google Drive, and email you a public listening link. How it works Runs on a schedule every weekday at 7:00 AM. Pulls up to 10 unread Gmail emails from the last 24 hours. Cleans and categorizes the emails into URGENT, NEWSLETTERS, and OTHER sections while skipping common job-alert style messages. Uses a LangChain AI Agent powered by Google Gemini to turn the digest into a plain-text morning briefing script. Truncates the script to a safe character limit and converts it to speech as an MP3 with Smallest.ai. Uploads the MP3 to Google Drive, makes the file publicly readable, and sends a Gmail message with the listening link and the script text. Setup Connect your Gmail credentials for both reading unread emails and sending the briefing email, and update the recipient address in the outgoing email step. Add Google Gemini credentials in the Google Gemini Chat Model used by the AI Agent. Add your Smallest.ai API credentials for text-to-speech generation. Conn