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

Description

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