AutomationFlowsAI & RAG › Generate Ai-powered Sales Proposals From Jotform Leads with Openai and…

Generate Ai-powered Sales Proposals From Jotform Leads with Openai and…

Original n8n title: Generate Ai-powered Sales Proposals From Jotform Leads with Openai and Google Docs

ByLeeWei @leeweihernandez07 on n8n.io

JotForm Setup Visit JotForm to generate your API key and connect to the JotForm Trigger node. Update the field in the JotForm Trigger node with your form ID (default: ). Google Drive Setup Go to Google Drive and set up OAuth2 credentials ("Google Drive account") with access to…

Event trigger★★★★☆ complexityAI-powered9 nodesJot Form TriggerGoogle DriveOpenAIGoogle DocsGmail
AI & RAG Trigger: Event Nodes: 9 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #8104 — we link there as the canonical source.

This workflow follows the Gmail → Google Docs recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "nodes": [
    {
      "id": "a3d6e0d3-3f5a-44de-8518-590601a362d6",
      "name": "JotForm Trigger",
      "type": "n8n-nodes-base.jotFormTrigger",
      "position": [
        432,
        432
      ],
      "parameters": {
        "form": "251206359432049"
      },
      "typeVersion": 1
    },
    {
      "id": "1bf8d979-0f2c-4123-af8b-75dda886a372",
      "name": "Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        656,
        432
      ],
      "parameters": {
        "name": "={{ $json['Company Name'] }} | Ai Proposal",
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "1DSHUhq_DoM80cM7LZ5iZs6UGoFb3ZHsLpU3mZDuQwuQ"
        },
        "options": {},
        "operation": "copy"
      },
      "executeOnce": true,
      "typeVersion": 3
    },
    {
      "id": "15b2e0d6-4435-426e-9c5f-27e1dad04f95",
      "name": "Google Drive1",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        880,
        432
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('JotForm Trigger').item.json['Call Link'] }}"
        },
        "options": {},
        "operation": "download"
      },
      "typeVersion": 3
    },
    {
      "id": "0242ce1e-f983-4be8-aecc-ae2aaae1541d",
      "name": "OpenAI",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        528,
        656
      ],
      "parameters": {
        "options": {},
        "resource": "audio",
        "operation": "transcribe"
      },
      "typeVersion": 1.8
    },
    {
      "id": "56e8e15a-97aa-4fcb-af03-4b7a4c929a79",
      "name": "OpenAI1",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        736,
        656
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini",
          "cachedResultName": "GPT-4.1-MINI"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Please analyze the following data.\n\nProspect Details\nFirst Name:{{ $('JotForm Trigger').item.json['First Name'] }}\nLast Name:{{ $('JotForm Trigger').item.json['Last Name'] }}\nCompany Name: {{ $('JotForm Trigger').item.json['Company Name'] }}\n\nSales Call Transcript: {{ $json.text }}"
            },
            {
              "role": "system",
              "content": "# Overview  \nYou are an AI agent responsible for generating tailored proposal components in JSON format based on a sales call transcript and basic prospect details.\n\n## Context  \n- Your role is to craft high-conversion proposal content using a professional but conversational tone.  \n- Outputs must be JSON elements only \u2014 no explanatory or surrounding text.  \n- Each piece should reflect a deep understanding of the prospect\u2019s problems and clearly explain how the proposed solution and upsell will provide meaningful outcomes.  \n- Pricing should range from $2,000 to $10,000 and reflect 5\u201310% of the value being saved or generated over the next year.  \n\n## Instructions  \n1. Analyze the sales call transcript to identify the core pain point of the prospect, ideally using their own words.  \n2. Construct a compelling problem statement and expand with three concise supporting bullets.  \n3. Name the proposed AI system based on the outcome it delivers and align it with the problem.  \n4. Write a clear solution statement and elaborate with three supporting bullets.  \n5. Explain why this solution works in 2\u20133 benefit-focused sentences.  \n6. Outline the detailed scope of work for the solution.  \n7. Generate a price in $USD aligned with the estimated annual value, keeping within the $2K\u2013$10K range.  \n8. Define pricing type as either \"one time\" or \"monthly\".  \n9. Calculate and return 50% of the solution price in $USD.  \n10. Craft a complementary upsell offer that addresses the next logical or adjacent problem.  \n11. Follow a similar format for the upsell: name, scope (1\u20132 sentences), three supporting bullets, price, and pricing type.  \n\n## Tools  \n- Input:  \n  - Prospect Details  \n  - Sales Call Transcript  \n\n## Examples  \n- Input:  \n  - Sales Call Transcript: \"We spend hours manually tagging customer support tickets, which delays our response times.\"  \n- Output (JSON):  \n  ```json\n  {\n    \"problemStatement\": \"Your team is bogged down by the manual tagging of support tickets, causing delays in response times and reducing customer satisfaction.\",\n    \"problemStatementBulletOne\": \"Manual tagging consumes hours of valuable time weekly.\",\n    \"problemStatementBulletTwo\": \"Delayed ticket handling frustrates customers and risks churn.\",\n    \"problemStatementBulletThree\": \"Lack of automation is limiting your scalability.\",\n    \"aiSystem\": \"Smart Support Tagger\",\n    \"solutionStatement\": \"Smart Support Tagger is an AI-powered system that automatically classifies and tags incoming support tickets, ensuring faster routing and response.\",\n    \"solutionStatementBulletOne\": \"Automates initial support triage using natural language understanding.\",\n    \"solutionStatementBulletTwo\": \"Reduces average handling time by 40\u201360%.\",\n    \"solutionStatementBulletThree\": \"Integrates with existing support platforms like Zendesk and Intercom.\",\n    \"whyThisWorks\": \"This solution eliminates your team's repetitive workload and boosts response speed, directly improving the customer experience. It\u2019s designed to scale as you grow, creating long-term efficiency gains.\",\n    \"workScope\": \"Setup and training of the AI model using your past ticket data, integration with current support platform, testing and QA, and deployment.\",\n    \"price\": \"$7000\",\n    \"solutionPricingType\": \"one time\",\n    \"50percentDiscount\": \"$3500\",\n    \"upsellOne\": \"Support Sentiment Monitor\",\n    \"upsellOneScope\": \"Support Sentiment Monitor analyzes incoming tickets and ongoing chats to detect customer emotions in real time. Paired with Smart Support Tagger, this enables even smarter routing and faster escalation of critical tickets.\",\n    \"upsellOneBulletOne\": \"Monitors sentiment to highlight at-risk customers.\",\n    \"upsellOneBulletTwo\": \"Pairs well with ticket tagging for full visibility.\",\n    \"upsellOneBulletThree\": \"Boosts NPS and customer retention by flagging issues early.\",\n    \"upsellOnePricing\": \"$5000\",\n    \"upsellOnePricingType\": \"one time\"\n  }\n  ```\n\n## SOP (Standard Operating Procedure)  \n1. Parse the sales call transcript and extract emotional or urgent language to form the problem statement.  \n2. Use clear and outcome-driven naming conventions for the AI system.  \n3. Create a concise yet compelling solution pitch with benefits and clarity.  \n4. Estimate solution pricing based on annual value potential.  \n5. Create a logical, adjacent upsell opportunity and match structure to the core offer.  \n6. Output only the final proposal JSON object with all specified keys.  \n\n## Final Notes  \n- Avoid abstract names for systems \u2014 prioritize clarity and outcome orientation.  \n- Make sure each bullet adds distinct value and insight.  \n- Keep tone professional but conversational to build rapport and trust.  \n---"
            }
          ]
        },
        "simplify": false,
        "jsonOutput": true
      },
      "typeVersion": 1.8
    },
    {
      "id": "41062aa1-859b-46ac-ac19-09faccdf05e3",
      "name": "Google Docs",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        480,
        928
      ],
      "parameters": {
        "actionsUi": {
          "actionFields": [
            {
              "text": "{{prospectFirstName}}",
              "action": "replaceAll",
              "replaceText": "={{ $('JotForm Trigger').item.json['First Name'] }}"
            },
            {
              "text": "{{companyName}}",
              "action": "replaceAll",
              "replaceText": "={{ $('JotForm Trigger').item.json['Company Name'] }}"
            },
            {
              "text": "{{problemStatement}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.problemStatement }}"
            },
            {
              "text": "{{problemStatementBulletOne}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.problemStatementBulletOne }}"
            },
            {
              "text": "{{problemStatementBulletTwo}} ",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.problemStatementBulletTwo }}"
            },
            {
              "text": "{{problemStatementBulletThree}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.problemStatementBulletThree }}"
            },
            {
              "text": "{{aiSystem}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.aiSystem }}"
            },
            {
              "text": "{{solutionStatement}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.solutionStatement }}"
            },
            {
              "text": "{{solutionStatementBulletOne}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.solutionStatementBulletOne }}"
            },
            {
              "text": "{{solutionStatementBulletTwo}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.solutionStatementBulletTwo }}"
            },
            {
              "text": "{{solutionStatementBulletThree}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.solutionStatementBulletThree }}"
            },
            {
              "text": "{{whyThisWorks}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.whyThisWorks }}"
            },
            {
              "text": "{{workScope}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.workScope }}"
            },
            {
              "text": "{{price}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.price }}"
            },
            {
              "text": "{{solutionPricingType}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.solutionPricingType }}"
            },
            {
              "text": "{{50percentDiscount}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content['50percentDiscount'] }}"
            },
            {
              "text": "{{upsellOne}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.upsellOne }}"
            },
            {
              "text": "{{upsellOneScope}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.upsellOneScope }}"
            },
            {
              "text": "{{upsellOneBulletOne}} ",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.upsellOneBulletOne }}"
            },
            {
              "text": "{{upsellOneBulletTwo}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.upsellOneBulletTwo }}"
            },
            {
              "text": "{{upsellOneBulletThree}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.upsellOneBulletThree }}"
            },
            {
              "text": "{{upsellOnePricing}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.upsellOnePricing }}"
            },
            {
              "text": "{{upsellOnePricingType}}",
              "action": "replaceAll",
              "replaceText": "={{ $json.choices[0].message.content.upsellOnePricingType }}"
            },
            {
              "text": "{{date}}",
              "action": "replaceAll",
              "replaceText": "={{ $now }}"
            }
          ]
        },
        "operation": "update",
        "documentURL": "={{ $('Google Drive').item.json.id }}"
      },
      "typeVersion": 2
    },
    {
      "id": "05732cb6-7abb-4429-8fc7-c25306151095",
      "name": "Google Drive2",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        704,
        928
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.documentId }}"
        },
        "options": {
          "fileName": "proposal.pdf",
          "binaryPropertyName": "proposal",
          "googleFileConversion": {
            "conversion": {
              "docsToFormat": "application/pdf"
            }
          }
        },
        "operation": "download"
      },
      "typeVersion": 3
    },
    {
      "id": "e2e330b7-7741-411e-9c75-5b376d723a2f",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        912,
        928
      ],
      "parameters": {
        "message": "=Hey {{ $('JotForm Trigger').item.json['First Name'] }} - as discussed, here is the proposal for the {{ $('OpenAI1').item.json.choices[0].message.content.aiSystem }} build. Let me know if you have any questions at all. \n\nLook forward to hearing from you. \n\n- Nolan",
        "options": {
          "sendTo": "={{ $('JotForm Trigger').item.json.Email }}",
          "attachmentsUi": {
            "attachmentsBinary": [
              {
                "property": "proposal"
              }
            ]
          }
        },
        "subject": "={{ $('JotForm Trigger').item.json['Company Name'] }} | {{ $('OpenAI1').item.json.choices[0].message.content.aiSystem }} Proposal",
        "resource": "draft"
      },
      "typeVersion": 2.1
    },
    {
      "id": "48ee48b0-c428-4223-8cf6-7b0177a58360",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1136,
        272
      ],
      "parameters": {
        "width": 936,
        "height": 1132,
        "content": "### \u2699\ufe0f Proposal Generator Template (Automates proposal creation from JotForm submissions)\n\n### \ud83e\uddd1\u200d\ud83d\udcbb Author: [LeeWei]\n\n---\n\n### \ud83d\ude80 Steps to Connect:\n\n1. **JotForm Setup**\n   - Visit [JotForm](https://www.jotform.com/) to generate your API key and connect to the JotForm Trigger node.\n   - Update the `form` field in the **JotForm Trigger** node with your form ID (default: `251206359432049`).\n\n2. **Google Drive Setup**\n   - Go to [Google Drive](https://www.google.com/drive/) and set up OAuth2 credentials (\"Google Drive account\") with access to the folder containing your template.\n   - Update the `fileId` field in the **Google Drive** node with your template file ID (default: `1DSHUhq_DoM80cM7LZ5iZs6UGoFb3ZHsLpU3mZDuQwuQ`).\n   - Update the `name` field in the **Google Drive** node with your desired output file name pattern (default: `={{ $json['Company Name'] }} | Ai Proposal`).\n\n3. **OpenAI Setup**\n   - Visit [OpenAI](https://platform.openai.com/) and generate your API key.\n   - Paste this key into the **OpenAI** and **OpenAI1** nodes under the \"OpenAi account 3\" credentials.\n   - Update the `modelId` field in the **OpenAI1** node if needed (default: `gpt-4.1-mini`).\n\n4. **Google Docs Setup**\n   - Set up OAuth2 credentials (\"Google Docs account\") with edit permissions for the generated documents.\n   - No fields need editing as the node dynamically updates based on previous outputs.\n\n5. **Google Drive2 Setup**\n   - Ensure the same Google Drive credentials (\"Google Drive account\") are used.\n   - No fields need editing as the node handles PDF conversion automatically.\n\n6. **Gmail Setup**\n   - Go to [Gmail](https://mail.google.com/) and set up OAuth2 credentials (\"Gmail account\").\n   - No fields need editing as the node dynamically uses the prospect's email from JotForm.\n\n---\n\n### How it works\n\n- The workflow triggers on JotForm submissions, copies a Google Drive template, downloads an audio call link, transcribes it with OpenAI, generates a tailored proposal, updates a Google Docs file, converts it to PDF, and emails it to the prospect.\n\n### Set up steps\n\n- Setup time: Approximately 15-20 minutes.\n- Detailed instructions are available in sticky notes within the workflow.\n"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "OpenAI": {
      "main": [
        [
          {
            "node": "OpenAI1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI1": {
      "main": [
        [
          {
            "node": "Google Docs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs": {
      "main": [
        [
          {
            "node": "Google Drive2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive": {
      "main": [
        [
          {
            "node": "Google Drive1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive1": {
      "main": [
        [
          {
            "node": "OpenAI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive2": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "JotForm Trigger": {
      "main": [
        [
          {
            "node": "Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

JotForm Setup Visit JotForm to generate your API key and connect to the JotForm Trigger node. Update the field in the JotForm Trigger node with your form ID (default: ). Google Drive Setup Go to Google Drive and set up OAuth2 credentials ("Google Drive account") with access to…

Source: https://n8n.io/workflows/8104/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Stop applying manually. This workflow acts as your personal AI recruiter, automating the end-to-end process of finding high-quality jobs, tailoring your resume, and preparing personalized outreach ema

Google Docs, HTTP Request, OpenAI +2
AI & RAG

Extract content from PDFs, generate two different test versions with AI, and create formatted Google Docs with automated email delivery. This workflow extracts text from PDF teaching materials, uses O

Form Trigger, OpenAI, Google Docs +2
AI & RAG

Use cases are many: send branded quotations to new leads after a discovery call, distribute pricing proposals to inbound form submissions, or push service packages to prospects. All without manually c

Form Trigger, OpenAI, Google Drive +2
AI & RAG

What it is An automated LinkedIn content system that takes a simple form (idea + optional file), generates LinkedIn posts with OpenAI, stores them in Notion, builds Google Slides carousels, and auto-p

Form Trigger, OpenAI, Notion +6
AI & RAG

Listens for completed Fireflies transcripts, qualifies whether a proposal is needed using OpenAI, drafts structured proposal content, populates a Google Doc template, converts to PDF, and sends it to

HTTP Request, OpenAI, Google Drive +3