Email Automation
Track laundry orders with Google Sheets, Gmail, Telegram, Discord, and GPT-4o
When an API call/webhook arrives, it handles email with OpenAI / ChatGPT using Discord, Gmail, Google Sheets, Telegram.
What it does
## Track laundry orders with a staff Telegram bot ### How it works 1. Your counter app posts each drop-off to the laundry/order webhook. Bad orders alert the owner on Telegram and Gmail. 2. Valid orders get an LDR order number and an AI agent classifies the fabric care, including same day care. 3. The order goes to the Orders tab, the customer gets a confirmation email, and same day orders ping Discord. 4. Staff text the bot "LDR-... ready" or "LDR-... picked". The order is found and its row updated. Ready orders email the customer a pickup notice and alert Discord, picked orders confirm back on Telegram, and both are logged to ActivityLog. 5. A daily sweep nudges customers whose ready order has waited a day or more, and escalates orders past their promise date by email and Telegram. Quiet days post an all clear to Discord. ### Setup steps - [ ] Create a workbook with Orders and ActivityLog tabs and select it in the Sheets nodes. - [ ] Connect Google Sheets and Gmail, and replace the owner address. - [ ] Create a Telegram bot, add it to the trigger and reply nodes, and set your chat id. - [ ] Connect a Discord bot and pick the alert channel. - [ ] Add an OpenAI credential on Care Classifier Model. - [ ] Point your counter app at the webhook and send one test order. ### Customization Change the care rules in the Classify Care prompt, the nudge and overdue rules in Compute Sweep Actions, or the sweep time.
The steps
- When Order Logged
- Normalize Order
- Valid Order?
- Generate Order Number
- Build Care Context
- Care Classifier Model
- Classify Care
- Parse Care Result
- Append Order to Sheets
- Build Confirmation Email
- Email Confirmation to Customer
- Reattach Care Flags
- Needs Same Day Care?
- Discord Same Day Alert
50 steps in total.
Similar automations
E-commerce & PaymentsSend Shopify Orders to Business Central Sales Orders31 stepsE-commerce & PaymentsSync Shopify Orders to Business Central Sales Orders131 stepsEmail AutomationTurn pool water tests into customer reports with Sheets, Gmail, Discord, and GPT-4o-mini34 stepsEmail AutomationTrack production OEE and corrective actions with Sheets, Gmail, Telegram, and GPT-4o44 steps