Generate construction bid estimates with Azure OpenAI, Google Docs and Sheets

by Rahul Joshi ✓ · 180 views · created 2026-06-16

What this workflow does

This AI workflow has 15 nodes and runs when someone submits an n8n form (“AI Bid Estimation — Upload Scope of Work”) (plus 1 other trigger). Along the way it connects Azure OpenAI Chat Model, Google Docs, Google Sheets and Gmail and 1 more.

How it runs

Trigger: When someone submits an n8n form (“AI Bid Estimation — Upload Scope of Work”) (plus 1 other trigger).

1. Extract from File: extracts data from a file (pdf)
2. Google Sheets: uses Google Sheets
3. Slack: uses Slack
4. AI Agent: runs an AI agent, with model: Azure OpenAI Chat Model
5. Calculate Cost Per Item (Code): runs custom JavaScript code
6. Parse Extracted Data (Code): runs custom JavaScript code
7. Aggregate: combines items into one
8. Build Bid Summary (Code): runs custom JavaScript code
9. Google Docs: uses Google Docs
10. Google Sheets: append

…plus 2 more steps. See the full node list below.

Services it uses

Azure OpenAI Chat ModelGoogle DocsGoogle SheetsGmailSlack

Before you upgrade to n8n 3.0

Nodes used (11)

• Azure OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatAzureOpenAi
• AI Agent@n8n/n8n-nodes-langchain.agent
• n8n Form Triggern8n-nodes-base.formTrigger
• Extract from Filen8n-nodes-base.extractFromFile
• Coden8n-nodes-base.code
• Aggregaten8n-nodes-base.aggregate
• Google Docsn8n-nodes-base.googleDocs
• Google Sheetsn8n-nodes-base.googleSheets
• Gmailn8n-nodes-base.gmail
• Error Triggern8n-nodes-base.errorTrigger
• Slackn8n-nodes-base.slack

From the author

Quick Overview This workflow collects a construction Scope of Work PDF via an n8n form, uses Azure OpenAI to extract BOQ-style line items, prices them using a Google Sheets unit-rate database, generates a formatted Google Docs bid report, logs the estimate to…

View the original on n8n.io → Check your own copy