{"product_id":"catering-event-quote-workflow-postgres-gmail-telegram-openai","title":"Catering Event Quote Workflow: Postgres, Gmail, Telegram \u0026 OpenAI","description":"\u003ch3\u003eCatering Event Quote Workflow with Postgres, Gmail, Telegram \u0026amp; OpenAI\u003c\/h3\u003e\n\u003cp\u003eTurn every catering inquiry into a complete, automated sales-and-ops flow: intake webhooks, OpenAI-generated quote emails, Postgres event tracking, Gmail client delivery, and Telegram alerts for owners and daily countdown reminders.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation manages catering events end to end through three webhook stages—intake, updates, and completion—while keeping data organized in Postgres and communication routed to the right people.\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003e1) Intake (Inquiry Webhook):\u003c\/strong\u003e Receives a catering inquiry payload, validates required fields, and notifies ops via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e if the payload is invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e2) Quote generation \u0026amp; client email:\u003c\/strong\u003e For valid inquiries, \u003cstrong\u003eOpenAI\u003c\/strong\u003e drafts a quote email using event details and predefined package options, then the workflow stores the event in \u003cstrong\u003ePostgres\u003c\/strong\u003e, emails the client via \u003cstrong\u003eGmail\u003c\/strong\u003e, and alerts the owner via \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e3) Event updates (Update Webhook):\u003c\/strong\u003e Validates update payloads, checks the event exists in \u003cstrong\u003ePostgres\u003c\/strong\u003e, and sends Gmail\/Telegram alerts to ops if the update is invalid or tied to an unknown event.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e4) Deposit handling \u0026amp; confirmations:\u003c\/strong\u003e For valid updates (including “deposit received”), updates the Postgres record, emails the client confirmation via Gmail, logs communications, and alerts the owner via Telegram.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e5) Completion (Completion Webhook):\u003c\/strong\u003e Validates final headcount, checks the event in Postgres, and alerts ops via Gmail and Telegram if completion data is invalid or unknown.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003e6) Final invoice \u0026amp; review request:\u003c\/strong\u003e For valid completions, \u003cstrong\u003eOpenAI\u003c\/strong\u003e drafts a final invoice email plus a short review request; both are emailed via Gmail, logged, and a Telegram completion notification is sent.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate quote emails for catering inquiries without manual copywriting.\u003c\/li\u003e\n  \u003cli\u003eEnsure updates (changes, deposit received, final headcount) always reach clients and owners reliably.\u003c\/li\u003e\n  \u003cli\u003eRun ops alerts through Telegram and Gmail when payloads are invalid or events are missing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e \u003cstrong\u003ewebhook\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003epostgres\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore behaviors:\u003c\/strong\u003e request validation, Postgres event lookup\/update, OpenAI email drafting, Gmail delivery, Telegram owner\/ops notifications, and completion\/review messaging.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45985492009139,"sku":"N8N-19414","price":24.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/EeeuETeFznSAuSZk75a2B_07L5bnNE.png?v=1788944676","url":"https:\/\/buyflowscripts.com\/products\/catering-event-quote-workflow-postgres-gmail-telegram-openai","provider":"N8N Commerce","version":"1.0","type":"link"}