Send AI-powered post-purchase emails and WhatsApp messages from PostgreSQL to Google Sheets with Groq

How it works This workflow automatically detects completed orders in PostgreSQL and prepares them for AI-based post-purchase communication. It enriches each order with customer, product, and payment data, then generates a personalized message using an AI agent. The message is delivered via email and WhatsApp and finally logged in Google Sheets for tracking and auditing.

Step-by-step

- Step 1: Fetch and prepare completed orders for AI processing - Postgres Trigger – Watches the orders table for updates and initiates the workflow. - Postgres (Execute query) – Fetches only orders marked as completed. - Split In Batches – Loops through completed orders safely and sequentially. - Postgres (Execute query) – Retrieves full customer, product, and payment details using joins. - AI Agent – Generates a personalized post-purchase message using order data. - Groq Chat Model – Supplies the language model used by the AI agent. - Merge – Combines AI-generated text with database results for downstream use.

- Step 2: Deliver messages and log post-purchase communication - Code – Formats AI output into clean email and WhatsApp message templates. - Gmail – Sends the post-purchase email to the customer. - WhatsApp – Sends the same message via WhatsApp. - Set – Flags email and WhatsApp messages as successfully sent. - Google Sheets – Appends customer, order, and communication details. - Wait – Pauses before continuing to process the next completed order.

Why use this? - Automates post-purchase communication with zero manual effort. - Ensures consistent, personalized messaging across email and WhatsApp. - Adapts message tone automatically based on payment status. - Creates a centralized audit log in Google Sheets. - Scales easily as order volume grows.