We recently built an order tracking system for a client in Retool, where employees had to copy details from customer emails into a form. Way too much repetitive typing...
Instead, a Retool Workflow grabs the email, parses it with AI, then inserts the results back into the DB, almost in real time.
Here’s a quick breakdown on how to achieve the same thing: Article
Thanks for sharing @Backofficely
I feel like having something similar where it incoming emails get categorized as to-do's or linear/jira tickets especially if its a large shared inbox
Kudos @backofficely!
I've been looking for a way to forward e-mails directly to Retool (Forwarding Google Workspace/Groups Emails to Retool Workflows) but got stuck. I'm now left to get Intercom conversation over API instead of directly routing e-mails to a Retool workflow...
How did you achieve this?
Thx!
Seems like something along the lines of watching a DB:
Incoming email gets saved in Postgres (we store subject, body, and attachments, Retool Workflow triggers whenever a new row is inserted
If you don't want to go that route, it's worth noting that agents in Retool can also be triggered directly via email.
These can then have a workflow or any number of other tools configured to take action based on the contents of that email.
You can set it up like this: Gmail sends a push notification to Cloud Pub/Sub every time a new message lands in the inbox. Pub/Sub then triggers a Cloud Function, which connects back to Gmail to pull down the actual message.
