Gmail Integration in AppSheet: Now in Public Preview! (Beta)

AppSheet Announcements
37

From your response it sounds like you’re not a Google Workspace user? If you’re using AppSheet with Google Workspace then what have asked for is already covered by what Google Workspace offers, e.g.:

  1. a feature that gathers all emails in one place, keeping the conversation together in account view - Google Groups: this is the web interface that gives you an email-like interface where everyone can see the threads and mails

  2. it’s designed for multiple users, so it’s not just the admins who can import gmail data to it, but all the app users too - you can invite any user to see the Google Group, e.g. the AppSheet app owner and then the app owner account can import the mail into the app so all the app users can see what’s required. We currently do this already for our Helpdesk built in AppSheet:

    • Emails are sent from AppSheet with the reply-to address set to the group email address
    • Responses, therefore, go back to the group and get distributed to a Google Workspace account
    • The account filters the mail appropriately into a label and, at the moment, that account runs a Google Apps Script to push the email via the AppSheet API into the app; this feature means there’s no longer a need for the script or to open the API and AppSheet can monitor the email account and import the responses to the app. The script also adds to the app the URL of the message in the Google Group so if an app user wants to see the full message, or the entire thread, they use the link and go directly to it.

  3. AppSheet Gmail integration trigger can cover several niche or internal use cases (especially for single‑user workflows, testing, or centralized notifications), it is not yet suitable for the multi‑user, personalized, and dynamic B2B workflows typical in business settings - I would say you have been too hasty in arriving at that concusion, as we use this feature (currently via script, but will change to the AppSheet bot trigger) for a multi-user, personalized and dynamic B2B workflow, supporting our business customers. The only reason we do it via Apps Script at the moment is AppSheet couldn’t do it, but now it can.

  4. a more advanced solution that supports multiple user accounts would be required - why? Why are you sending the mails to individual accounts rather than a centralised group? I’m sure there is a very valid reason, or it may be an approach you want to change and use the Google Groups option, if that’s available to you.

I hope this perspective is useful to you.

5 Likes