tanaike

The Thinker

Inserting Animated GIFs over Cells on Google Sheets using Google Apps Script

Gists Overview This script demonstrates how to insert an animated GIF over cells in a Google Sheet using Google Apps Script. Description I recently received a request to create a Google Apps Script for inserting animated GIFs into cells on a Google Sheet. I previously published a sample script on my blog on June 6, 2017. Ref In that script, the animation GIF was inserted using a public link. This new script leverages data URLs, which simplifies the process for using GIFs stored in Google Drive.

Taming the Wild Output: Effective Control of Gemini API Response Formats with response_mime_type

Gists Abstract This report explores controlling output formats for the Gemini API. Traditionally, prompts dictated the format. A new property, “response_mime_type”, allows specifying the format (e.g., JSON) directly. Testing confirms this property improves control over output format, especially for complex JSON schemas. The recommended approach is to combine a detailed JSON schema with “response_mime_type” for clear and consistent outputs. Introduction One of the key challenges when working with the Gemini API is ensuring the output data is in the format your application requires.

GAS Library - GeminiWithFiles

Overview This is a Google Apps Script library for Gemini API with files. A new Google Apps Script library called GeminiWithFiles simplifies using Gemini, a large language model, to process unstructured data like images and PDFs. GeminiWithFiles can upload files, generate content, and create descriptions from multiple images at once. This significantly reduces workload and expands possibilities for using Gemini. Description Recently, Gemini, a large language model from Google AI, has brought new possibilities to various tasks by enabling the use of unstructured data as structured data.