Using generative AI in Appsheet - not for creating Apps

[RoryF]

Hi everyone..

I have an AI related question.  We have a combination of web services that fill a Google Sheet with user data, and then we have an Appsheet App that renders this data in a dashboard.  It's a reasonably rich data set, so now we are looking at adding a generative AI component to the dashboard that will use this data (based on user filters) and generate summary data per user on request.  So we need AI within Appsheet to create content from data that the rest of the Appsheet App is using.  We do not need AI to generate an App (unless that is the only way to then have an AI component to generate summary data). We had a consultant lined up to assist but their availibility has been pushed out to sometime next year, and I would like to get something in place sooner than that.  

Does anyone know of a consultant (recomendation) who would be familiar with generative AI in this context?  Or any other avice would be welcome.

Thanks,

RoryF

[Suvrutt_Gurjar]

Please take a look at the following my tip on using GEMINI AI API with AppSheet app.

Integrate AppSheet with Google Gemini AI API using... - Google Cloud Community

Please DM me if you are looking for more specific assistance.

[RoryF]

Thanks Suvrutt... I will take a look and see what is involved. I also appreciate the offer of the DM if I have any issues..

Regards

RoryF

[Rifad]

---

@Suvrutt_Gurjar wrote:

The overview block diagram of the code implementation is as follows:

Show More

---

@Suvrutt_Gurjar  I took this idea bit seriously and went ahead and did a complete order capture automation using AI. This is how it looks in the appsheet. It does bunch of processing and RAG to align well within rules.

I did this with GAS But as it got soo much I moved it to Make.com like this

And the document for RAG looks like this

Surprisingly Gemini Flash itslef was performing well for this usecase

[Suvrutt_Gurjar]

Great @Rifad . Excellent to know the extension of tip in the practical world. Afterall tips are meant to be a seed for further growing a large tree which you have nicely done.

[Rifad]

Yes, the only issue preventing this impactful effect is Appsheet itself. Multiple API calls are triggered, and by the time the response from Make.com is directly returned to the same row in Appsheet, the user has already made multiple edits in the same row in the UI. The response from Make.com usually takes 10-15 seconds, but the user interactions overwrite the Make.com update API, and these updates from AI go into a black box. I’m trying to solve this issue.

[Suvrutt_Gurjar]

Okay ,got it- the inherent processing time of intermediate tools- Make.com , Zapier , IFTTT etc.

[Witan]

Any news? 

[MaelBresail]

I had a similar need and found it useful to bring AI-generated content into AppSheet using external tools. What worked for me was using https://silkplm.com/product-description-generator/ to create fast descriptions based on product inputs, then pulling that data into AppSheet through a webhook or script. It's not built-in, but combining the two saved me tons of time rewriting similar details across entries.