Solved: 🚨 Gemini Script Extracts Data Perfectly — But App... - Page 2

Islom · 03-25-2025 09:25 AM

Hi everyone,

I’ve followed this excellent guide by Martin Hawksey to connect a Gemini-powered Apps Script function (jsonControlledImageExtraction) with AppSheet.

The script receives an image URL, extracts structured data using Gemini’s JSON schema, and returns a valid object. AppSheet automation is set up as:

•“Run a task” → “Call a script”
•Return type: Object

•Then → Set Values to map the output fields

✅The function runs fine, returns the expected object, and shows correct output in the logs.
❌However, the extracted values are not being written to Google Sheets.

Could it be a problem with:
•How Set Values is configured?
•Missing row context?
•Some sync issue between AppSheet and Sheets?

Would appreciate any insights or fixes — thanks in advance!

WillowMobileSys

@Islom wrote:

However, the extracted values are not being written to Google Sheets.

You need to access the Monitor Logs. At the top of your Bot is a "Monitor" button. Tap that and then access the "Runs" tab. Find the Bot execution entry and check the "Process Steps" panel on the far right to see the outcome of your Bot steps. Look at the "GeminiApp" step and confirm that you are getting a returned object in the Bot itself. If you are and the JSON object looks correct then it is a matter of making sure you are accessing the returned object correctly. See article below for details on how to use returned JSON objects.

Use return values from Apps Script Task

Also be aware that if you have any requirements or validation implemented, your row WILL be subjected to those while attempting to assign the Object values. You may need to look into the Audit Logs to see any violations of those conditions.

I hope this helps!

View solution in original post

🚨 Gemini Script Extracts Data Perfectly — But AppSheet Just Won’t Save It?!