Create and send quote PDFs with OpenAI, Gmail and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 52 nodes and runs on Google Sheets events (plus 3 other triggers). Along the way it connects Google Sheets, OpenAI Chat Model, Google Drive and Gmail and 1 more.
How it runs
Trigger: On Google Sheets events (plus 3 other triggers).
- Freigabe prüfen (If): checks a condition and branches into true / false
- Anfrage vollständig laden (Gmail): get
- Freigabe der Preisanfrage prüfen (If): checks a condition and branches into true / false
- Händlerantwort aufbereiten (Code): runs custom JavaScript code
- Angebotsdaten berechnen (Code): runs custom JavaScript code
- E-Mail-Daten vorbereiten (Code): runs custom JavaScript code
- PDF-Anhang vorbereiten (Code): runs custom JavaScript code
- Preisanfrage an Grosshaendler senden (Gmail): uses Gmail
- Händlerangebot auswerten (OpenAI): uses OpenAI
- Angebotstext erstellen (AI Agent): runs an AI agent, with model: OpenAI Chat Model
…plus 36 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Google Drive
n8n-nodes-base.googleDrive - Gmail
n8n-nodes-base.gmail - Gmail Trigger
n8n-nodes-base.gmailTrigger - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Extract from File
n8n-nodes-base.extractFromFile - Merge
n8n-nodes-base.merge - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick Overview This workflow uses Gmail, Google Sheets, Google Drive, and OpenAI to turn incoming customer quote requests into draft offers, generate and email approved offers as PDFs, create and send supplier price inquiries, and evaluate and compare…