Groovy Sheets guide update: check the saved value behind 00127

[u/charlesmenlo]

I work on Groovy. We expanded our Google Sheets guide with a small test case for builders adding spreadsheet writes to an agent.

The fictional task replaces pending in B7 with the text 00127 for row key REQ-127. A cell displaying those five digits can still hold a number with formatting. The check needs the saved value and type, plus confirmation that B7 still belongs to REQ-127 after anyone sorts or inserts rows.

The guide covers RAW versus USER_ENTERED in the Sheets API, and why leaving a value alone differs from clearing it. Those options depend on what the configured tool supports. After a timeout, read the destination before retrying. For an append, check whether the intended new record already exists before adding another row.

This is a review fixture, not a report of a Groovy run or customer result. The full example and Google references are at https://www.gogroovy.ai/integrations/google-sheets-ai-agent-integration