This use case integrates with the PaLM 2 for Text model in Vertex AI via an API connection. Vertex AI has a slew of pre-trained models that can be used out of the box or tuned for specific tasks. The connection details are similar across models. So once you get this app up and running, you can apply the same design to integrate with other models too. Detailed connection information below.
Check out this recorded demo of the user experience
This example uses a Payroll and HR team. These roles can be generalized to “Client” and “Support Desk”. The Payroll team (or client) represents a group of people who occasionally need help with particular issues. The HR team (or support desk) represent a group of people who must prioritize, organize, and respond to requests.
Other examples of this are:
Sticking with the Payroll and HR team example, there are two primary roles, each with a few requirements:
The diagram below depicts the process flow:
This app uses Apps Script to monitor an inbox for new messages. It is easiest for the account that receives incoming emails to also own the AppSheet app and Apps Script project. This isn’t strictly necessary, but it is a good starting point.
Resources:
Follow these steps to configure a GCP Project with access to Vertex AI. See this page for pricing. The cost for an experimental version of this app will be very low. Ballpark estimate is about $5 per 1000 iterations of the full process.
Complete these steps to customize the Apps Script project:
The Apps Script has a couple dependencies. Both will copy over if you copy the Apps Script project into your account. So this is just FYI:
Follow these steps to make sure it’s working:
I kept the app relatively simple. There are always lots of bells and whistles that can be added. Watch the ‘how it’s made video’ for a walkthrough of the nifty design patterns in this app.
Hi @derekco ,
First of all, thanks for this post. I am currently diving deeper into Vertex AI <--> AppSheet integration and it helped me a lot. For now, I am wondering if it is possible to make this applicable to more than just one Gmail Inbox. I am not sure how to accomplish that because when AppSheet is deployed under account X, it has access to GAS projects deployed on that same account and GmailApp Class gets access to the project owner's Google account. This is something tricky for me. I am not sure how to approach this. Maybe I need to authorize to get emails and threads from another account (within the organization)? Maybe you know how to do this? 😊
Cheers!
Hi Mateo,
The inbox monitoring part could be deployed on multiple accounts. Each user would need to copy the Apps Script template into their account. Then create a trigger to run the function on a schedule. Emails from each inbox would be saved in the data source connected to the AppSheet app and appear in the AppSheet dashboard.
There are a lot of cool use cases for Apps Script + AppSheet. However, the Apps Script side is outside of the no-code envelope. Google Partners are the best source for implementation support if you want to dive deeper into Apps Script.
https://cloud.google.com/find-a-partner/?search=Apps%20Script
Thanks, @derekcoI will consider the multi-layer deployment.
Amazing! Thank you for sharing this tip @derekco , I can't wait to give it a try!
This is really useful @derekco
Thanks for taking the time to write this up!