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.