I'm using Airtable as an operations management system for a catering business. When a delivery is confirmed, it automatically sends a confirmation email to the client from our Google Workspace email address.
I've gone through a few iterations trying to get this working properly and keep hitting walls:
Airtable native Gmail integration - Works but strips HTML formatting, so emails arrive as plain text (or at least I couldn't get HTML rendering reliably).
Make.com with Gmail module - This worked well for most clients, but some Outlook users with stricter security settings were receiving the raw HTML code as plain text rather than a rendered email. My understanding is it was a MIME formatting issue where Outlook wasn't recognising the content type correctly and just dumping the HTML source.
Things I've explored since:
- Twilio (our account is deactivated, don't want to create a new one)
- Brevo (ran into IP/deliverability issues on the free plan)
- Google Apps Script web app (seems like it could work but feels like a lot of overhead for what should be a simple send)
Has anyone solved this cleanly? Ideally I want something that:
- Sends from our actual Google Workspace email
- Supports proper HTML (we're using MJML-compiled templates)
- Handles Outlook correctly with proper multipart MIME
- Is either free or very low cost
- Can be triggered via webhook or Airtable script automation
Open to suggestions, including whether Google Apps Script is actually simpler than I'm making it out to be.