I’m still thinking about how to integrate some AI into my AppSheet application. I would like AI to assist users by generating text. I’ve come up with some ideas and approaches to achieve this, but they aren’t easy.
My vision is mainly that the user would fill out a form, enter some fields, such as a name, and AI would use this name to generate a description field. That is, the prompt would be something like: ‘Create a professional description of the object named XYZ that is at least 100 words long.’ Of course, I would also like the possibility to generate descriptions of uploaded photos based on specific input.
I know that Google, with Gemini, is making strides to help creators develop AppSheet applications, but I’m currently focused on how to enable Gemini, or even ChatGPT, to assist the users of the application directly.
I’m interested in whether Google has mentioned any plans in this regard in the near future or if there are any detailed resources on the topic. I haven’t been able to find much so far.
You can definitely do this using the call a script automation task. When someone submits text into the field(s), you can package all of them up and send them off to an Ai API for an answer inference; in your automation you can use the return value feature to then take the returned answer and record the details into your app.
You can learn a little about the basics of how to get all the moving parts in place (using OpenAi) for this with these videos:
Note: The videos are from when all of this Ai stuff came out, so they use older models that are no longer functional; however the fundamentals of the 1, 2, 3 of getting things to work (aside from the prompt syntax structure) are the same.
Examples
Newsletter Maker
I’ve got an app available to my supporters that’s a fully functional Newsletter Maker/Distribution app
You can build newsletters, using Ai to enhance and automate
You can enter a brain storm, and the Ai takes that and fills in the various elements for each section
Ai can create an opening/summary of the newsletter
It can help you refine and expand content
So much more possible…
Distribute the newsletter as email or PDF file to email lists easily
The following is a video highlighting another app available to my supporters that allows for the creation of labels in Gmail that are tied to Ai responders.
I’ve got tons of resources for this sort of Ai stuff, most notably a library script I’ve been using for years now to make all the back-and-forth with the AppSheet API easier.
