{"product_id":"n8n-ai-quote-generator-gmail-pdf-offers-with-openai","title":"n8n AI Quote Generator: Gmail → PDF Offers with OpenAI","description":"\u003ch3\u003eTurn Incoming Gmail Quote Requests into Professionally Generated PDF Offers (with OpenAI)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reads customer quote requests from \u003cstrong\u003eGmail\u003c\/strong\u003e, extracts project details using \u003cstrong\u003eOpenAI\u003c\/strong\u003e, drafts an offer in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates a German offer document as a \u003cstrong\u003ePDF\u003c\/strong\u003e in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and emails it back to the customer—then optionally handles supplier price inquiries from Leistungsverzeichnis requests.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMinute-by-minute Gmail intake:\u003c\/strong\u003e Every minute, it triggers when a new Gmail message matches the configured search, loading the full email content and any attachments.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI-assisted data extraction:\u003c\/strong\u003e Using \u003cstrong\u003eOpenAI\u003c\/strong\u003e, it extracts customer and project details. If a PDF attachment is present, it reads PDF text and uses it for extraction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreate offer draft in Google Sheets:\u003c\/strong\u003e It writes a new offer row to Google Sheets with a generated offer number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate approved offer text (German):\u003c\/strong\u003e Every minute on Google Sheets changes, when an offer row is marked \u003cstrong\u003eFREIGEGEBEN\u003c\/strong\u003e, it validates required fields, calculates totals\/dates, and uses OpenAI to generate the offer text in German.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProduce and send PDF:\u003c\/strong\u003e It creates a Google Docs offer document in \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, exports it to \u003cstrong\u003ePDF\u003c\/strong\u003e, stores the PDF, writes the PDF link back to the sheet, downloads the stored PDF, emails it to the customer via Gmail, and updates the status to \u003cstrong\u003eVERSENDET\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupplier inquiries from Leistungsverzeichnis:\u003c\/strong\u003e If the extracted email indicates a \u003cem\u003eLeistungsverzeichnis\u003c\/em\u003e, it creates a supplier price inquiry draft in a separate Google Sheets tab, emails it to the wholesaler when marked \u003cstrong\u003eFREIGEGEBEN\u003c\/strong\u003e, and updates the inquiry status to \u003cstrong\u003eVERSENDET\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSMBs and SaaS operators needing an \u003cstrong\u003eAI quote generation\u003c\/strong\u003e workflow from customer emails to PDF offers.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building \u003cstrong\u003edocument automation\u003c\/strong\u003e with \u003cstrong\u003eGmail → Google Sheets → Google Drive → PDF → email\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTeams processing construction\/contract quote requests where \u003cem\u003eLeistungsverzeichnis\u003c\/em\u003e enables supplier price comparisons.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Gmail, Google Sheets, Google Drive, OpenAI.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, and Gmail-trigger based processing.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46114607890611,"sku":"N8N-20028","price":68.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gV-bSyKe1_Cs0NQ-GxD3j_1GjFvzsV.png?v=1790586302","url":"https:\/\/buyflowscripts.com\/products\/n8n-ai-quote-generator-gmail-pdf-offers-with-openai","provider":"N8N Commerce","version":"1.0","type":"link"}