Automated AI Sales Proposal Generator using JotForm and Google Docs - n8n Workflow

Sales teams seeking to drastically reduce proposal creation time.
Consultants or agencies using JotForm for lead capture and needing rapid document generation.
Users looking for advanced examples of integrating OpenAI agents within an n8n workflow for structured output.
Professionals who need robust, repeatable n8n templates for CRM automation and content delivery.

This powerful automation solves the bottleneck of manual, time-consuming proposal creation after a discovery call. By integrating a JotForm submission, which acts as the initial n8n trigger and includes prospect details and a link to the call audio, this n8n workflow automatically handles the entire process. It manages transcription, sophisticated AI analysis, content generation, document templating, and delivery.

The core of this n8n workflow relies on a sophisticated AI agent via the OpenAI n8n node, which analyzes the call transcript and generates a structured JSON output—complete with problem statements, scoped solutions, dynamic pricing, and upsell offers. This data is then seamlessly injected into a Google Docs template, converted to a professional PDF, and finally emailed using the Gmail n8n node. This approach delivers rapid, highly personalized documentation, maximizing sales velocity and saving hours of administrative time.

This automation initiates immediately upon receiving a new lead or sales data, demonstrating a high-efficiency n8n workflow.

1. JotForm Trigger: The automation begins when a prospect submits a form, serving as the primary n8n trigger. This submission provides necessary data, including contact information and a critical link to the recent sales call recording.


2. Template Duplication (Google Drive): A Google Drive n8n node copies a master Google Docs proposal template, ensuring the original template remains untouched. The new file is named dynamically using the prospect's Company Name.


3. Call Transcription Setup: A subsequent Google Drive n8n node downloads the audio file specified by the Call Link from the JotForm entry.


4. Audio Transcription (OpenAI): The downloaded audio data is passed to the first OpenAI n8n node, which performs a high-accuracy transcribe operation, converting the sales discussion into usable text.


5. AI Proposal Generation (OpenAI1): The transcribed text and prospect details are sent to a second OpenAI n8n node, configured with a detailed system prompt to act as an expert proposal generation agent. This LLM analyzes the conversation, adheres to a strict Standard Operating Procedure (SOP), and outputs the entire proposal content (including pricing, solution scope, and upsell logic) as a structured JSON object. This is a crucial step in the overall n8n workflow.


6. Document Assembly (Google Docs): The Google Docs n8n node takes the AI-generated JSON content and uses numerous replaceAll actions to populate placeholders (like {{aiSystem}}, {{problemStatement}}, {{price}}) within the copied template document.


7. PDF Conversion (Google Drive2): A dedicated Google Drive n8n node downloads the updated document and converts it into a universally readable PDF file.


8. Final Delivery (Gmail): The Gmail n8n node compiles a personalized email using the AI-generated aiSystem name in the subject line. It attaches the newly generated PDF proposal and sends it directly to the prospect’s email address captured by the initial n8n trigger. This completes the full automation cycle.

To deploy this powerful n8n workflow, follow these setup steps:

1. Import the n8n template: Copy the provided JSON and import it directly into your n8n instance.


2. JotForm Setup:

1. Google Drive & Docs Setup:

1. OpenAI Setup:

1. Gmail Setup:

JotForm Trigger: Serves as the initiating n8n trigger, starting the workflow upon a new form submission. Key Configuration: Must be configured with the correct Form ID.
Google Drive (Copy Template): Copies the predefined Google Docs proposal template file. Function: Prepares the unique working document for the prospect. Key Configuration: Uses a static fileId for the source template and names the output file dynamically based on prospect data.
Google Drive1 (Download Call): Downloads the audio file linked in the JotForm entry. Function: Retrieves the raw sales call data needed for transcription.
OpenAI (Transcription): A crucial n8n node for processing. Function: Transcribes the downloaded audio file using the audio resource and transcribe operation.
OpenAI1 (Proposal Generation): The central AI processing n8n node. Function: Acts as an AI agent, analyzing the transcript and prospect details to generate a comprehensive, structured proposal JSON object, including solution details, pricing, and an upsell offer. Key Configuration: Uses a detailed system prompt and forces JSON output.
Google Docs: Updates the document created earlier. Function: Uses the update operation with 23 separate replaceAll actions to map all AI-generated fields (like {{aiSystem}}, {{workScope}}, {{50percentDiscount}}) into the document template.
Google Drive2 (PDF Conversion): Converts the final, populated Google Doc into a PDF. Function: Downloads the final document and specifies PDF conversion using the googleFileConversion option.
Gmail: Delivers the finished proposal. Function: Drafts and sends a personalized email to the prospect, attaching the generated PDF binary data. This final n8n node concludes the automated sales cycle.