Send post-purchase email sequences with Postgres, Gmail and OpenAI

How it works

This workflow automates customer communication after an order is placed. It detects new orders, sends a confirmation email, waits until delivery is completed, and then follows up with AI-generated product tips. Finally, it sends AI-powered upsell recommendations after a defined delay. The workflow runs on a schedule and requires no manual handling.

Step-by-step

• Step 1 — Order detection and confirmation

  • Schedule Trigger – Runs at a fixed interval to check for new orders.
  • Postgres – Execute a SQL query – Fetches recently created orders from the database.
  • Gmail – Send message – Sends an order confirmation email to the customer.

• Step 2 — Delivery status monitoring

  • Wait – Pauses the workflow until the expected delivery window.
  • Postgres – Select rows – Checks the delivery status of the order.
  • If – Verifies whether the product is marked as delivered.
  • Wait – Delays one day and repeats the check if delivery is not completed.

• Step 3 — Product usage tips (AI)

  • OpenAI – Message a model – Generates short and practical usage tips for the product.
  • Code – Formats the AI output into clean HTML bullet points.
  • Gmail – Send message – Emails the usage tips to the customer.

• Step 4 — Upsell recommendations (AI)

  • Wait – Delays for two weeks after tips are sent.
  • OpenAI – Message a model – Creates complementary product recommendations.
  • Code – Formats the recommendations for email delivery.
  • Gmail – Send message – Sends the upsell email to the customer.

Why use this?

• Ensures timely and relevant customer communication
• Prevents sending tips before the product is delivered
• Improves onboarding with AI-generated usage guidance
• Increases repeat purchases through smart upsell emails
• Fully automated using database, email, and AI integrations