Generate legal tech project proposals with Google Sheets, GPT-4o, SerpApi and Gmail
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 20 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets, AI Agent, OpenAI Chat Model and Gmail. It also calls serpapi.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Webhook Acknowledgment (Respond to Webhook): sends the response back to the webhook caller
- Read Pricing Data from Sheets (Google Sheets): uses Google Sheets
- Combine Proposal with Pricing (Code): runs custom JavaScript code
- Project Analysis Agent (AI Agent): runs an AI agent, with model: OpenAI GPT-4o Mini
- Process AI Analysis (Code): runs custom JavaScript code
- Check Missing Services (If): checks a condition and branches into true / false
- Prepare Market Search Queries (Code): runs custom JavaScript code
- Handle Without Market Search (Code): runs custom JavaScript code
- Fetch Market Prices (HTTP Request): calls serpapi.com
- Compile Proposal Data (Code): runs custom JavaScript code
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: serpapi.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Project Analysis Agent (v1.9), Proposal HTML Creator Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent..
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Project Analysis Agent (v1.9), Proposal HTML Creator Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Respond to Webhook
n8n-nodes-base.respondToWebhook - Merge
n8n-nodes-base.merge
From the author
Quick Overview This workflow receives project requirements via a webhook, pulls service pricing from Google Sheets, uses OpenAI to analyze scope and estimate effort, optionally looks up missing service pricing via SerpApi, then generates a branded HTML…