Workflow Templates

This n8n template from Intuz provides a complete solution to automate the extraction of critical information from PDF documents like faxes, or any PDFs. It uses the power of Google Gemini's multimodal capabilities to read the document, identify key fields, and organize the data into a structured format, saving it directly to a Google Sheet. Who's this workflow for? Healthcare Administrators Medical Billing Teams Legal Assistants Data Entry Professionals Office Managers How it works 1. Upload via Web Form: The process starts when a user uploads a fax (as a PDF file) through a simple, secure web form generated by n8n. 2. AI Document Analysis: The PDF is sent directly to Google Gemini's advanced multimodal model, which reads the entire document—including text, tables, and form fields. It extracts all relevant information based on a detailed prompt. 3. AI Data Structuring: The raw extracted text is then passed to a second AI step. This step cleans the information and strictly structures it into a predictable JSON format (e.g., Patient ID, Name, DOB, etc.). 4. Save to Google Sheets: The final, structured data is automatically appended as a new, clean row in your designated Google Sheet, creating an organized and usable dataset from the unstructured fax. Key Requirements to Use This Template 1. n8n Instance & Required Nodes: An active n8n account (Cloud or self-hosted). This workflow uses the official n8n LangChain integration (@n8n/n8n-nodes-langchain). If you are using a self-hosted version of n8n, please ensure this package is installed. 2. Google Accounts: Google Drive Account: For temporarily storing the uploaded file. Google Gemini AI Account: A Google Cloud account with the Vertex AI API (for Gemini models) enabled and an associated API Key. Google Sheets Account: A pre-made Google Sheet with columns that match the data you want to extract. Customer Setup Guide: Here is a detailed, step-by-step guide to help you configure and run this workflow. 1. Before You Begin: Prerequisites Please ensure you have the following ready: The FAX-Content-Extraction.json file we provided. Active accounts for n8n, Google Drive, Google Cloud (for Gemini AI), and Google Sheets. A Google Sheet created with header columns that match the data you want to extract (e.g., Patient ID, Patient Name, Date of Birth, etc.). 2. Step-by-Step Configuration Step 1: Import the Workflow Open your n8n canvas. Click "Import from File" and select the FAX-Content-Extraction.json file. The workflow will appear on your canvas. Step 2: Set Up the Form Trigger The workflow starts with the "On form submission" node. Click on this node. In the settings panel, you will see a "Form URL". Copy this URL. This is the link to the web form where you will upload your fax files. Step 3: Configure the Google Drive Node Click on the "Upload file" (Google Drive) node. Credentials: Select your Google Drive account from the "Credentials" dropdown or click "Create New" to connect your account. Folder ID: In the "Folder ID" field, choose the specific Google Drive folder where you want the uploaded faxes to be saved. Step 4: Configure the Google Gemini AI Nodes (Very Important) This workflow uses AI in two places, and both need to be connected. First AI Call (PDF Reading): Click on the "Call Gemini 2.0 Flash with PDF Capabilities" (HTTP Request) node. Under "Authentication", make sure "Predefined Credential Type" is selected. For "Credential Type", choose "Google Palm API". In the "Credentials" dropdown, select your Google Gemini API key or click "Create New" to add it. Second AI Call (Data Structuring): Click on the "Google Gemini Chat Model" node (it's connected below the "Basic LLM Chain" node). In the "Credentials" dropdown, select the same Google Gemini API key you used before. Step 5: (Optional) Customize What Data is Extracted You have full control over what information the AI looks for. To change the extraction rules: Click on the "Define Prompt" node. You can edit the text in the "Value" field to tell the AI what to look for (e.g., "Extract only the patient's name and medication list"). To change the final output columns: Click on the "Basic LLM Chain" node. In the "Text" field, you can edit the JSON schema to add, remove, or rename the fields you want in your final output. The keys here MUST match the column headers in your Google Sheet. Step 6: Configure the Final Google Sheets Node Click on the "Append row in sheet" node. Credentials: Select your Google Sheets account from the "Credentials" dropdown. Document ID: Select your target spreadsheet from the "Document" dropdown list. Sheet Name: Select the specific sheet within that document. Columns: Ensure that the fields listed here match the columns in your sheet and the schema from the "Basic LLM Chain" node. 4. Running the Workflow Save and Activate: Click "Save" and then toggle the workflow to "Active". Open the Form: Open the Form URL you copied in Step 2 in a new browser tab. Upload a File: Upload a sample fax PDF and submit the form. Check Your Sheet: After a minute, a new row with the extracted data should appear in your Google Sheet. Connect with us Website: https://www.intuz.com/services Email: getstarted@intuz.com LinkedIn: https://www.linkedin.com/company/intuz Get Started: https://n8n.partnerlinks.io/intuz For Custom Worflow Automation Click here- Get Started

How it works Multi-modal AI Image Generator powered by Google's Nano Banana (Gemini 2.5 Flash Image) - the latest state-of-the-art image generation model Accepts text, images, voice messages, and PDFs via Telegram for maximum flexibility Uses OpenAI GPT models for conversation and image analysis, then Nano Banana for stunning image generation Features conversation memory for iterative image modifications ("make it darker", "change to blue") Processes different input types: analyzes uploaded images, transcribes voice messages, extracts PDF text All inputs are converted to optimized prompts specifically tuned for Nano Banana's capabilities Set up steps Create Telegram bot via @BotFather and get API token Set up Google Gemini API key from Google AI Studio for Nano Banana image generation (~$0.04/image) Configure OpenAI API key for GPT models (conversation, image analysis, voice transcription) Import workflow and configure all three API credentials in n8n Update bot tokens in HTTP request nodes for file downloads Test with text prompts, image uploads, voice messages, and PDF documents

A smart, fully automated coding pipeline built inside n8n that leverages Cursor AI to write, refactor, review, and optimize code projects — triggered by a webhook, schedule, or manual prompt. Every output is versioned, stored, and delivered with a detailed review report. 🎯 What's the Goal? Eliminate the repetitive overhead of writing boilerplate code, performing code reviews, and refactoring legacy code manually. This workflow turns a plain-text task description into production-ready, reviewed, and optimized code — automatically and at scale — using Cursor AI's deep coding intelligence inside n8n. 💡 Why Does It Matter? Software teams lose hundreds of hours to boilerplate writing, manual code reviews, and inconsistent refactoring. AI-assisted coding with Cursor is powerful, but still requires manual triggering. By wiring Cursor into n8n, you get a repeatable, auditable, hands-free coding pipeline that integrates directly with your Git repos, Slack, and storage — making AI code generation a true part of your CI/CD culture, not just a one-off tool. ⚙️ How It Works Webhook or Schedule triggers the flow with a coding task description Task is classified (Generate / Review / Refactor / Optimize) Cursor AI API is called with the appropriate system prompt & task Raw code output is received and parsed A second Cursor pass performs automated code review & scoring If quality score passes threshold → code is committed to GitHub If score is below threshold → Cursor runs an optimization pass Final code + review report saved to Google Drive Summary logged to Google Sheets Slack notification sent with code snippet preview & Drive link 🔧 Configuration Requirements Cursor AI API key** (via Cursor developer access or proxy endpoint) GitHub Personal Access Token** (for auto-commit & PR creation) Google Drive OAuth2** (for storing code files & reports) Google Sheets OAuth2** (for logging task history & quality scores) Slack Bot Token** (for team notifications) Optional: OpenAI API key** (for task classification fallback) 🚀 Setup Guide Import this workflow into your n8n instance Connect all credentials: Cursor API, GitHub, Google Drive, Google Sheets, Slack Open the Set Task Config node and fill in: repo_owner and repo_name (your GitHub target repo) target_branch (e.g. ai-generated or main) quality_threshold (score 0–100, recommended: 75) storage_folder (Google Drive folder name) log_sheet_id (Google Sheets document ID) Test with a manual webhook POST containing { "task": "Write a Python FastAPI CRUD endpoint for users" } Review output in Drive and check Slack notification Activate the webhook for live use Optionally activate the daily schedule for batch processing queued tasks Monitor quality scores in Google Sheets and tune the threshold as needed

Transform college admissions from an overwhelming manual process into an intelligent, efficient, and equitable system that analyzes essays, scores applicants holistically, and identifies top candidates—saving 40+ hours per week while improving decision quality. 🎯 What This Workflow Does Automates comprehensive application review with AI-powered analysis: 📝 Application Intake - Captures complete college applications via Jotform 📚 AI Essay Analysis - Deep analysis of personal statements and supplemental essays for: Writing quality, authenticity, and voice AI-generated content detection Specificity and research quality Red flags (plagiarism, inconsistencies, generic writing) 🎯 Holistic Review AI - Evaluates applicants across five dimensions: Academic strength (GPA, test scores, rigor) Extracurricular profile (leadership, depth, impact) Personal qualities (character, resilience, maturity) Institutional fit (values alignment, contribution potential) Diversity contribution (unique perspectives, experiences) 🚦 Smart Routing - Automatically categorizes and routes applications: Strong Admit (85-100): Slack alert → Director email → Interview invitation → Fast-track Committee Review (65-84): Detailed analysis → Committee discussion → Human decision Standard Review (<65): Acknowledgment → Human verification → Standard timeline 📊 Comprehensive Analytics - All applications logged with scores, recommendations, and outcomes ✨ Key Features AI Essay Analysis Engine Writing Quality Assessment**: Grammar, vocabulary, structure, narrative coherence Authenticity Detection**: Distinguishes genuine voice from AI-generated content (GPT detectors) Content Depth Evaluation**: Self-awareness, insight, maturity, storytelling ability Specificity Scoring**: Generic vs tailored "Why Us" essays with research depth Red Flag Identification**: Plagiarism indicators, privilege blindness, inconsistencies, template writing Thematic Analysis**: Core values, motivations, growth narratives, unique perspectives Holistic Review Scoring (0-100 Scale) Academic Strength (35%)**: GPA in context, test scores, course rigor, intellectual curiosity Extracurricular Profile (25%)**: Quality over quantity, leadership impact, commitment depth Personal Qualities (20%)**: Character, resilience, empathy, authenticity, self-awareness Institutional Fit (15%)**: Values alignment, demonstrated interest, contribution potential Diversity Contribution (5%)**: Unique perspectives, life experiences, background diversity Intelligent Candidate Classification Admit**: Top 15% - clear admit, exceptional across multiple dimensions Strong Maybe**: Top 15-30% - competitive, needs committee discussion Maybe**: Top 30-50% - solid but not standout, waitlist consideration Deny**: Below threshold - does not meet competitive standards (always human-verified) Automated Workflows Priority Candidates**: Immediate Slack alerts, director briefs, interview invitations Committee Cases**: Detailed analysis packets, discussion points, voting workflows Standard Processing**: Professional acknowledgments, timeline communications Interview Scheduling**: Automated invitations with candidate-specific questions 💼 Perfect For Selective Colleges & Universities**: 15-30% acceptance rates, holistic review processes Liberal Arts Colleges**: Emphasis on essays, personal qualities, institutional fit Large Public Universities**: Processing thousands of applications efficiently Graduate Programs**: MBA, law, medical school admissions Scholarship Committees**: Evaluating merit and need-based awards Honors Programs**: Identifying top candidates for selective programs Private High Schools**: Admissions teams with holistic processes 🎓 Admissions Impact Efficiency & Productivity 40-50 hours saved per week** on initial application review 70% faster** essay evaluation with AI pre-analysis 3x more applications** processed per reader Zero data entry** - all information auto-extracted Consistent evaluation** across thousands of applications Same-day turnaround** for top candidate identification Decision Quality Improvements Objective scoring** reduces unconscious bias Consistent criteria** applied to all applicants Essay authenticity checks** catch AI-written applications Holistic view** considers all dimensions equally Data-driven insights** inform committee discussions Fast-track top talent** before competitors Equity & Fairness Standardized evaluation** ensures fair treatment First-generation flagging** provides context Socioeconomic consideration** in holistic scoring Diverse perspectives valued** in diversity score Bias detection** in essay analysis Audit trail** for compliance and review Candidate Experience Instant acknowledgment** of application receipt Professional communication** at every stage Clear timelines** and expectations Interview invitations** for competitive candidates Respectful process** for all applicants regardless of outcome 🔧 What You'll Need Required Integrations Jotform** - Application intake forms Create your form for free on JotForm using this link OpenAI API** - GPT-4o for analysis (~$0.15-0.25 per application) Gmail/Outlook** - Applicant and staff communication (free) Google Sheets** - Application database and analytics (free) Optional Integrations Slack** - Real-time alerts for strong candidates ($0-8/user/month) Google Calendar** - Interview scheduling automation (free) Airtable** - Advanced application tracking (alternative to Sheets) Applicant Portal Integration** - Status updates via API CRM Systems** - Slate, TargetX, Salesforce for higher ed 🚀 Setup Guide (3-4 Hours) Step 1: Create Application Form (60 min) Build comprehensive Jotform with sections: Basic Information Full name, email, phone High school, graduation year Intended major Academic Credentials GPA (weighted/unweighted, scale) SAT score (optional) ACT score (optional) Class rank (if available) Academic honors Essays (Most Important!) Personal statement (650 words max) "Why Our College" essay (250-300 words) Supplemental prompts (program-specific) Activities & Achievements Extracurricular activities (list with hours/week, years) Leadership positions (with descriptions) Honors and awards Community service hours Work experience Additional Information First-generation college student (yes/no) Financial aid needed (yes/no) Optional: demographic information Optional: additional context Step 2: Import n8n Workflow (15 min) Copy JSON from artifact n8n: Workflows → Import → Paste Includes all nodes + 7 detailed sticky notes Step 3: Configure OpenAI API (20 min) Get API key: https://platform.openai.com/api-keys Add to both AI nodes (Essay Analysis + Holistic Review) Model: gpt-4o (best for nuanced analysis) Temperature: 0.3 (consistency with creativity) Test with sample application Cost: $0.15-0.25 per application (essay analysis + holistic review) Step 4: Customize Institutional Context (45 min) Edit AI prompts to reflect YOUR college: In Holistic Review Prompt, Update: College name and type Acceptance rate Average admitted student profile (GPA, test scores) Institutional values and culture Academic programs and strengths What makes your college unique Desired student qualities In Essay Analysis Prompt, Add: Specific programs to look for mentions of Faculty names applicants should reference Campus culture keywords Red flags specific to your institution Step 5: Setup Email Communications (30 min) Connect Gmail/Outlook OAuth Update all recipient addresses: admissions-director@college.edu admissions-committee@college.edu Email addresses for strong candidate alerts Customize email templates: Add college name, logo, branding Update contact information Adjust tone to match institutional voice Include decision release dates Add applicant portal links Step 6: Configure Slack Alerts (15 min, Optional) Create channel: #admissions-strong-candidates Add webhook URL or bot token Test with mock strong candidate Customize alert format and recipients Step 7: Create Admissions Database (30 min) Google Sheet with columns:

Reddit Lead Generator - Frontend Integrated (Productized Version) Overview Production-ready Reddit lead generation system with progressive data loading for optimal UX. This workflow integrates with a web frontend, sending results in real-time as they're processed instead of waiting for everything to complete. Key Features ✅ Progressive Loading - Users see results as they come in (website analysis → keywords → conversations) ✅ 5 Response Stages - Data sent in batches for better UX ✅ Webhook Authentication - Secured with API key headers ✅ Frontend Ready - Built to work with the companion web app ✅ Real-Time Updates - No waiting for 2-minute batch processing What This Workflow Does Receives product URL from frontend via webhook Immediately responds "processing started" Analyzes website with Firecrawl → sends data to frontend Generates 10 keywords with OpenAI → sends to frontend Searches Reddit and filters conversations → sends in 3 batches Frontend displays results progressively as they arrive Response Flow Stage 1: website_analysis - Product details, favicon, summary Stage 2: keywords_generated - All 10 keywords Stage 3: conversations_partial1 - First keyword results Stage 4: conversations_partial2 - Second keyword results Stage 5: conversations_final - Remaining keywords (3-10) in markdown Quick Setup Set Environment Variables in the "Set Environment Variables" node: BACKEND_API_URL - Your frontend API endpoint WEBHOOK_API_KEY - Your webhook security key Configure Credentials: Firecrawl API Reddit OAuth2 OpenAI API Deploy Frontend & Backend: Clone repo: https://github.com/juppfy/leads-gen Deploy frontend on Vercel Deploy backend on Railway Full instructions in the repo README Activate Workflow and update your frontend with the webhook URL Requirements n8n (cloud or self-hosted) Firecrawl API key Reddit Developer Account OpenAI API key Frontend + Backend deployed (see GitHub repo) Resources 📖 Complete Setup Guide: https://bit.ly/mediumarticleredditworkflow 🎥 Video Tutorial: https://bit.ly/youtubetutorialredditworkflow 💻 GitHub Repo: https://github.com/juppfy/leads-gen Frontend Integration This workflow requires the companion web app to receive and display results. The frontend handles: User input and URL validation Real-time result display Conversation cards with pagination Request tracking by searchId Deploy instructions and complete code available in the GitHub repo above. Difference from Batch Version This Version (Frontend): Progressive data loading Real-time updates Production-ready UX Requires frontend deployment Batch Version: Single output at end No frontend needed Perfect for testing/scheduled runs Simpler setup Support Questions? Check the Medium article or YouTube tutorial first. Both have detailed setup instructions and troubleshooting tips.

📊 Description Automate your client proposal creation with this intelligent workflow that transforms Google Sheets entries into professional Google Docs proposals using OpenAI GPT-4o. Designed for agencies and sales teams, it delivers personalized, branded, and structured proposals in minutes — no manual editing required. 🚀📄🤖 What This Template Does Triggers when a new row is added in a connected Google Sheet. 📋 Filters only the latest row to ensure one proposal per new entry. 🔍 Uses GPT-4o to generate structured proposal content (Executive Summary, Scope, Costing, Timeline, Conclusion). 💡 Parses output into validated JSON format for accurate field mapping. ⚙️ Populates a Google Docs template with AI-generated content using placeholders. 📝 Downloads the completed proposal as a PDF file. 💾 Archives the finalized document into a designated Google Drive folder. 📂 Resets the template for the next proposal cycle automatically. 🔄 Key Benefits ✅ Eliminates repetitive manual proposal writing. ✅ Ensures brand consistency with structured templates. ✅ Generates high-quality proposals using AI in real time. ✅ Automates document formatting, saving hours per client. ✅ Scales easily for agencies handling multiple clients daily. Features Google Sheets trigger for new entries. GPT-4o-based content generation with customizable prompts. JSON output validation and structured parsing. Google Docs population using placeholder replacement. Drive storage automation for version tracking. End-to-end automation from data to proposal delivery. Requirements Google Sheets document with columns: clientName, jobDescription. Google Docs template with placeholders (e.g., {{executive_summary}}, {{scope_of_work}}). OpenAI API key (GPT-4o). Google Drive credentials for output management. Target Audience Marketing and web agencies automating client proposal generation. Sales teams preparing project estimates and deliverables. Freelancers and consultants managing multiple client requests. Businesses streamlining documentation workflows. Step-by-Step Setup Instructions Connect Google Sheets and replace the Sheet ID placeholder. Set up your Google Docs proposal template and replace the Document ID. Add your OpenAI API key for GPT-4o content generation. Specify your Google Drive folder for saving proposals. Test the workflow with a sample entry to confirm formatting. Activate the workflow for continuous proposal generation. ✅

This workflow is built for digital marketers, sales professionals, influencer agencies, and entrepreneurs who want to automate Instagram lead generation. If you’re tired of manually searching for profiles, copying email addresses, and updating spreadsheets, this automation will save you hours every week. It turns your process into a smart system that finds, extracts, and stores leads while you focus on growing your business. How it works / What it does This n8n automation completely transforms how you collect Instagram leads using AI and API integrations. Here’s a simple breakdown of how it works: Set your targeting parameters using the Edit Fields node. You can specify your platform (Instagram), field of interest such as “beauty & hair,” and target country like “USA.” Generate intelligent search queries with an AI Agent powered by GPT-4o-mini. It automatically creates optimized Google search queries to find relevant Instagram profiles in your chosen niche and location. Extract results from Google using Apify’s Google Search Scraper, which collects hundreds of Instagram profile URLs that match your search criteria. Fetch detailed Instagram profile data using Apify’s Instagram Scraper. This includes usernames, follower counts, and profile bios where contact information usually appears. Use AI to extract emails from the profile biographies with the Information Extractor node powered by GPT-3.5-turbo. It identifies emails even when they are hidden or creatively formatted. Store verified leads in a PostgreSQL database. The workflow automatically adds new leads or updates existing ones with fields like username, follower count, email, and niche. Once everything is set up, the system runs on autopilot and keeps building your database of quality leads around the clock. How to set up Follow these steps to get your Instagram Lead Generation Machine running: Import the JSON file into your n8n instance. Add your API credentials: Apify token for the Google and Instagram scrapers OpenAI API key for the AI-powered nodes PostgreSQL credentials for storing leads Open the Edit Fields node and set your platform, field of interest, and target country. Run the workflow manually using the Manual Trigger node to test it. Once confirmed, replace the manual trigger with a schedule or webhook to run it automatically. Check your PostgreSQL database to ensure the leads are being saved correctly. Requirements Before running the workflow, make sure you have the following: An n8n account or instance (self-hosted or n8n Cloud) An Apify account for accessing the Google and Instagram scrapers OpenAI API access for generating smart search queries and extracting emails A PostgreSQL database to store your leads Basic understanding of how n8n workflows and nodes operate How to customize the workflow This workflow is flexible and can be customized to fit your business goals. Here’s how you can tailor it: Change your niche or location by updating the Edit Fields node. You can switch from “beauty influencers in the USA” to “fitness coaches in Canada” in seconds. Add more data fields to collect additional information such as engagement rates, bio keywords, or profile categories. Just modify the PostgreSQL node and database schema. Connect to your CRM or email system to automatically send introduction emails or add new leads to your marketing pipeline. Use different triggers such as a scheduled cron trigger for daily runs or a webhook trigger to start the workflow through an API call. Filter higher-quality leads by adding logic to capture only profiles with a minimum number of followers or verified emails.

How it Works This workflow transforms natural language queries into research reports through a five-stage AI pipeline. When triggered via webhook (typically from Google Sheets using the companion google-apps-script.js (GitHub gist), it first checks Redis cache for instant results. For new queries, GPT-4o breaks complex questions into focused sub-queries, optimizes them for search, then uses Bright Data's MCP Tool to find the top 5 credible sources (official sites, news, financial reports). URLs are scraped in parallel, bypassing bot detection. GPT-4o extracts structured data from each source: answers, facts, entities, sentiment, quotes, and dates. GPT-4o-mini validates source credibility and filters unreliable content. Valid results aggregate into a final summary with confidence scores, key insights, and extended analysis. Results cache for 1 hour and output via webhook, Slack, email, and DataTable—all in 30-90 seconds with 60 requests/minute rate limiting. Who is this for? Research teams needing automated multi-source intelligence Content creators and journalists requiring fact-checked information Due diligence professionals conducting competitive intelligence Google Sheets power users wanting AI research in spreadsheets Teams managing large research volumes needing caching and rate limiting Setup Steps Setup time: 30-45 minutes Requirements: Bright Data account (Web Scraping API + MCP token) OpenAI API key (GPT-4o and GPT-4o-mini access) Redis instance Slack workspace (optional) SMTP email provider (optional) Google account (optional for Sheets integration) Core Setup: Get Bright Data Web Scraping API token and MCP token Get OpenAI API key Set up Redis instance Configure critical nodes: Webhook Entry: Add Header Auth token Bright Data MCP Tool: Add MCP endpoint with token Parallel Web Scraping: Add Bright Data API credentials Redis Nodes: Add connection credentials All GPT Nodes: Add OpenAI API key (5 nodes) Slack/Email: Add credentials if using Google Sheets Integration: Create Google Sheet Open Extensions → Apps Script Paste the companion google-apps-script.js code Update webhook URL and auth token Save and authorize Test: {"prompt": "What is the population of Tokyo?", "source": "Test", "language": "English"} Customization Guidance Source Count:** Change from 5 to 3-10 URLs per query Cache Duration:** Adjust from 1 hour to 24 hours for stable info Rate Limits:** Modify 60/minute based on usage needs Character Limits:** Adjust 400-char main answer to 200-1000 AI Models:** Swap GPT-4o for Claude or use GPT-4o-mini for all stages Geographic Targeting:** Add more regions beyond us/il Output Channels:** Add Notion, Airtable, Discord, Teams Temperature:** Lower (0.1-0.2) for facts, higher (0.4-0.6) for analysis Once configured, this workflow handles all web research, from fact-checking to complex analysis—delivering validated intelligence in seconds with automatic caching. Built by Daniel Shashko Connect on LinkedIn

A Telegram bot that converts natural-language work descriptions into detailed cost estimates using AI parsing, vector search, and the open-source DDC CWICR database with 55,000+ construction work items. Who's it for Contractors & Estimators** who need quick ballpark figures from verbal/text descriptions Construction managers** doing feasibility checks on-site via mobile BIM/CAD professionals** integrating text-based estimation into workflows Developers** building construction cost APIs or chatbots What it does Receives text messages in Telegram (work lists, specifications, notes) Parses input with AI (OpenAI/Claude/Gemini) into structured work items Searches DDC CWICR vector database via Qdrant for matching rates Calculates costs with full breakdown (labor, materials, machines) Exports results as HTML report, Excel, or PDF Supports 9 languages: 🇩🇪 DE · 🇬🇧 EN · 🇷🇺 RU · 🇪🇸 ES · 🇫🇷 FR · 🇧🇷 PT · 🇨🇳 ZH · 🇦🇪 AR · 🇮🇳 HI How it works ┌─────────────┐ ┌──────────────┐ ┌─────────────┐ ┌──────────────┐ │ Telegram │ → │ AI Parse │ → │ Embeddings │ → │ Qdrant │ │ Text Input │ │ (GPT/Claude)│ │ (OpenAI) │ │ Search │ └─────────────┘ └──────────────┘ └─────────────┘ └──────────────┘ ↓ ┌─────────────┐ ┌──────────────┐ ┌─────────────┐ ┌──────────────┐ │ Export │ ← │ Aggregate │ ← │ Calculate │ ← │ AI Rerank │ │ HTML/XLS/PDF│ │ Results │ │ Costs │ │ Results │ └─────────────┘ └──────────────┘ └─────────────┘ └──────────────┘ Step-by-step: User sends /start → selects language → enters work description AI Parse extracts work items: name, quantity, unit, room Query Transform optimizes search terms for construction domain Embeddings API converts query to vector (OpenAI text-embedding-3-small) Qdrant Search finds top-10 matching rates from DDC CWICR AI Rerank selects best match considering context and units Calculate applies quantities, sums labor/materials/machines Report sends Telegram message + optional Excel/PDF export Prerequisites | Component | Requirement | |-----------|-------------| | n8n | v1.30+ (AI nodes support) | | Telegram Bot | Token from @BotFather | | OpenAI API | For embeddings + LLM parsing | | Qdrant | Vector DB with DDC CWICR collections loaded | | DDC CWICR Data | github.com/datadrivenconstruction/DDC-CWICR | Setup 1. Credentials (n8n Settings → Credentials) OpenAI API** — required for embeddings and text parsing Anthropic API** — optional, for Claude models Google Gemini API** — optional, for Gemini models 2. Configuration (🔑 TOKEN node) bot_token = YOUR_TELEGRAM_BOT_TOKEN QDRANT_URL = http://localhost:6333 QDRANT_API_KEY = (if using Qdrant Cloud) 3. Qdrant Setup Load DDC CWICR collections for your target languages: DE_construction_rates — German (STLB-Bau based) EN_construction_rates — English RU_construction_rates — Russian (GESN/FER based) ... (see DDC CWICR docs for all 9 languages) 4. Link AI Model Nodes Open OpenAI Model nodes Select your OpenAI credential (Optional) Enable Claude/Gemini nodes for alternative models 5. Telegram Webhook Activate workflow Telegram Trigger auto-registers webhook Test with /start in your bot Features | Feature | Description | |---------|-------------| | 🤖 Multi-LLM | Swap between OpenAI, Claude, Gemini | | 🌍 9 Languages | Full UI + database localization | | 📝 Smart Parsing | Handles lists, tables, free-form text | | 🔍 Semantic Search | Vector similarity + AI reranking | | 📊 Cost Breakdown | Labor, materials, machines, hours | | ✏️ Inline Edit | Modify quantities, delete items | | 📤 Export | HTML report, Excel, PDF | | 💾 Session State | Multi-turn conversation support | Example Input/Output Input (Telegram message): Living room renovation: Laminate flooring 25 m² Wall painting 60 m² Ceiling plasterboard 25 m² 3 electrical outlets Output: ✅ Estimate Ready — 4 items found Laminate flooring ✓ 25 m² × €18.50 = €462.50 └ Labor: €125 · Materials: €337.50 Wall painting ✓ 60 m² × €8.20 = €492.00 └ Labor: €312 · Materials: €180 Ceiling plasterboard ✓ 25 m² × €32.00 = €800.00 └ Labor: €425 · Materials: €375 Electrical outlets ✓ 3 pcs × €45.00 = €135.00 └ Labor: €95 · Materials: €40 ───────────────────── Total: €1,889.50 [↓ Excel] [↓ PDF] [↻ Restart] Notes & Tips First run:** Ensure Qdrant has DDC CWICR data loaded before testing Rate accuracy:** Results depend on query quality; AI reranking improves matching Large lists:** Bot handles 50+ items; progress shown per-item Customization:** Edit Config node for UI text, currencies, database mapping Extend:** Chain with your CRM, project management, or reporting tools Categories AI · Data Extraction · Communication · Files & Storage Tags telegram-bot, construction, cost-estimation, qdrant, vector-search, openai, multilingual, bim, cad Author DataDrivenConstruction.io https://DataDrivenConstruction.io info@datadrivenconstruction.io Consulting & Training We help construction, engineering, and technology firms implement: Open data principles for construction CAD/BIM processing automation AI-powered estimation pipelines ETL workflows for construction databases Contact us to test with your data or adapt to your project requirements. Resources DDC CWICR Database:** GitHub Qdrant Setup Guide:** qdrant.tech/documentation n8n AI Nodes:** docs.n8n.io/integrations/builtin/cluster-nodes/root-nodes/n8n-nodes-langchain ⭐ Star us on GitHub! github.com/datadrivenconstruction/DDC-CWICR

This workflow automates the process of turning meeting recordings into structured notes and actionable tasks using AssemblyAI and Google Sheets. It is ideal for teams who want to save time on manual note-taking and ensure that action items from meetings are never missed. What it does Receives a meeting recording (audio file) via webhook Transcribes the audio using AssemblyAI Uses AI to generate structured meeting notes and extract action items (tasks) Logs meeting details and action items to a Google Sheet for easy tracking Use cases Automatically document meetings and share notes with your team Track action items and responsibilities from every meeting Centralize meeting outcomes and tasks in Google Sheets Quick Setup AssemblyAI API Key: Sign up at AssemblyAI and get your API key. Google Sheets Credentials: Set up a Google Service Account and share your target Google Sheet with the service account email. OpenAI API Key (optional, if using OpenAI for notes extraction): Get your API key from OpenAI. Configure the following essential nodes: Recording Ready Webhook: Set the webhook URL in your meeting platform to trigger the workflow when a recording is ready. Workflow Configuration: Enter your AssemblyAI API key, default due date, and admin email. AssemblyAI Transcription: Add your AssemblyAI API key in the credentials. Generate Meeting Notes & Extract Action Items: Add your OpenAI API key if required. Log Meeting to Sheets: Enter your Google Sheets document ID and sheet name. How to Use AssemblyAI in this Workflow The workflow sends the meeting audio file to AssemblyAI via the AssemblyAI Transcription node. AssemblyAI processes the audio and returns a full transcript. The transcript is then used by AI nodes to generate meeting notes and extract action items. Requirements AssemblyAI API key Google Service Account credentials (Optional) OpenAI API key for advanced note and action item extraction Start the workflow by sending a meeting recording to the webhook URL. The rest is fully automated!

Transform meeting transcripts into fully customized, AI-powered presentations automatically. This comprehensive 5-workflow automation system analyzes client conversations and generates professional slide decks complete with personalized content and AI-generated illustrations. 🎯 What This Automation Does This end-to-end solution takes a meeting transcript (Google Docs) and client information as input, then automatically: Creates a presentation from your custom template Generates a strategic presentation plan tailored to the client's needs Creates custom illustrations using AI image generation Populates slides with personalized text content Inserts generated images into the appropriate slides Delivers a client-ready presentation Perfect for sales teams, consultants, agencies, and anyone who needs to create customized presentations at scale. 🔧 How It Works The automation is split into 5 interconnected workflows: Workflow 1: Clone Presentation & Database Setup Form trigger captures client name, transcript URL, and submission time Clones your presentation template via Google Slides API Saves presentation details to Google Sheets for tracking Workflow 2: AI Presentation Plan Generation Analyzes meeting transcript to understand client pain points Generates comprehensive presentation structure and content strategy Saves plan to Google Docs for review and tracking Uses company profile (customizable) to match solutions to client needs Workflow 3: AI Illustration Generation AI agent creates image prompts based on presentation plan Generates illustrations using Flux model via OpenRouter (nanobanana) Uploads images to Google Drive for slide insertion Tracks all generated assets in database Workflow 4: Text Content Population AI agent generates final presentation text from the plan Replaces template placeholders with personalized content Uses Object IDs to target specific text elements in slides Updates slides using native n8n Google Slides node Workflow 5: Image Insertion Retrieves image Object IDs from presentation structure Downloads illustrations from Google Drive Converts images for ImgBB hosting (resolves Google Drive URL limitations) Updates slide images via Google Slides API 📋 Prerequisites Required Accounts & API Keys: Google Workspace (Drive, Slides, Docs) OpenAI API (for AI agents) OpenRouter API (for Flux image generation) ImgBB API (free tier available) Gemini API (optional, for additional AI tasks) Setup Requirements: Google Sheets database (template provided in article and inside the workflow) Google Slides presentation template with standard Object IDs Meeting transcript in Google Docs format 🎨 Customization Options This automation is designed to be flexible: Template Flexibility**: Use any slide template structure Company Profile**: Customize the business context for your use case AI Models**: Swap OpenAI/Gemini agents for your preferred LLM Image Generation**: Replace Flux with DALL-E, Midjourney API, or other models Slide Logic**: Extend to dynamically select slides based on content needs 💡 Key Technical Insights Structured Output Handling**: Uses JavaScript for reliable JSON parsing when AI output structure is complex Object ID System**: Template placeholders use unique IDs for precise element targeting Image Hosting Workaround**: ImgBB resolves Google Drive direct URL limitations in API calls HTTP Request Nodes**: Used for API operations not covered by native n8n nodes (copying presentations, image updates) 🔗 Full Documentation For a detailed breakdown of each workflow, configuration steps, and best practices, read the complete guide on this Medium article 🚀 Use Cases Sales Teams**: Auto-generate pitch decks from discovery calls Consulting Firms**: Create client proposals from needs assessments Marketing Agencies**: Build campaign presentations from strategy sessions Product Teams**: Transform user research into stakeholder presentations Training & Education**: Convert session notes into learning materials ⚠️ Important Notes Template must use consistent Object IDs for automation to work Google Drive images require ImgBB hosting for reliable URL access AI agent output structure is complex; JavaScript parsing recommended Rate limits apply for API services (especially image generation) 📦 Resources & Templates API Services (Get Your Keys Here) OpenRouter** - For Flux (nanobanana) AI image generation ImgBB API** - Free image hosting service OpenAI API** - For AI agents and text generation Google Cloud Console** - Enable Google Slides, Drive, and Docs APIs Google AI Studio** - For Gemini API key Templates & Examples Meeting Transcript Sample** - Example transcript structure Google Sheets Database Template** - Copy this to track your presentations Presentation Template** - Base slide deck with Object IDs 💡 Tip: Make copies of all templates before using them in your workflows! Have questions or improvements? Connect with me: X (Twitter): @juppfy Email: joseph@uppfy.com P.S: I'd love to hear how you adapt this for your workflow!

This n8n template turns chat questions into structured financial reports using Gemini and posts them to a Discord channel via webhook. Ask about tickers, sectors, or theses (e.g., “NVDA long‑term outlook?” or “Gold ETF short‑term drivers?”) and receive a concise, shareable report. Good to know Not financial advice: Use for insights only; verify independently. Model availability can vary by region. If you see “model not found,” it may be geo‑restricted. Costs depend on model and tokens. Check current Gemini pricing for updates. Discord messages are limited to ~2000 characters per post; long reports may need splitting. Rate limits: Discord webhooks are rate‑limited; add short waits for bursts. How it works Chat Trigger collects the user’s question (public chat supported when the workflow is activated). Conversation Memory keeps a short window of recent messages to maintain context. Connect Gemini provides the LLM (e.g., gemini‑2.5‑flash‑lite) and parameters (temperature, tokens). Agent (agent1) applies a financial analysis System Message to produce structured insights. Structured Output Parser enforces a simple JSON schema: idea (one‑line thesis) + analysis (Markdown sections). Code formats a Discord‑ready Markdown report (title, question, executive summary, sections, disclaimer). Edit Fields maps the formatted report to a clean content field. Discord Webhook posts the final report to your channel. How to use Start with the built‑in Chat Trigger: click Open chat, ask a question, and verify the Discord post. Replace or augment with a Cron or Webhook trigger for scheduled or programmatic runs. For richer context, add HTTP Request nodes (prices, news, filings) and pass summaries to the agent. Requirements n8n instance with internet access Google AI (Gemini) API key Discord server with a webhook URL Customising this workflow System Message: Adjust tone, depth, risk profile, and required sections (Summary, Drivers, Risks, Metrics, Next Steps, Takeaway). Model settings: Switch models or tune temperature/tokens in Connect Gemini. Schema: Extend the parser and formatter with fields like drivers[], risks[], or metrics{}. Formatting: Edit the Code node to change headings, emojis, disclaimers, or add timestamps. Operations: Add retries, message splitting for long outputs, and rate‑limit handling for Discord.