I’m developing an app via AppSheet for the non-profit this account is linked to. I just came across AppSheet yesterday and got an account set up in their Google Workspace, and I’ve been able to get some awesome stuff set up really quickly.
I’ve started working on setting up an email automation flow this afternoon and have run into the recent change that restricts some AppSheet accounts from sending emails outside their workspace domain. Disabling out-of-domain automation emails for improved security
Based on the wording of the announcement, it sounds like it wasn’t going to apply to Workspace accounts that existed prior to the stated date, even if they hadn’t created an AppSheet account until after the deadline in the announcement. The workspace attached to this account has definitely existed prior to the stated deadline, though I did just create the AppSheet account yesterday.
In any case, is there a way to submit a request for an exemption so that this workspace’s AppSheet account could be allowed to send emails outside of its own domain?
So far I haven’t received any updates on whether the exemption request has been approved or not.
In the meantime, I’m in the process of exploring other options. The most promising one is that I’ve set up an Apps Script with a function that sends email from one of the Gmail accounts in the org’s workspace. I imported that script into the AppSheet application and have been able to get an email sent to an external account via an automation that calls the function from that script. This might be good enough (or even better) for what I needed. I’m still working through it and testing it, but it looks promising so far at least.
You can integrate an external email provider assuming they provide an API - I believe GMail and Outlook are such providers.
There are solution integrators such as Zapier and Make that can connect your AppSheet apps to several different email providers as well as thousands of OTHER services you might find useful.
I know that make integrates with AppSheet (i.e. you can send data back into your AppSheet apps) and they provide a certain level of service for free.
Yeah, I didn’t want to interact with another 3rd party provider since you either have to pay or their free tiers tend to not be great. The organization already has a paid Google Workspace and I want to be able to leverage what is being paid for there.
And yep, you’re right about it being able to integrate with Gmail - I mentioned in the post you’re responding to that that’s what I’ve been exploring and it seems to be working, so that is likely the solution I will ultimately go with.
That solution is better overall since the emails will be sent from a branded account inside the workspace instead of the generic noreply address from the AppSheet domain. It requires you to do a little coding via AppScript, which I was trying to avoid since I’m trying to build something that will be maintainable in the future by a non-software engineer, but this integration feels minimal enough to be okay.
edit: I’m going to go ahead and mark this as the solution since it’s basically what I’m going to wind up doing.