GeminiWithFiles was updated to v1.0.2.

• v1.0.2 (May 7, 2024)

  1. For generating content, parts was added. From this version, you can select one of q, jsonSchema, and parts.
  2. From this version, systemInstruction can be used.
  3. In order to call the function call, toolConfig was added to the request body.

You can see the detail information here https://github.com/tanaikech/GeminiWithFiles

UtlApp was updated to v1.0.6.

• v1.0.6 (May 4, 2024)

  1. Methods of blobToDataUrl was added. When this method is used, the Blob data can be converted to the data URL.

You can see the detail information here https://github.com/tanaikech/UtlApp

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. Since this approach might be helpful to others, I’m sharing it here.

GeminiWithFiles was updated to v1.0.1.

• v1.0.1 (May 2, 2024)

  1. response_mime_type got to be able to be used for controlling the output format. Ref

You can see the detail information here https://github.com/tanaikech/GeminiWithFiles

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. Traditionally, the response format heavily relied on the specific prompt you provided. For example, retrieving data as a JSON object necessitated including a “Return JSON” prompt within your input text. This approach could be cumbersome and introduce potential errors if the desired format wasn’t explicitly requested.

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. This is particularly significant because a vast amount of information exists in unstructured formats like text documents, images, and videos.

Gists

Abstract

A new Google Apps Script library, “GeminiWithFiles”, simplifies using the powerful Gemini 1.5 AI model. It lets users directly upload files for content generation or create descriptions for many images at once, making it much faster than prior methods. This is helpful for tasks involving large amounts of text or images.

Introduction

Recently, Gemini, a family of Google’s most capable AI models, has revolutionized various tasks by allowing unstructured data to be used as structured data. This breakthrough is particularly impactful for tasks involving large amounts of text or images.

RichTextAssistant was updated to v1.0.1.

• v1.0.1 (April 22, 2024)

  1. From oshliaer’s report, a bug was removed. In the current stage, when RichTextValueBuilder is used, it seems that when setTextStyle is used after setLinkUrl, the style of the hyperlink is removed while the link is kept. So, it is required to set setLinkUrl after setTextStyle.

You can see the detail information here https://github.com/tanaikech/RichTextAssistant

UtlApp was updated to v1.0.5.

• v1.0.5 (April 16, 2024)

  1. Methods of consolidateA1Notations was added. When this method is used, the scattered A1Notations can be consolidated.

You can see the detail information here https://github.com/tanaikech/UtlApp

Gists

Abstract

Consolidate scattered cell references (A1Notation) in Google Sheets for efficiency. This script helps select cells by background color or update values/formats, overcoming limitations of large range lists.

Introduction

When working with Google Spreadsheets, there might be a scenario where you need to process scattered A1Notations (cell addresses in the format “A1”). This could involve selecting cells with specific background colors, updating cell values, or modifying cell formats.