How I connected Gemini AI to AppSheet using Apps Script (no webhook needed)

AppSheet Tips & Tricks
1

Been experimenting with connecting Gemini directly to AppSheet through Apps Script. The setup is pretty simple, you add a script to your sheet, set the API key in Script Properties, then call it from an AppSheet bot using “Call a script.”

What I’m using it for:

  • Classifying uploaded documents (type, language, confidence score)

  • Extracting fields from invoices (vendor, amount, date)

  • Analyzing text inputs for sentiment

The Gemini API free tier (15 req/min) handles it fine for most use cases.

I cleaned up the code and put it on GitHub if anyone wants to try it: link

Anyone else working with Gemini + AppSheet? What are you using it for?

4 Likes