AutomationFlowsAI & RAG › Automated Request-to-quote with Openai, Google Sheets & Craftmypdf

Automated Request-to-quote with Openai, Google Sheets & Craftmypdf

ByCong Nguyen @cong-nguyen on n8n.io

Turns a simple form submission into a polished, priced PDF quote—automatically. Captures lead details via Form: Request a Quote. Loads your Google Sheets catalog (SKUs, price, stock, min qty, etc.). Uses OpenAI to select SKUs and build a strict JSON quote (respects instock and…

Event trigger★★★★☆ complexityAI-powered9 nodesForm TriggerGoogle SheetsOpenAIN8N Nodes CraftmypdfHTTP RequestEmail Send
AI & RAG Trigger: Event Nodes: 9 Complexity: ★★★★☆ AI nodes: yes Added:

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

This workflow follows the Emailsend → Form Trigger 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
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "8adfda8f-0d79-4971-81dd-fe6e122b69e8",
      "name": "Form: Request a Quote",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -1104,
        224
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "93b03299-bfdc-4da6-8641-099dfb56b75a",
      "name": "Google Sheets: Products",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -816,
        224
      ],
      "parameters": {},
      "typeVersion": 4.7
    },
    {
      "id": "2dbb5986-9d8b-47f1-a090-c5b130d72ce3",
      "name": "LLM: Select & Quote (JSON only)",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -544,
        224
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "02cd071e-e579-4b43-be2b-231ea3999544",
      "name": "Code: Map for CraftMyPDF",
      "type": "n8n-nodes-base.code",
      "position": [
        -192,
        224
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "62b778a3-5663-4621-b7fb-d6795ef606b9",
      "name": "Create a PDF",
      "type": "n8n-nodes-craftmypdf.craftMyPdf",
      "position": [
        64,
        224
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "dbe95252-aadc-4e76-824f-9595e3ec55d2",
      "name": "Get PDF file",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        336,
        224
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "51aa3d33-2ed8-408e-8e44-109b4fed46d7",
      "name": "Email: Send Quote",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        576,
        224
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "5e113929-c891-4fba-a8a6-242e29937fc3",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1104,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2b96dde8-578f-42f5-97ff-dfe849de64c3",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Create a PDF": {
      "main": [
        [
          {
            "node": "Get PDF file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get PDF file": {
      "main": [
        [
          {
            "node": "Email: Send Quote",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Form: Request a Quote": {
      "main": [
        [
          {
            "node": "Google Sheets: Products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets: Products": {
      "main": [
        [
          {
            "node": "LLM: Select & Quote (JSON only)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code: Map for CraftMyPDF": {
      "main": [
        [
          {
            "node": "Create a PDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LLM: Select & Quote (JSON only)": {
      "main": [
        [
          {
            "node": "Code: Map for CraftMyPDF",
            "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

Turns a simple form submission into a polished, priced PDF quote—automatically. Captures lead details via Form: Request a Quote. Loads your Google Sheets catalog (SKUs, price, stock, min qty, etc.). Uses OpenAI to select SKUs and build a strict JSON quote (respects instock and…

Source: https://n8n.io/workflows/8239/ — 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

Grain Real Estate Land Showcase v1. Uses formTrigger, httpRequest, openAi, emailSend. Event-driven trigger; 13 nodes.

Form Trigger, HTTP Request, OpenAI +3
AI & RAG

Note: Now includes an Apify alternative for Rapid API (Some users can't create new accounts on Rapid API, so I have added an alternative for you. But immediately you are able to get access to Rapid AP

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

This system automates LinkedIn lead generation and enrichment in six clear stages: Lead Collection (via Apollo.io) Automatically pulls leads based on keywords, roles, or industries using Apollo’s API.

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

Goal: This workflow demonstrates the full fluidX THE EYE integration — starting a live session, inviting both the customer (via SMS) and the service agent (via email), and then accessing the media (ph

Form Trigger, Google Drive, Email Send +3
AI & RAG

This workflow turns a user-submitted form with country or animal names into a cinematic video with animated scenes and immersive ambient audio. Using GPT-4 for prompt generation, Dumpling AI for visua

Form Trigger, OpenAI, HTTP Request +2