Workflow Templates

Who’s it for This template is for clinics, hospitals, care teams, and telemedicine providers who need a structured, automated system for post-surgery follow-up. It helps reduce manual workload while ensuring every patient gets timely check-ins and appropriate triage. What it does / How it works This workflow automates daily recovery monitoring using Google Sheets and Telegram. It sends scheduled check-in messages to all patients within their follow-up window. When a patient replies, the message is: Captured by Telegram Trigger Cleaned and structured Summarized by an AI agent Classified into low, moderate, or high intensity Based on the intensity level: Low:** Sends a supportive, non-urgent response Moderate:** Sends guidance + schedules a follow-up event in Google Calendar High:** Sends an alert email to the doctor via Gmail All logic runs automatically. Requirements Google Sheets OAuth2 credentials Gmail OAuth2 credentials Google Calendar OAuth2 credentials Telegram Bot credentials Gemini API credentials A Google Sheet with patient name, surgery type, follow-up duration, and doctor email How to set up Connect all required credentials inside n8n. Replace the Google Sheet ID with your own patient sheet. Adjust column mappings if your sheet structure differs. Test by sending a Telegram message to your bot. Enable the Schedule Trigger to begin automated daily follow-ups. How to customize the workflow Modify AI prompts inside the AI Agent nodes Adjust triage logic for intensity levels Change follow-up intervals in the Schedule Trigger Add additional notification channels (SMS, Slack, CRM logging)

This n8n workflow automates the monitoring, health assessment, and self-healing of AWS EC2 instances in production environments. It runs periodic checks, identifies unhealthy instances based on status and metrics, restarts them automatically, and notifies teams via multi-channel alerts while logging data for auditing and reporting. Key Features Triggers health checks every 5 minutes to proactively monitor EC2 fleet status. Fetches and loops through all production EC2 instances for individualized analysis. Evaluates instance health using AWS metrics and custom thresholds to detect issues like high CPU or stopped states. Performs automatic restarts on unhealthy instances to minimize downtime. Sends instant WhatsApp notifications for urgent alerts, detailed email reports for team review, and logs metrics to Google Sheets for long-term tracking. Includes sticky notes for quick reference on configuration, self-healing logic, and alert setup. Workflow Process The Schedule Trigger node runs the workflow every 5 minutes, ensuring frequent health monitoring without overwhelming AWS APIs. The Get EC2 Instances node fetches all production-tagged EC2 instances from AWS, filtering by environment (e.g., tag: Environment=Production). The Loop Over Instances node iterates through each fetched instance individually, allowing parallel processing for scalability. The Check Instance Status node retrieves detailed health metrics for the current instance via AWS API (e.g., status checks, CPU utilization, and state). The Health Status Check node evaluates the instance's status against predefined thresholds (e.g., failed system checks or high load); if healthy, it skips to logging. The Analyze Health Data node assesses metrics in depth to determine action (e.g., restart if CPU > 90% for 5+ minutes) and prepares alert payloads. The Restart Instance node automatically initiates a reboot on unhealthy instances using AWS EC2 API, with optional dry-run mode for testing. The WhatsApp Notification node (part of Multi-Channel Alerts) sends instant alerts via Twilio WhatsApp API, including instance ID, issue summary, and restart status. The Email Report node generates and sends a detailed HTML report to the team via SMTP, summarizing checked instances, actions taken, and metrics trends. The Google Sheets Logging node appends health data, timestamps, and outcomes to a specified spreadsheet for historical analysis and dashboards. The Sticky Notes nodes provide inline documentation: one for AWS credential setup, one explaining self-healing thresholds, and one for alert channel configurations. Setup Instructions Import the workflow into n8n and activate the Schedule Trigger with a 5-minute cron expression (e.g., */5 * * * *). Configure AWS credentials in the Get EC2 Instances, Check Instance Status, and Restart Instance nodes using IAM roles with EC2 read/restart permissions. Set up Twilio credentials in the WhatsApp Notification node, including your Twilio SID, auth token, and WhatsApp-enabled phone numbers for sender/receiver. Add SMTP credentials (e.g., Gmail or AWS SES) in the Email Report node, and update sender/receiver email addresses in the node parameters. Link Google Sheets in the Google Sheets Logging node by providing the spreadsheet ID, sheet name, and OAuth credentials for write access. Customize health thresholds in Health Status Check and Analyze Health Data (e.g., via expressions for CPU/memory limits). Test the workflow by manually executing it on a small set of instances and verifying alerts/logging before enabling production scheduling. Review sticky notes within n8n for quick tips, and monitor executions in the dashboard to fine-tune intervals or error handling. Prerequisites AWS account with EC2 access and IAM user/role for DescribeInstances, DescribeInstanceStatus, and RebootInstances actions. Twilio account with WhatsApp sandbox or approved number for notifications. SMTP email service (e.g., Gmail, Outlook) with app-specific passwords enabled. Google Workspace or personal Google account for Sheets integration. n8n instance with AWS, Twilio, SMTP, and Google Sheets nodes installed (cloud or self-hosted). Production EC2 instances tagged consistently (e.g., Environment=Production) for filtering. Modification Options Adjust the Schedule Trigger interval to hourly for less frequent checks or integrate with AWS CloudWatch Events for dynamic triggering. Expand Analyze Health Data to include advanced metrics (e.g., disk I/O via CloudWatch) or ML-based anomaly detection. Add more alert channels in Multi-Channel Alerts, such as Slack webhooks or PagerDuty integrations, by duplicating the WhatsApp/Email branches. Enhance Google Sheets Logging with charts or conditional formatting via Google Apps Script for visual dashboards. Implement approval gates in Restart Instance (e.g., via email confirmation) to prevent auto-restarts in sensitive environments. Explore More AI Workflows: Get in touch with us for custom n8n automation!

Turn your sales and onboarding calls into actionable insights — automatically! This workflow connects Fireflies.ai with OpenAI to analyze and grade your call transcripts. The results, along with your lead’s details, are logged directly into a Google Sheet for easy tracking. Plus, you’ll get an instant Slack or Gmail notification with the evaluation so you can take quick action. 🚀 What It Does Triggers on new Fireflies.ai transcripts** Uses AI to evaluate and grade your calls** Logs lead + scoring data into Google Sheets** Sends instant updates via Slack or Gmail** 💡 Why It’s Valuable Save hours of manual call reviews Keep a consistent, unbiased scoring system Centralize data for reporting and coaching Act faster with real-time notifications Perfect for sales, onboarding, or customer success teams who want to improve call quality at scale while saving time. 🛠️ Setup Instructions Connect Fireflies.ai – Enable transcript export from your Fireflies.ai account. Integrate with OpenAI – Use the provided API key to analyze and score transcripts automatically. Configure Google Sheets – Create a sheet with columns for: Lead Name Company Call Date Transcript Link AI Score Notes/Insights Enable Notifications – Connect Slack or Gmail to receive instant alerts with evaluation details. Test & Launch – Run a sample call to ensure transcripts flow correctly into the sheet and notifications are triggered. 🔄 Detailed Workflow A new call transcript is generated in Fireflies.ai. The transcript is sent to OpenAI, where the call is evaluated and scored based on quality, engagement, and outcomes. The results + lead data are logged automatically into Google Sheets for centralized tracking. A Slack or Gmail notification instantly alerts your team with the score and key insights, so you can take immediate action. 📊 Google Sheets Your Google Sheet should include the following columns: Lead Name** Email/Contact** Company Name** Call Date & Time** Transcript URL** AI Evaluation Score** Summary/Next Steps** This structure ensures clarity, easy reporting, and consistent data across all calls. ⚠️ Community Node Disclaimer This workflow is created with community nodes and integrations. Please review security and API key management best practices before deploying in production. 🖼️ Workflow Template

Stay Updated on Website Changes Automatically Manually checking websites for updates or competitor changes can be tedious. This workflow automates the process by scraping target pages, capturing screenshots, and analyzing content changes using Firecrawl and GPT-5-mini. All updates are saved in Notion, and you can optionally receive email alerts — keeping you informed without lifting a finger. Key Features Automated Website Monitoring** Tracks changes on multiple target URLs on a daily schedule. Visual & Text-Based Updates** Captures screenshots and generates concise text summaries for each change. Notion Integration** Stores snapshots, comparisons, and summaries directly in Notion for easy reference. GPT-Powered Comparison** Highlights meaningful changes between snapshots using GPT-5-mini. Change Criteria Input** Define what type of updates matter to you — focus on specific content changes or ignore minor differences. Email Alerts via Gmail** Sends notifications when updates occur, so you never miss important changes. Reusable Notion Page Template** Includes a structured template for consistent tracking and reporting: View Template Email Updates: Notion Page Template: Notion Update Example: Setup Instructions 1. Add Target URLs Paste one or more websites you want to monitor. The workflow accepts multiple URLs in JSON format for scalable tracking. 2. Setup Firecrawl Credential Use Firecrawl to scrape website data without dealing with complex API setups. Steps: Go to firecrawl.dev/app and sign up. Copy your API Key from the dashboard. In n8n, open the Firecrawl node, add a new credential, and paste the key. Test the node to ensure the connection works. 3. Setup OpenAI API Key The workflow uses GPT-5-mini to analyze and summarize website changes. Steps: Sign up at OpenAI if you haven’t already. Generate a new API Key in your OpenAI dashboard. In n8n, open the GPT node, add a new credential, and paste the API key. Test the node to ensure it can successfully call the API. 4. Setup Gmail for Email Alerts In n8n, open the Gmail node. Click Add New Credentials and select OAuth2. Follow the Google OAuth setup to allow n8n to send emails on your behalf. Choose the recipient and customize the alert formatting to include snapshots and summaries. 5. Configure the Workflow Import the workflow into n8n. Add your target URLs in JSON format. Paste your Firecrawl API Key into the Firecrawl node. Add your OpenAI API key to the GPT node. Authenticate Gmail if email notifications are desired. Set your preferred change criteria to filter meaningful updates. Adjust the schedule for daily execution or your preferred frequency. How It Works Schedule Trigger: Runs daily or on-demand. Fetch Pages: Scrapes target websites using Firecrawl. Capture & Compare: Screenshots and text are stored and compared using GPT-5-mini. Apply Change Criteria: Only updates that meet your defined criteria are logged. Save Updates: Changes are stored in Notion with visual and text summaries. Optional Alerts: Sends Gmail notifications with updates. Example Use Cases Monitor competitor websites for product, pricing, or design changes. Track updates on blogs, documentation, or landing pages. Automatically log changes for research, reporting, or team awareness. Get notified instantly when key pages are updated. Requirements | Tool | Purpose | |------|----------| | Firecrawl API Key | Scrape website content | | OpenAI API Key | Generate summaries and compare changes with GPT-5-mini | | n8n | Run and schedule the automation | | Notion | Store snapshots, summaries, and comparisons | | Gmail (OAuth2) | Send alert emails | Have questions about this template? Feel free to reach out. Our DMs are always open! Email: hello@scoutnow.app X (Twitter): @ScoutNowApp

Transform new hire onboarding from 3-4 hours of manual document compilation to 3 minutes of automated generation - creates personalized, role-specific document packages including welcome letters, benefits guides, IT setup instructions, and required forms, all branded and delivered with complete tracking. What This Workflow Does Revolutionizes employee onboarding with intelligent document generation, role-based customization, and automated delivery workflows: Webhook-Triggered Generation** - Automatically creates complete onboarding packages when new hires accept offers or from HR system triggers Smart Data Validation** - Verifies employee information, validates email addresses, generates employee IDs, and enriches data with company defaults Role-Based Customization** - Automatically detects job requirements and customizes documents for technical roles, management positions, or sales functions Department-Specific Details** - Populates office floor, dress code, parking assignments, and team information based on department Welcome Letter Generation** - Creates personalized welcome letters with start date details, first-day instructions, manager information, and what to bring Comprehensive Benefits Guide** - Generates detailed enrollment guides covering health insurance, dental, vision, 401(k), PTO, disability, and life insurance options IT Setup Instructions** - Produces role-specific IT guides with equipment lists, software access, network configuration, and security requirements Required Forms Package** - Creates emergency contact forms and direct deposit authorization with signature fields and document checklists Parallel Document Generation** - Simultaneously generates multiple documents for faster processing and efficiency Batch PDF Conversion** - Converts all HTML documents to professional, print-ready PDFs in one workflow execution Organized Drive Storage** - Creates employee-specific folders and archives all documents with systematic naming conventions Document Aggregation** - Collects all generated PDFs and prepares them as email attachments for delivery Automated Email Delivery** - Sends complete onboarding package to new hire with action items and first-day instructions HR System Integration** - Logs document generation, tracks completion status, manages signature requirements, and maintains audit trails Slack Team Notifications** - Alerts HR team when onboarding packages are successfully delivered with employee details Benefits Eligibility Logic** - Automatically determines benefits eligibility based on employment type and calculates enrollment start dates Signature Tracking** - Monitors which forms require signatures and tracks completion deadlines Key Features Intelligent Role Detection**: Automatically identifies technical roles requiring IT equipment, management positions needing leadership training, and sales roles requiring CRM access Equipment Allocation Logic**: Generates different equipment packages based on role (MacBook Pro for developers vs standard laptop for other roles) Employment Type Handling**: Differentiates between full-time, part-time, and contractor status affecting benefits eligibility and documentation Manager Information Auto-Population**: Pulls reporting structure, manager contact details, and department leadership information Benefits Start Date Calculation**: Automatically computes benefits eligibility dates (typically 30 days after start date) with formatted display Office Location Mapping**: Maps departments to specific floors, dress codes, and parking assignments for seamless first-day experience Dynamic Form Generation**: Creates fillable forms with proper spacing, signature lines, and checkbox fields for manual completion Multi-Document Packaging**: Generates 4+ separate documents covering welcome, benefits, IT setup, and compliance requirements Professional HTML Templates**: Beautifully designed documents with company branding, color-coded sections, and modern layouts Document Versioning**: Includes employee ID, generation timestamp, and unique document pack IDs for version control Email Action Items**: Summarizes required actions with deadlines, what to bring on first day, and pre-start preparation checklist Emergency Contact Management**: Collects primary and secondary emergency contacts with full contact information requirements Direct Deposit Authorization**: Provides bank account forms supporting primary and secondary accounts with percentage or fixed amount splits IT Security Compliance**: Documents mandatory security requirements including MFA setup, VPN configuration, and password policies Benefits Options Breakdown**: Details multiple plan options (PPO, HMO, HDHP) with premium costs and coverage comparisons Folder Organization System**: Creates hierarchical folder structure organizing documents by employee ID and full name Perfect For HR Departments** - Streamline new hire paperwork and reduce manual document preparation time Growing Companies** - Scale onboarding processes without proportionally increasing HR headcount Remote-First Organizations** - Deliver complete onboarding packages to distributed employees electronically Compliance-Focused Industries** - Maintain audit trails and ensure all required documentation is generated and tracked Companies with Complex Benefits** - Clearly communicate multiple benefit options with enrollment guidance IT-Heavy Organizations** - Provide detailed technical setup instructions for equipment and system access Multi-Department Enterprises** - Customize onboarding based on department, role, and location requirements Regulated Industries** - Ensure consistent documentation and signature tracking for compliance requirements What You Will Need Required Integrations HTML to PDF API** - PDF conversion service for professional document generation (approximately 1-5 cents per document) Gmail or SMTP** - Email delivery service for sending onboarding packages to new hires Google Drive** - Cloud storage for document archival and HR record-keeping Optional Integrations Slack Webhook** - HR team notifications when onboarding packages are delivered HR Management System** - HRIS integration for automatic logging and status tracking (BambooHR, Workday, ADP) DocuSign/HelloSign** - E-signature integration for digital form completion and signature collection Benefits Administration** - Connect to benefits platforms for enrollment link generation Applicant Tracking System** - Trigger workflow when candidates accept offers (Greenhouse, Lever, Jobvite) Employee Directory** - Sync employee data with directory systems (Okta, Azure AD) Quick Start Import Template - Copy JSON workflow and import into your n8n instance Configure PDF Service - Add HTML to PDF API credentials in the Convert to PDF node Setup Gmail - Connect Gmail OAuth2 credentials and update sender email address Connect Google Drive - Add Google Drive OAuth2 credentials and configure base folder path Customize Company Info - Edit validation node with your company name, address, website, and contact details Update HR Contact - Modify HR department name, email, and phone number in enrichment logic Configure Department Info - Adjust department mappings for office floors, dress codes, and parking assignments Customize Benefits - Edit benefits guide with your actual plan options, premiums, and coverage details Set IT Equipment - Modify equipment lists based on actual hardware provided to different roles Update Role Detection - Adjust role-based logic to match your job titles and equipment requirements Configure Email Template - Customize welcome email message with company-specific instructions Add Slack Webhook - Configure Slack notification URL for HR team alerts Test Complete Workflow - Submit sample employee data to verify all documents generate correctly Setup HR System Integration - Replace logging code with actual API calls to your HR platform Customization Options Additional Documents** - Add company policy handbooks, confidentiality agreements, or handbook acknowledgments Multi-Language Support** - Generate documents in multiple languages for international employees Custom Branding** - Add company logos, color schemes, and custom styling to all document templates Conditional Sections** - Show/hide document sections based on employment type, location, or department Variable Pay Structures** - Include salary information, bonus structure, or commission plans in welcome letters Onboarding Schedules** - Generate detailed first-week schedules with meetings, training, and orientation sessions Team Introductions** - Include team member photos, bios, and contact information in welcome packages Location-Specific Content** - Different documents for headquarters vs remote vs international employees Probationary Period Info** - Add probation terms, review schedules, and performance expectations Company Culture Content** - Include mission, values, culture guide, and employee testimonials Video Embeddings** - Add QR codes or links to welcome videos from CEO or department heads Interactive Checklists** - Generate pre-boarding checklists with tasks to complete before start date Equipment Order Forms** - Include forms for employees to select laptop preferences or accessories Background Check Status** - Conditional content based on background check completion Referral Program Info** - Include employee referral program details and bonus structure Expected Results 95% time savings** - Reduce document preparation from 3-4 hours to 3 minutes per employee 100% consistency** - Eliminate errors from manual document creation and ensure brand compliance Same-day delivery** - New hires receive complete packages within minutes of offer acceptance Zero document loss** - Systematic archival prevents missing paperwork or compliance gaps Improved new hire experience** - Professional, organized packages create positive first impression Faster time-to-productivity** - Clear instructions and preparation reduce first-day confusion Reduced HR workload** - Automation frees HR team for strategic onboarding activities Better compliance** - Consistent documentation and tracking meets regulatory requirements Scalable onboarding** - Handle 10x more new hires without additional HR staff Complete audit trail** - Timestamp and track every document generation for compliance reviews Pro Tips Test with Multiple Roles** - Verify role detection logic works correctly for all job titles in your organization Validate Email Delivery** - Ensure onboarding emails don't trigger spam filters with test sends Set Realistic Deadlines** - Give new hires adequate time to review and complete forms before start date Include Document Checklist** - Help new hires track which forms require signatures or return Provide IT Support Contact** - Make sure IT help desk info is accurate and responsive Update Benefits Annually** - Review and refresh benefits content during open enrollment periods Personalize Welcome Messages** - Include hiring manager or team-specific welcome notes when possible Archive Systematically** - Maintain consistent folder structure for easy retrieval and compliance audits Track Form Completion** - Follow up with new hires who haven't returned required documents Gather Feedback** - Survey new hires about onboarding package clarity and usefulness Keep Templates Current** - Regularly review and update document templates with latest policies Add Video Walkthroughs** - Link to video tours of office, parking, and first-day procedures Include FAQ Document** - Answer common new hire questions proactively in package Customize for Remote Workers** - Create alternate documents for fully remote employees Coordinate with Managers** - Notify hiring managers when their new reports receive onboarding packages Business Impact Metrics Track these key metrics to measure workflow success: Document Generation Time** - Average minutes from trigger to package delivery (target: under 5 minutes) HR Productivity Gain** - Hours saved per month on document preparation (typical: 15-20 hours monthly) New Hire Satisfaction** - Survey rating on onboarding package quality and clarity (target: 4.5/5) Form Completion Rate** - Percentage of required forms returned by start date (target: 95%+) Documentation Errors** - Reduction in incorrect or missing information on documents (target: 100% accuracy) Time-to-Productivity** - Days until new hire reaches full productivity (expect 20-30% faster) Compliance Adherence** - Percentage of complete onboarding files meeting regulatory standards (target: 100%) Package Delivery Speed** - Hours between offer acceptance and package receipt (target: same day) First-Day Preparedness** - Percentage of new hires arriving with completed forms (target: 90%+) HR Scalability** - Number of new hires HR can onboard simultaneously without quality loss Template Compatibility Compatible with n8n version 1.0 and above Works with n8n Cloud and Self-Hosted instances Requires HTML to PDF API service subscription No coding required for basic setup Fully customizable document templates and content Supports unlimited employees and departments Integrates with major HRIS platforms via API Handles all employment types and role variations Scalable to process multiple onboarding packages simultaneously Ready to transform your employee onboarding process? Import this template and start generating professional, role-specific onboarding packages that delight new hires, ensure compliance, and free your HR team to focus on creating exceptional employee experiences instead of shuffling paperwork!

Workflow Overview This workflow provides a complete, automated post-purchase solution triggered by a successful payment webhook from Abacate Pay. (For international users, think of Abacate Pay as 'the Brazilian Stripe' – a popular and robust payment gateway in Brazil). When a successful payment is registered, this workflow instantly sends a beautiful, responsive HTML confirmation email to the customer and posts a detailed notification to a designated Slack channel. The key feature is its ability to dynamically reward first-time buyers. The workflow checks the customer's purchase history, and if it's their first order, it automatically generates a 10% discount coupon for their next purchase and includes it in the welcome email. Key Features: Webhook Trigger:** Securely listens for successful payment events from Abacate Pay. First-Time Buyer Detection:** Queries past orders to identify new customers. Automatic Coupon Generation:** Creates a unique, single-use discount coupon for new buyers. Dynamic Content:** The email and Slack messages automatically include the coupon details, but only for first-time buyers. Responsive HTML Email:** Sends a professional and mobile-friendly order confirmation. Rich Slack Notifications:** Uses Block Kit for well-formatted, actionable alerts for your team. Centralized Configuration:** A single Configs node makes it easy to manage static variables like company name and tokens. Setup Instructions: Webhook Node: Copy the webhook URL and paste it into your Abacate Pay dashboard for the "payment successful" event (e.g., billing.paid). Configs Node: Open this Set node and fill in your company's information (companyName, companySite, companyEmail) and the token used to validate the webhook requests. HTTP Request Nodes (GetOrders, CreateCustomCoupon): In both nodes, go to the "Authentication" or "Header" section and replace the placeholder Bearer Token with your actual Abacate Pay API key. Send Email Node: Select your email credentials from the dropdown or configure a new account (e.g., SMTP, Gmail). Slack Node: Select your Slack credentials and choose the channel where you want to receive notifications. Activate the Workflow: Save and activate the workflow. It's now ready to process incoming orders! Required Credentials: Abacate Pay API Credentials Email Credentials (e.g., SMTP, SendGrid, Gmail) Slack API Credentials

Automatically fetches daily sales, shifts, and receipts from Loyverse. Calculates gross profit, net operating profit, other key metrics, saves them to a Google Sheet and sends out a daily report via email. Who’s it for This template is for any business owner, manager, or analyst using Loyverse POS who needs more advanced financial reporting. If you're a restaurant, bar, or retail owner who wants to automatically track daily net profit, compare sales to historical averages, and build a custom financial dashboard in Google Sheets, this workflow is for you. How it works / What it does This workflow runs automatically on a daily schedule. It fetches all sales data and receipts from your Loyverse account for the previous business day, defined by your custom shift times (even past midnight). A powerful Code node then processes all the data to calculate the metrics that Loyverse either doesn't provide at all, or only spreads out across several separate reports instead of in one consolidated place. Already set up are metrics like... -Total Revenue, Gross Profit, and Net Operating Profit Cash handling differences (over/under) Average spend per receipt (ATV) 30-day rolling Net Operating Profit (NOP) Performance vs. your historical weekday average Finally, it appends the single, calculated row of daily metrics to a Google Sheet and sends an easily customizable summary report to your email. How to set up This workflow includes detailed Sticky Notes to guide you through the setup process. Because every business has a unique POS configuration (different POS devices, categories, and payment types), you'll need to set up a few things manually before executing the workflow. I've tried to make this as easy as possible to follow, and the entire setup should only take about 15 minutes. Preparations & Credential setup Subscribe to "Integrations" Add-on in Loyverse ($9 / month) to gain API access. Create an Access token in Loyverse Create Credentials: In your n8n instance, create credentials for Loyverse (use "Generic" > "Bearer Auth"), Google Sheets (OAuth2), and your Email (SMTP or other). Make a copy of a prep-configured Google Spreadsheet (Link in the second sticky note inside the workflow). Fill MASTER CONFIG: Open the MASTER CONFIG node. Follow the comments inside to add your Google Sheet ID, Sheet Names, business hours, timezone, and Loyverse IDs (for POS devices, payment types, and categories). Configure Google Sheet Nodes Configure Read Historical Data: Open this node. Follow the instructions in the nearby Sticky Note to paste the expressions for your Document ID and Sheet Name. Configure Save Product List: Open this node. Paste in the expressions for Document ID and Sheet Name. The column mapper will load; map your sheet columns (e.g., item_name) to the data on the left (e.g., {{ $json.item_name }}). Configure Save Latest Sales Data: Open this node. Paste in the expressions for Document ID and Sheet Name. Save and run the workflow. After that, the column mapper will load. This is the most important step: map your sheet's column names (e.g., "Total Revenue") to the calculated metrics from the Calculate All Metrics node (e.g., {{ $json.totalGrossRevenue }}). Activate the workflow. 🫡 Requirements Loyverse Integrations Subscription Loyverse Access Token Credentials for Loyverse (Bearer Auth) Credentials for Google Sheets (OAuth2) Credentials for Email/SMTP sender How to customize the workflow This template is designed to be highly flexible. Central Configuration: Almost all customization (POS devices, categories, payment types, sheet names) is done in the MASTER CONFIG node. You don't need to dig through other nodes. Add/Remove Metrics: The Calculate All Metrics node has additional metrics already set up, just add the relevant collumns to the SalesData sheet or even add your own calculations to the node. Any new metric you add (e.g., metrics.myNewMetric = 123) will be available to map in the Save Latest Sales Data node. Email Body: You can easily edit the Send email node to change the text or add new metrics from the Calculate All Metrics node.

Upload a construction photo via web form → get a detailed cost estimate with work breakdown, resource costs, and professional HTML report. Powered by GPT-4 Vision and the open-source DDC CWICR database (55,000+ work items). Who's it for Site managers** who need quick estimates from mobile photos Renovation contractors** evaluating project scope from initial site visit Real estate inspectors** estimating repair costs Construction consultants** providing rapid ballpark figures DIY enthusiasts** planning home improvement budgets What it does Collects photo + region/language via n8n Form Analyzes photo with GPT-4 Vision (room type, elements, dimensions) Decomposes visible elements into construction work items Searches DDC CWICR vector database for matching rates Generates professional HTML report with cost breakdown Supports 9 regions: 🇩🇪 Berlin · 🇬🇧 Toronto · 🇷🇺 St. Petersburg · 🇪🇸 Barcelona · 🇫🇷 Paris · 🇧🇷 São Paulo · 🇨🇳 Shanghai · 🇦🇪 Dubai · 🇮🇳 Mumbai How it works ┌──────────────┐ ┌───────────────┐ ┌───────────────┐ ┌──────────────┐ │ Web Form │ → │ STAGE 1 │ → │ STAGE 4 │ → │ Loop Works │ │ Photo+Lang │ │ GPT-4 Vision │ │ Decompose │ │ per item │ └──────────────┘ └───────────────┘ └───────────────┘ └──────────────┘ ↓ ↓ ↓ ┌─────────────────────────────────────────────────────┐ │ Identify room, elements, fixtures, dimensions │ │ → Break down into 15-40 construction work items │ └─────────────────────────────────────────────────────┘ ↓ ┌──────────────┐ ┌───────────────┐ ┌───────────────┐ ┌──────────────┐ │ HTML Report │ ← │ STAGE 7.5 │ ← │ STAGE 5 │ ← │ Qdrant │ │ Response │ │ Aggregate │ │ Parse+Score │ │ Vector DB │ └──────────────┘ └───────────────┘ └───────────────┘ └──────────────┘ Pipeline stages: | Stage | Node | Description | |-------|------|-------------| | 1 | GPT-4 Vision | Analyzes photo: room type, elements, materials, dimensions | | 4 | GPT-4 Decompose | Breaks elements into work items with quantities | | 5 | Vector Search + Score | Finds matching rates in DDC CWICR, quality scoring | | 7.5 | Aggregate & Validate | Sums costs, groups by phase, validates results | | 9 | HTML Report | Generates professional estimate document | Prerequisites | Component | Requirement | |-----------|-------------| | n8n | v1.30+ with Form Trigger support | | OpenAI API | GPT-4 Vision + Embeddings access | | Qdrant | Vector DB with DDC CWICR collections | | DDC CWICR Data | github.com/datadrivenconstruction/DDC-CWICR | Setup 1. n8n Credentials (Settings → Credentials) OpenAI API** — required (GPT-4 Vision + text-embedding-3-large) Qdrant API** — your Qdrant instance connection 2. Qdrant Collections Load DDC CWICR embeddings for your target regions: DE_BERLIN_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR ENG_TORONTO_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR RU_STPETERSBURG_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR ES_BARCELONA_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR FR_PARIS_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR PT_SAOPAULO_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR ZH_SHANGHAI_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR AR_DUBAI_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR HI_MUMBAI_workitems_costs_resources_EMBEDDINGS_3072_DDC_CWICR 3. Activate Workflow Import JSON into n8n Link OpenAI + Qdrant credentials to respective nodes Activate workflow Access form at: https://your-n8n/form/photo-estimate-pro-v3 Features | Feature | Description | |---------|-------------| | 📸 Photo Analysis | GPT-4 Vision identifies room type, elements, fixtures | | 📏 Dimension Estimation | Uses reference objects (doors, tiles) for sizing | | 🔧 Work Decomposition | Breaks down to 15-40 specific work items | | 🎯 Quality Scoring | Rates match quality (high/medium/low/not_found) | | 📊 Phase Grouping | PREPARATION → MAIN → FINISHING → MEP | | 💰 Cost Breakdown | Labor, materials, machines per item | | ✅ Validation | Warns if <50% rates found or missing demolition | | 🌍 9 Languages | Full localization + regional pricing | Form Fields | Field | Type | Options | |-------|------|---------| | 📷 Upload Photo | File | .jpg, .png, .webp | | 🌍 Region & Language | Dropdown | 9 regions with currencies | | 🏗️ Work Type | Dropdown | New / Renovation / Repair / Auto | | 📝 Description | Textarea | Optional context | Example Output Input: Bathroom photo (renovation) Region: 🇩🇪 German - Berlin (EUR €) Generated Work Items: PREPARATION (3 items) ├── Demolition of wall tiles — 12 m² — €180 ├── Demolition of floor tiles — 4.5 m² — €95 └── Disposal of construction waste — 0.8 m³ — €120 MAIN (8 items) ├── Floor waterproofing — 4.5 m² — €225 ├── Wall waterproofing wet zone — 8 m² — €280 ├── Floor screed — 4.5 m² — €135 ├── Wall tiling — 22 m² — €880 ├── Floor tiling — 4.5 m² — €225 ├── Toilet installation — 1 pcs — €320 ├── Sink installation — 1 pcs — €185 └── Shower cabin installation — 1 pcs — €450 FINISHING (3 items) ├── Ceiling painting — 4.5 m² — €68 ├── Grouting — 26.5 m² — €133 └── Silicone sealing — 8 m — €48 MEP (4 items) ├── Socket installation — 2 pcs — €90 ├── Light point installation — 2 pcs — €120 ├── Mixer/faucet installation — 2 pcs — €160 └── Ventilation installation — 1 pcs — €85 ───────────────────────────────────── TOTAL: €3,799.00 Labor: €1,520 · Materials: €1,900 · Machines: €379 Quality: 78% high match · 18 work items Quality Scoring System | Score | Level | Meaning | |-------|-------|---------| | 60-100 | 🟢 High | Exact match with resources | | 40-59 | 🟡 Medium | Good match, minor differences | | 20-39 | 🟠 Low | Partial match, review needed | | 0-19 | 🔴 Not Found | No suitable rate found | Scoring factors: Has price in database (+30) Has resources breakdown (+25) Unit matches expected (+20) Material keywords match (+15) Work type keywords match (+10) Vector similarity >0.5 (+10) Notes & Tips Best photo angles:** Capture full room, include reference objects (doors, sockets) Renovation mode:** AI automatically adds demolition works Validation warnings:** Check if <50% rates found — may need manual additions Rate accuracy:** Depends on DDC CWICR coverage for your region Extend:** Chain with PDF generation, email delivery, or CRM integration Categories AI · Data Extraction · Document Ops · Files & Storage Tags photo-analysis, gpt-4-vision, construction, cost-estimation, qdrant, vector-search, form-trigger, html-report, multilingual Author DataDrivenConstruction.io https://DataDrivenConstruction.io info@datadrivenconstruction.io Consulting & Training We help construction, engineering, and technology firms implement: AI-powered visual estimation systems CAD/BIM data processing pipelines Vector database integration for construction data Multilingual cost database solutions Contact us to test with your data or adapt to your project requirements. Resources DDC CWICR Database:** GitHub Qdrant Documentation:** qdrant.tech/documentation n8n Form Trigger:** docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.formtrigger ⭐ Star us on GitHub! github.com/datadrivenconstruction/DDC-CWICR

This n8n template demonstrates how to fully automate the creation of UGC-style product videos using AI, starting from a simple Google Sheet. It transforms product data into AI-generated images, cinematic video scripts, and final videos, then uploads everything to Google Drive and updates your sheet automatically. 💡 Use cases Generate UGC ads at scale for e-commerce products Create TikTok / Reels content automatically Build content pipelines for agencies or creators Rapidly test different product angles, audiences, and messaging Automate creative production from structured data (Google Sheets) Good to know This workflow uses multiple AI services (image + video), so cost depends on usage: Image generation (DALL·E) Video generation (Sora) Video generation is asynchronous and may take several minutes per item Some AI models (like Sora) may be region-restricted or limited access Generated image URLs may expire, so storing them (as done here) is important How it works Reads product data from Google Sheets and selects rows marked "Pending". Creates a prompt and generates a product image. Analyzes the image and turns it into a video script. Sends the script to Sora and waits until the video is ready. Uploads the video to Google Drive and updates the sheet. Logs errors and marks the row as "Error". How to use Add products to Google Sheets with name, description, audience, and set status to "Pending". Run the workflow or let the schedule trigger process items automatically. The system generates image → script → video, uploads them, and updates your sheet. Requirements Requires OpenAI, Google Sheets, and Google Drive accounts. Requires an n8n instance with credentials configured. Customizing this workflow Replace the schedule trigger with a webhook or form for real-time use. Generate multiple videos per product. Send outputs to platforms like TikTok, Meta Ads, or CMS tools. Add voiceovers, captions, or permanent asset storage.

This template introduces a revolutionary approach to automated web research. Instead of a rigid workflow that can only find one type of information, this system uses a "thinker" and "doer" AI architecture. It dynamically interprets your plain-English research request, designs a custom spreadsheet (CSV) with the perfect columns for your goal, and then deploys a web-scraping AI to fill it out. It's like having an expert research assistant who not only finds the data you need but also builds the perfect container for it on the fly. Whether you're looking for sales leads, competitor data, or market trends, this workflow adapts to your request and delivers a perfectly structured, ready-to-use dataset every time. Who is this for? Sales & marketing teams:** Generate targeted lead lists, compile competitor analysis, or gather market intelligence with a simple text prompt. Researchers & analysts:** Quickly gather and structure data from the web for any topic without needing to write custom scrapers. Entrepreneurs & business owners:** Perform rapid market research to validate ideas, find suppliers, or identify opportunities. Anyone who needs structured data:** Transform unstructured, natural language requests into clean, organized spreadsheets. What problem does this solve? Eliminates rigid, single-purpose workflows:** This workflow isn't hardcoded to find just one thing. It dynamically adapts its entire research plan and data structure based on your request. Automates the entire research process:** It handles everything from understanding the goal and planning the research to executing the web search and structuring the final data. Bridges the gap between questions and data:** It translates your high-level goal (e.g., "I need sales leads") into a concrete, structured spreadsheet with all the necessary columns (Company Name, Website, Key Contacts, etc.). Optimizes for cost and efficiency:* It intelligently uses a combination of deep-dive and standard web searches from *Linkup.so** to gather high-quality initial results and then enrich them cost-effectively. How it works (The "Thinker & Doer" Method) The process is cleverly split into two main phases: The "Thinker" (AI Planner): You submit a research request via the built-in form (e.g., "Find 50 US-based fashion companies for a sales outreach campaign"). The first AI node acts as the "thinker." It analyzes your request and determines the optimal structure for your final spreadsheet. It dynamically generates a plan, which includes a discoveryQuery to find the initial list, an enrichmentQuery to get details for each item, and the JSON schemas that define the exact columns for your CSV. The "Doer" (AI Researcher): The rest of the workflow is the "doer," which executes the plan. Discovery: It uses a powerful "deep search" with Linkup.so to execute the discoveryQuery and find the initial list of items (e.g., the 50 fashion companies). Enrichment: It then loops through each item in the list. For each one, it performs a fast and cost-effective "standard search" with Linkup to execute the enrichmentQuery, filling in all the detailed columns defined by the "thinker." Final Output: The workflow consolidates all the enriched data and converts it into a final CSV file, ready for download or further processing. Setup Connect your AI provider: In the OpenAI Chat Model node, add your AI provider's credentials. Connect your Linkup account: In the two Linkup (HTTP Request) nodes, add your Linkup API key (free account at linkup.so). We recommend creating a "Generic Credential" of type "Bearer Token" for this. Linkup offers €5 of free credits monthly, which is enough for 1k standard searches or 100 deep queries. Activate the workflow: Toggle the workflow to "Active." You can now use the form to submit your first research request! Taking it further Add a custom dashboard:** Replace the form trigger and final CSV output with a more polished user experience. For example, build a simple web app where users can submit requests and download their completed research files. Make it company-aware:** Modify the "thinker" AI's prompt to include context about your company. This will allow it to generate research plans that are automatically tailored to finding leads or data relevant to your specific products and services. Add an AI summary layer:** After the CSV is generated, add a final AI node to read the entire file and produce a high-level summary, such as "Here are the top 5 leads to contact first and why," turning the raw data into an instant, actionable report.

Setup & Instructions — fluidX: Create Session, Analyze & Notify Goal: This workflow demonstrates the full fluidX THE EYE integration — starting a live session, inviting both the customer (via SMS) and the service agent (via email), and then accessing the media (photos and videos) created during the session. Captured images are automatically analyzed with AI, uploaded to an external storage (such as Google Drive), and a media summary for the session is generated at the end. The agent receives an email with a link to join the live session. The customer receives an SMS with a link to start sharing their camera. Once both are connected, the agent can view the live feed, and the system automatically stores uploaded images and videos in Google Drive. When the session ends, the workflow collects all media and creates a complete AI-powered session summary (stored and updated in Google Drive). Below is an example screenshot from the customer’s phone: Prerequisites Developer account:* https://live.fluidx.digital (activate the *TEST plan**, €0) API docs (Swagger):** fluidX.digital API 🔐 Required Credentials 1️⃣ fluidX API key (HTTP Header Auth) • Credential name in n8n: fluidx API key • Header name: x-api-key • Header value: YOUR_API_KEY 2️⃣ SMTP account (for outbound email) • Credential name in n8n: SMTP account • Configure host, port, username, and password according to your provider • Enable TLS/SSL as required 3️⃣ Google Drive account • Used to store photos, videos, and automatically update the session summary files. 4️⃣ OpenAI API (for AI analysis & summary) •Used in the Analyze Images (AI) and Generate Summary parts of the workflow. • Credential type: OpenAI • Credential name (suggested): OpenAI account • API Key: your OpenAI API key • Model: e.g. gpt-4.1, gpt-4o, or similar (choose in the OpenAI node settings) ⚙️ Configuration (in the “Set Config” node) BASE_URL: https://live.fluidx.digital company / project / billingcode / sku: adjust as needed emailAgent: set before running (empty in template) phoneNumberUser: set before running (empty in template) Flow Overview Form Trigger → Create Session → Set Session Vars → Send SMS (User) → Send Email (Agent) → Monitor Media → Analyze Images (AI) → Upload Files to Google Drive → Generate Summary → Update Summary File The workflow starts automatically when a Form submission is received. Users enter the customer’s phone number and agent’s email, and the system creates a new fluidX THE EYE session. As media is uploaded during the session, the workflow automatically retrieves, stores, analyzes, and summarizes it — providing a complete end-to-end automation example for remote inspection, support, or field-service use cases. Notes Do not store real personal data inside the template. Manage API keys and secrets via n8n Credentials or environment variables. Log out of https://live.fluidx.digital in the agent’s browser before testing, to ensure a clean invite flow and session creation.

This n8n template shows you how to automate document summarization while keeping full digital sovereignty. By combining Nextcloud for file storage and the IONOS AI Model Hub, your sensitive documents stay on European infrastructure—fully outside US CLOUD Act jurisdiction. Use cases Daily briefings: Automatically summarize lengthy reports as soon as your team uploads them. Meeting notes: Turn uploaded transcripts into clear, actionable bullet points—hands-free. Research management: Get instant summaries of academic papers or PDFs the moment they land in your research folder. How it works A Schedule Trigger kicks off the workflow at regular intervals. It calls the Nextcloud List a Folder node to retrieve all files in your chosen directory. A Code node then acts as a filter, checking each file's last-modified timestamp and letting through only files changed within the past 24 hours. Filtered files are pulled into the workflow via the Nextcloud Download a File node. From there, the Summarization Chain takes over: a Default Data Loader and Token Splitter prepare the content, and the IONOS AI Model Hub Chat Model generates a concise, structured summary. The final output is saved back to your Nextcloud instance as a note for your team. Good to know Nextcloud setup: Make sure your Nextcloud credentials include both read and write permissions—one to download source files, one to upload the generated summary. Model selection: The IONOS AI Model Hub currently offers several LLMs, including Llama 3.1 8B, Mistral Nemo 12B, Mistral Small 24B, Llama 3.3 70B, GPT-OSS 120B, and Llama 3.1 405B. For document summarization, Llama 3.3 70B strikes the best balance between output quality and speed. If you're processing high volumes or need faster turnaround, Mistral Nemo 12B is a leaner alternative. How to set it up Set your folder path in the List a Folder node to the directory you want to monitor. In the New Files Only code node, adjust the 24 value to change how far back the workflow looks. Open the Summarization Chain and define your output format—for example: "Summarize this document in 3 bullet points." Requirements Nextcloud account for file hosting and retrieval IONOS Cloud account to access the AI Model Hub