Estimate construction costs from text, photos and PDFs with Telegram, GPT‑4/Gemini and DDC CWICR — n8n Workflow

Hoog complexiteit Trigger91 knooppunten⚒️ Engineering👁 16 weergavendoor Artem Boiko

Overzicht

A full-featured Telegram bot that accepts text descriptions, photos, or PDF floor plans and returns detailed cost estimates with work breakdown. Powered by GPT-4 Vision / Gemini 2.0, vector search, and the open-source DDC CWICR database (55,000+ construction rates).

Who's it for

Contractors & Estimators** who need estimates from any input format Construction managers** evaluating scope from site photos or drawings Architects** getting quick cost feedback on floor plans Real estate professional

Gebruikte knooppunten

HTTP RequestTelegramCode

Workflow-voorvertoning

⭐ If you find our tools helpful, please consi
Your support helps us impr
🔐 API CREDENTIALS SETUP
⬇️ Configure node `🔑 TOKEN` below:
```json
{
"bot_token": "YOUR_BOT_TOKEN",
"AI_PROVIDER": "gemini",
🌍 UI Messages
Telegram menus:
- Language selection
- Photo request
- Analysis options
- Help text
🔀 Route Switch
17 Actions:
| # | Action | Description |
|---|--------|-------------|
| 0 | show_lang | Language menu |
| 1 | ask_photo | Request photo |
🌐 Config
9 Languages:
DE, EN, RU, ES, FR, IT, PL, PT, UK
Contains:
- UI messages
- Button labels
🧠 Main Router
Central message handler:
Input: Telegram Update
Processing:
- Parse message/callback
- Manage user sessions
✅ CHECKLIST
1. Telegram Bot
- [ ] Created via @BotFather
- [ ] Token in 🔑 TOKEN
- [ ] Credential configured
2. OpenAI
⚙️ Telegram Credentials
Setup n8n Credential:
1. Settings → Credentials
2. Add → Telegram API
3. Enter Bot Token
4. Save
🚀 DDC CWICR Pipeline
Construction Cost Estimation Bot
Version: 10.3 Enhanced
Author: DataDrivenConstruction.io
Features:
- 📷 Photo analysis (GPT-4 Vision / Gemini)
✏️ Edit Menu
Quantity controls:
- +1, -1, +10, -10
- ×2, ÷2
Actions:
- 🗑️ Delete work
👁️ Block 4: Vision Analysis Pipeline
Photo Analysis Flow:
```
Refine → Prep Download → Get File → Download → Convert
```
AI P
📄 Block 5: PDF Floor Plan Processing
PDF Pipeline:
```
Download Prep → Get Path → Download → Split Pages → Loo
```
Features:
🔄 Block 6: Calculation Loop
Per Work Item:
```
Prep Query → LLM Transform → Embedding → Qdrant Search
```
Vector Search:
📊 Block 7: Aggregation & Reports
Final Processing:
```
Cleanup → Delete Messages → Aggregate → Generate HTML →
```
Report Contents:
📥 Block 8: Export Options
Available Exports:
- 📊 Excel (CSV) — Spreadsheet format
- 📄 PDF — Professional document
- 🌐 HTML — Interactive report
View Details:
🔍 Vector Search Setup
Qdrant Collections:
- `DDC_CWICR_DE` — German
- `DDC_CWICR_EN` — English
- `DDC_CWICR_RU` — Russian
- ... (9 languages total)
Agg
🗑️ Delete Progress Msg
🗑️ Delete Work Msg
🧹 Prep Cleanup
Acc
📤 Edit Result
📊 Update Result
1️⃣ Prep Query
💾 Save Work Msg
📤 Send Work
🗑️ Delete Prev
📝 Prep Work Msg
L
Loop
Prep Works
Save Progress ID
📤 Send Progress
📝 Prep Progress
📄 PDF Download Prep
🧹 Deduplicate & Merge
📤 Send Works
📊 Show Works
📦 Accumulate Pages
🏠 Parse PDF Page
👁️ Call Vision PDF
👁️ Prep Vision PDF
🔁 Loop PDF Pages
📄 Prep Pages Loop
📤 PDF Received
📝 Prep PDF Message
📄 Split PDF Pages
📄 Download PDF
📄 Get PDF Path
Merge To Vision1
📤 No Photos Msg1
I
IF No Photos1
Merge Vision1
Call Vision1
Prep Vision1
Convert To Base
Download Photo File1
Get File Path1
Use Stored Base64
I
IF Skip Download
9️⃣ Calculate
8️⃣ Apply Rerank
7️⃣ LLM Rerank
6️⃣ Prep Rerank
5️⃣ Qdrant Search
4️⃣ Extract Embedding
3️⃣ OpenAI Embedding
2️⃣ Extract Transform
1.5️⃣ LLM Transform
Parse Text LLM
📤 Details
View Details
📤 Fallback
📤 Help
📤 Send PDF
I
IF PDF
Generate PDF
📤 Send Excel
Generate Excel
📤 Send HTML
Prep HTML File
📤 Final
Final
Generate HTML
Answer Calc CB
📤 Works Updated
Works Updated
📤 Ask New Work
Parse AI
📤 Analyze Options
📤 Ask Photo
Answer Photo CB
📤 Lang OK
Answer Lang CB
📤 Lang Menu
R
Route
Config
Main
🔑 TOKEN
T
Telegram Trigger
Refine Analysis
I
IF Skip Refine
📤 Ask Photo Refine
Prep Photo Download
Prep Text LLM
Call Text LLM
Edit Menu
📤 Edit Menu
91 nodes97 edges

Hoe het werkt

  1. 1

    Trigger

    De workflow start met een trigger-trigger.

  2. 2

    Verwerking

    Gegevens stromen door 91 knooppunten, connecting code, httprequest, if.

  3. 3

    Uitvoer

    De workflow voltooit zijn automatisering en levert het resultaat aan de geconfigureerde bestemming.

Knooppuntdetails (91)

HT

HTTP Request

httpRequest

#1
TE

Telegram

telegram

#2
CO

Code

code

#3

Hoe deze workflow te importeren

  1. 1Klik op de knop JSON downloaden rechts om het workflowbestand op te slaan.
  2. 2Open uw n8n-instantie. Ga naar Workflows → Nieuw → Importeren uit bestand.
  3. 3Selecteer het gedownloade bestand estimate-construction-costs-from-text-photos-and-pdfs-with-telegram-gpt4gemini-and-ddc-cwicr en klik op Importeren.
  4. 4Stel inloggegevens in voor elk serviceknooppunt (API-sleutels, OAuth, enz.).
  5. 5Klik op Workflow testen om te controleren of alles werkt, activeer het vervolgens.

Of plak rechtstreeks in n8n → Importeren uit JSON:

{ "name": "Estimate construction costs from text, photos and PDFs with Telegram, GPT‑4/Gemini and DDC CWICR", "nodes": [...], ...}

Integraties

codehttprequestifsetsplitinbatchesswitchtelegramtelegramtrigger

Haal deze workflow op

Download en importeer met één klik

JSON downloadenBekijken op n8n.io
Knooppunten91
Complexiteithigh
Triggertrigger
Weergaven16
CategorieEngineering

Gemaakt door

Artem Boiko

Artem Boiko

@datadrivenconstruction

Tags

codehttprequestifsetsplitinbatchesswitchtelegramtelegramtrigger

Nieuw bij n8n?

n8n is een gratis open-source workflow-automatiseringstool. Host het zelf of gebruik de cloudversie.

n8n gratis ophalen →

Related Engineering Workflows

COGOHTIF+5
high

Automate YooKassa Payments & Order Logs in Google Sheets

Transform your payment operations with this comprehensive n8n automation designed for seamless YooKassa integration. Instead of manual data entry, this workflow creates a self-correcting financial ledger by syncing every transaction directly into Google Sheets in real-time. The logic handles the entire commerce lifecycle: from the moment a customer initiates a checkout to the final status confirmation via secure webhooks. What sets this template apart is its robust error-handling and multi-stage processing. It doesn't just log successful sales; it intelligently updates refund statuses, sorts transaction types, and uses conditional logic to ensure your spreadsheet remains a 'single source of truth.' By utilizing the Respond to Webhook node, the workflow provides immediate feedback to the payment gateway, ensuring high reliability. This is an enterprise-grade solution for small business owners who need to scale their digital sales without the overhead of expensive ERP software or manual bookkeeping. It eliminates human error, accelerates fulfillment, and provides a transparent audit trail for every ruble processed. **Common Use Cases:** - Automated Digital Product Delivery: Trigger instant access to downloads or courses once the YooKassa payment status is verified in the sheet. - Real-time Financial Reporting: Maintain a live dashboard of sales performance and refund rates for e-commerce stakeholders without manual exports. - No-code Subscription Management: Track recurring customer payments and trial expirations by logging every transaction event into a centralized Google Sheets database.

🔗 Webhook·39 nodes
COGOHTMA
low

Automate Google AI Overview Tracking: SEO Audit with SerpApi

As Google’s Search Generative Experience (SGE) reshapes the digital landscape, traditional SEO metrics often fall short. This advanced n8n workflow bridges the data gap by providing a scalable solution for monitoring brand visibility within AI Overviews. By integrating SerpApi with Google Sheets, the automation systematically audits your target keyword clusters to detect AI-generated summaries and source citations. The process begins by pulling high-priority keywords directly from your repository. It then executes real-time search queries via SerpApi, utilizing custom JavaScript in a Code node to parse complex JSON responses. The workflow specifically identifies if an AI Overview is present and, more importantly, whether your domain is cited as a primary source. All findings are exported into a structured Google Sheet, creating a historical record of your 'AI Share of Voice.' This automation saves SEO teams dozens of manual hours, allowing for data-driven adjustments to content strategy based on how Google’s LLM perceives and attributes your site’s authority. It is an essential tool for agencies and enterprise SEOs looking to defend their organic traffic in the age of generative search. **Common Use Cases:** - SGE Visibility Benchmarking vs Competitors - Automated AI Citation Reporting for SEO Clients - Content Strategy Optimization for Informational Intent Queries

Trigger·5 nodes
EDFOGIGM+3
medium

Automate Dynamic GitHub Images & URL Redirects in n8n

Stop manually updating marketing assets across distributed channels. This professional n8n automation eliminates the 'stale content' problem by transforming static GitHub-hosted images and links into dynamic, self-updating resources. Instead of hunting down every email template or PDF where you've embedded a promotional banner, this workflow allows you to push updates to a central GitHub repository that automatically reflects across all live instances. The workflow functions by utilizing GitHub as a headless content management system. It leverages the EditImage node to programmatically modify visual assets and the GitHub node to commit these changes automatically. It includes a Form Trigger for on-demand updates and a Schedule Trigger for recurring maintenance. By using stable embed links that point to dynamic GitHub files, your marketing collateral remains evergreen. Whether you are updating a limited-time offer in an old email sequence or refreshing data visualizations in a shared report, this automation ensures your audience always sees the most current information without requiring manual re-distribution of files. **Common Use Cases:** - Automated Email Banner Updates for Evergreen Campaigns - Dynamic GitHub Profile Readme & Repository Statistics - Centralized Promo Link Management for Distributed PDF Guides

Trigger·12 nodes
AGCOEXGI+8
medium

Automate Jekyll SEO Blogs with GPT-4 and GitHub (n8n Guide)

This sophisticated automation engine transforms your content strategy by bridging the gap between raw data and a live, high-ranking Jekyll website. Instead of manually drafting and formatting Markdown files, this workflow utilizes an advanced LangChain agent powered by GPT-4 to synthesize high-quality, long-form articles from simple CSV inputs. The system intelligently parses your data, constructs SEO-optimized blog posts, and handles the technical heavy lifting by committing the code directly to your GitHub repository. This triggers your CI/CD pipeline for instant deployment. Beyond just publishing, the workflow acts as a social media manager, automatically distributing your new content to LinkedIn and X (Twitter) to maximize reach and backlinks. It is an ideal solution for lean marketing teams or solo developers who need to maintain a consistent publishing cadence without the overhead of a traditional CMS. By automating the research, writing, and distribution phases, users can scale their organic traffic exponentially while focusing on high-level strategy rather than repetitive formatting and manual commits. **Common Use Cases:** - Programmatic SEO for Niche Affiliate Marketing Sites - Automated Technical Documentation and Change Log Updates - Scalable Content Engine for Multi-Language Recipe or Directory Portals

Trigger·13 nodes
AGCOEMEM+5
medium

Build a Local AI Book Concierge with Ollama & n8n

Transform your inbox into an intelligent, automated literary assistant with this advanced n8n workflow. By leveraging the power of local LLMs through Ollama and the OpenLibrary API, this automation eliminates the manual effort of responding to reading inquiries. The process begins by monitoring an IMAP folder for incoming requests. Once an email arrives, a sophisticated AI agent analyzes the sender's natural language to pinpoint their specific interests and genre preferences. The workflow then executes a real-time API lookup to fetch accurate bibliographical data, including summaries and metadata. Finally, it crafts and sends a professional, personalized recommendation email back to the user. This setup is perfect for organizations looking to deploy privacy-focused AI solutions without relying on expensive cloud tokens. It demonstrates a high-level integration of LangChain agents, conditional logic, and external data enrichment, providing a seamless 'set-and-forget' experience for managing high volumes of literary or educational inquiries while maintaining a human-like touch in communication. **Common Use Cases:** - Personalized Reading Lists for Digital Newsletters - Automated Curriculum Support for Educational Institutions - Privacy-First Customer Engagement for Local Bookstores

▶️ Manual·15 nodes
AGCOFIGM+6
medium

Automate HubSpot AI Email Replies with Slack Approval (n8n)

This advanced n8n automation bridges the gap between AI-driven speed and human-verified precision. By integrating Google Gemini with your HubSpot CRM, the workflow automatically generates context-aware email responses whenever a new inquiry hits your Gmail inbox. Unlike basic auto-responders, this system queries your HubSpot records—including contact history, active deals, and support tickets—to ensure every draft is personalized and accurate. To maintain brand integrity, the draft isn't sent immediately; instead, it is routed to a dedicated Slack channel via an interactive message. Your team can review, edit, or approve the reply with a single click, triggering the final send via Gmail. This eliminates the manual overhead of switching between tabs to find customer data and drafting repetitive emails from scratch. It is the perfect solution for scaling customer operations without hiring additional headcount, ensuring that every outbound communication is data-backed and professionally vetted. The workflow utilizes LangChain agents for intelligent reasoning, filtering out internal noise to focus purely on high-value customer interactions. **Common Use Cases:** - High-priority sales lead nurturing where quick, data-informed follow-ups are critical for conversion. - Technical support escalation where AI drafts troubleshooting steps based on existing HubSpot ticket history. - Account management automation for handling routine client inquiries with personalized data from active deals.

Trigger·13 nodes