UtlApp was updated to v1.0.11.

• v1.0.11 (June 14, 2025)

  1. The method getInfFromBlob was added.

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

UtlApp was updated to v1.0.10.

• v1.0.10 (June 13, 2025)

  1. The method getMP3Tag was added.

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

UtlApp was updated to v1.0.9.

• v1.0.9 (June 13, 2025)

  1. The method convertL16ToWav was added.

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

MCPApp was updated to v2.0.0

• v2.0.0 (June 12, 2025)

  1. From v2.0.0, both the MCP client and the MCP server can be built by Google Apps Script.

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

Gists

Abstract

This report details an MCP network using Google Apps Script for both server and client, enabling automated, secure Gmail processing to boost efficiency.

Introduction

Recently, I published a report titled “Building Model Context Protocol (MCP) Server with Google Apps Script,” which you can find here. In that initial report, I demonstrated the feasibility of creating an MCP server using Google Apps Script, with Claude Desktop serving as the client.

Gists

Description

This script provides a simple example for generating Text-To-Speech (TTS) using the Gemini API within Google Apps Script. The Gemini API generates audio data in the audio/L16;codec=pcm;rate=24000 format, which is not directly playable. Since there’s no built-in method to convert this to a standard audio/wav format, this sample script includes a custom function to handle the conversion.

Limitations and Considerations

• The provided convertL16ToWav_ function is specifically designed for the audio/L16;codec=pcm;rate=24000 MIME type. Using it with other audio formats will result in an error.
• The script uses a hardcoded WAV header. This header assumes specific audio parameters (e.g., sample rate, bit depth, number of channels) that match the Gemini API’s output for this format. If the Gemini API’s output format changes, this header might need adjustment.

Sample Script

Before running, replace "###" with your actual Gemini API key in the myFunction.

Gists

Abstract

This report investigates how Gemini handles current time information, particularly when using the Gemini API. We found that while the Gemini web interface knows the current time, the Gemini API does not inherently. Therefore, applications must explicitly provide current time information in API calls for accurate time-sensitive responses.

Introduction

The rapidly advancing field of generative AI is enabling increasingly complex tasks, particularly through the use of open protocols like the Model Context Protocol (MCP) and Agent2Agent (A2A) Protocol. These protocols facilitate sophisticated operations that often require accurate and dynamic information, including time-sensitive data. For instance, applications that manage schedules or coordinate events critically depend on precise time information.

Gists

Abstract

For extensive Google Docs, manually converting straight to smart quotes is inefficient. This report offers an automated solution using Google Apps Script, saving time and effort.

Description

You might find yourself needing to convert straight quotes (both single and double) to smart quotes in Google Docs. For small documents with a limited number of quotes, this can be done manually with minimal effort. However, when dealing with extensive documents and numerous quotes, the manual process becomes time-consuming and inefficient. This report presents a solution to automate this conversion using Google Apps Script, significantly reducing the processing cost for larger projects.

MCPApp was updated to v1.0.2

• v1.0.2 (May 29, 2025)

  1. From v1.0.2, in order to use MCPApp as a library, LockService is given.

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

A2AApp was updated to v2.0.1

• v2.0.1 (May 29, 2025)

  1. From v2.0.1, A2AApp can also be used as a library. Ref

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