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