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.