Operations & Internal Tools
Connect Mailgun and Retool
Emailed requests become records your team can check and act on, in one internal tool.
- Data flows
- 4 automated, two-way where safe
- Built with
- Mailgun, Retool, OpenAI
- Timeline
- Live in 2 to 8 weeks from scope
- Owned by
- You, with accounts, credentials and code in your name.
Connecting Mailgun to Retool turns inbound email into records in an internal tool, so staff check and act on them without retyping. SBD built an enquiry platform for an industrial distributor that reads emailed RFQs with AI and matches parts against the SAP item master, with Mailgun and Retool in the stack.
What runs between Mailgun and Retool
Each line is one automated workflow, with the same checks, logs and alerts on all of them.
-
RFQs read from email
WhenAn email reaches the inbound address
ThenVerify the Mailgun signature, store the message and attachments, and create a record
-
Purchase orders turned into records
WhenA record is created
ThenExtract the requested items with AI and score its confidence
-
Supplier invoices captured
WhenItems are extracted
ThenMatch them to your item master and show them in Retool
-
Attachments stored against each record
WhenA match is uncertain or the email cannot be read
ThenSend it to a review queue with a named owner and the original attached
Where the simple setup breaks down
A one-step Zap connects Mailgun and Retool in an afternoon. This is what goes wrong once volume grows.
Retool does not receive email on its own
A Retool app needs something in front of it to accept the message. Mailgun receives it and posts to an endpoint, which must store the data first, because a failed write would otherwise lose the email.
The useful part is often in the attachment
RFQs and purchase orders commonly arrive as PDFs or spreadsheets. An email body alone misses the data, so attachments have to be stored against the record and read separately.
The same request arrives more than once
Customers forward, reply and resend. Without a check on message IDs and thread content, one enquiry becomes three and staff quote it twice.
An AI reading has to be checkable
If the app shows only the extracted fields, nobody can tell when the AI misread a part number. Keeping the original email beside the result, with a queue for uncertain matches, is what makes staff trust it.
Used for
- RFQs read from email
- Purchase orders turned into records
- Supplier invoices captured
- Attachments stored against each record
- Mailgun inbound routes to Retool
- AI extraction with human review
- Part number matching
- Review queues in Retool
- Email to internal tool workflows
- Duplicate enquiry detection
Built with
- Mailgun
Retool
OpenAI
Cloudflare- Your ERP or database
Standards on every build
Validation, retries, reconciliation, audit logs and alerts come as standard, with credentials and accounts in your name. Read the integration standards
Where we have done this
What people ask about this pair
Do we have to change our email address?
Usually not. You can forward an existing address such as sales@ to the inbound address, so customers keep writing to the one they know.
Will the AI make mistakes?
Yes, sometimes, especially with part numbers written in many forms. Uncertain results go to a person, and the original email sits beside the result so checking is quick.
Can this work with something other than Retool?
Yes. Mailgun only needs an endpoint to post to. Retool suits an internal review screen, and the same intake can feed another app.
Related pairs
-

Airtable and Retool
Airtable is a good database with a limited interface. Retool adds the screens and permissions it lacks.
-

Retool and Supabase
Screens in Retool, data in a Postgres database you own and can expose safely.
-

Supabase and Resend
Each email sent once from your own domain, with the delivery record stored.
- Solution
Sales and RevOps
The workflows we automate for this kind of team.
Connect Mailgun and Retool
Emailed requests become records your team can check and act on, in one internal tool.
Start with a discovery call












