Get Started
Back to Templates

Generate AI-Powered Sales Proposals from JotForm Leads with OpenAI and Google Docs

Created by

Created by: LeeWei || leeweihernandez07

LeeWei

Last update

Last update 23 days ago

Categories

Share

⚙️ Proposal Generator Template (Automates proposal creation from JotForm submissions)

🧑‍💻 Author: [LeeWei]

🚀 Steps to Connect:

  1. JotForm Setup

    • Visit JotForm to generate your API key and connect to the JotForm Trigger node.
    • Update the form field in the JotForm Trigger node with your form ID (default: 251206359432049).

  2. Google Drive Setup

    • Go to Google Drive and set up OAuth2 credentials ("Google Drive account") with access to the folder containing your template.
    • Update the fileId field in the Google Drive node with your template file ID (default: 1DSHUhq_DoM80cM7LZ5iZs6UGoFb3ZHsLpU3mZDuQwuQ).
    • Update the name field in the Google Drive node with your desired output file name pattern (default: ={{ $json['Company Name'] }} | Ai Proposal).

  3. OpenAI Setup

    • Visit OpenAI and generate your API key.
    • Paste this key into the OpenAI and OpenAI1 nodes under the "OpenAi account 3" credentials.
    • Update the modelId field in the OpenAI1 node if needed (default: gpt-4.1-mini).

  4. Google Docs Setup

    • Set up OAuth2 credentials ("Google Docs account") with edit permissions for the generated documents.
    • No fields need editing as the node dynamically updates based on previous outputs.

  5. Google Drive2 Setup

    • Ensure the same Google Drive credentials ("Google Drive account") are used.
    • No fields need editing as the node handles PDF conversion automatically.

  6. Gmail Setup

    • Go to Gmail and set up OAuth2 credentials ("Gmail account").
    • No fields need editing as the node dynamically uses the prospect's email from JotForm.

How it works

  • 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.

Set up steps

  • Setup time: Approximately 15-20 minutes.
  • Detailed instructions are available in sticky notes within the workflow.