Most online stores lose a large share of their shoppers at checkout. They add items to their cart, get distracted, and never come back. This workflow wins some of those sales back automatically, with no manual follow-up.

What it does When a customer abandons a cart, the workflow logs it and waits. If the customer hasn’t bought after 1 hour, it sends a friendly reminder email. If they still haven’t bought 24 hours later, it sends a stronger “last chance” email with a discount code. Customers who buy at any point never get another email.

How it works

A webhook receives the abandoned-cart event (customer name, email, cart items, Cart ID).

The cart is logged to Google Sheets with the status pending.

The workflow waits 1 hour, then re-reads that cart’s row so it sees the latest status.

If the status isn’t purchased, a personalised reminder goes out through Gmail and the status becomes reminder 1 sent.

After a further 24 hours, the status is checked again. If the customer still hasn’t bought, a final email with a discount code goes out and the status becomes reminder 2 sent.

A separate purchase workflow updates the sheet to purchased as soon as an order completes, which stops the sequence.

Why it’s reliable

Every cart is tracked by its own Cart ID, so simultaneous customers never overwrite each other.

The status is re-checked after every wait, so nobody gets a reminder after they’ve already bought.

The Google Sheet works as a live dashboard of where every cart stands.

Tools used: n8n, Webhooks, Google Sheets, Gmail, Wait and IF logic.

Smart workflow! 🙌 I like how the purchase checks prevent unnecessary follow-ups and keep the customer experience smooth.

🚨 A dental clinic was losing patients every single day.

Not because of bad service. Not because of high prices.

Because nobody was replying to messages.

Patients messaged on WhatsApp, Messenger, SMS… And waited. And waited. And left.

The clinic owner contacted me with one simple ask: “I can’t hire someone to reply 24/7. Can you help?”

So, I built them an AI receptionist that never sleeps. 👇

Here’s exactly what it does:

✅ Omnichannel Support: Instantly replies to patients on WhatsApp, Facebook Messenger & SMS — all from one system. ✅ Human-like AI: Google Gemini AI understands the message, detects intent, and replies naturally. ✅ Smart FAQ Handler: Answers questions about services, pricing & clinic hours by pulling live data from Google Sheets. ✅ Automated Booking: Checks availability, blocks double-bookings, and confirms only after saving to the sheet. ✅ Instant Alerts: Notifies the clinic owner instantly via Gmail + Telegram on every new booking. ✅ Smart Reminders: Sends automated email reminders — 2 hours and 1 hour before the appointment. ✅ No-Show Recovery: Detects missed appointments and automatically sends a polite rescheduling email after 12 hours.

The Tech Stack 🛠️:

⚙️ Make.com — Automation backbone 🧠 Google Gemini 2.0 Flash — AI brain 📊 Google Sheets — Live clinic database 💬 Green API — WhatsApp integration 📱 Facebook Messenger API & Twilio — Chat & SMS ✉️ Brevo — Email reminders 📢 Telegram Bot — Owner notifications 💾 Make.com DataStore — Conversation memory per patient

The Result? 📈

Every patient gets an instant, intelligent reply — 24/7. No missed bookings. No forgotten appointments. No manual follow-ups.

The clinic owner now wakes up to confirmed appointments already in the sheet with zero manual effort.

This is what I build for businesses. If you’re still replying manually and losing leads while you sleep — DM me. Let’s fix that. 👇

#MakeAutomation #AIAutomation #NoCode #Makecom #GeminiAI #WhatsAppAutomation #BusinessAutomation #AIReceptionist #FreelanceAutomation #Upwork #Fiverr

Nice build, and very close to a WhatsApp assistant I just built for a dental-clinic use case on the WhatsApp Cloud API. Two things mattered a lot in testing: when a patient asks for a person, the bot has to go completely quiet for that chat until the owner hands it back, and the...