You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Instantly share code, notes, and snippets.
Kanshi TANAIKE
tanaikech
Ph.D. in Physics / Google Developer Expert (GDE) / Google Cloud Champion Innovator
Consolidate Scattered A1Notations into Continuous Ranges on Google Spreadsheet using Google Apps Script
Consolidate Scattered A1Notations into Continuous Ranges on Google Spreadsheet using Google Apps Script
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.
Specifying Output Types for Gemini API with Google Apps Script
Specifying Output Types for Gemini API with Google Apps Script
Abstract
The Gemini API generates different outputs depending on the prompts. This report explains how to use function calling in the new Gemini 1.5 API to control the output format (string, number, etc.) within a script during a chat session. This allows for more flexibility in using the Gemini API's results.
Parsing Invoices using Gemini 1.5 API with Google Apps Script
Parsing Invoices using Gemini 1.5 API with Google Apps Script
Abstract
This report explores using Gemini, a new AI model, to parse invoices in Gmail attachments. Traditional text searching proved unreliable due to invoice format variations. Gemini's capabilities can potentially overcome this inconsistency and improve invoice data extraction.
Technique for Appending Values to Specific Columns on Google Spreadsheet using Google Apps Script
Technique for Appending Values to Specific Columns on Google Spreadsheet using Google Apps Script
Abstract
This report addresses the challenge of appending values to specific columns in Google Sheets when columns have uneven last rows. It offers a Google Apps Script solution with a sample script and demonstration image, enabling efficient and flexible data manipulation.
Analyzing Trends of Google Apps Script from Questions on Stackoverflow using Gemini 1.5 API
Analyzing Trends of Google Apps Script from Questions on Stackoverflow using Gemini 1.5 API
Abstract
A new large language model (LLM) called Gemini with an API is now available, allowing developers to analyze vast amounts of data. This report explores trends in Google Apps Script by using the Gemini 1.5 API to analyze questions on Stack Overflow.
Generating Texts using Files Uploaded by Gemini 1.5 API
Generating Texts using Files Uploaded by Gemini 1.5 API
Abstract
The Gemini API allows the generating of text from uploaded files using Google Apps Script. It expands the potential of various scripting languages for diverse applications.
The Gemini API unlocks potential for diverse applications but requires consistent output formatting. This report proposes a method using question phrasing and API calls to craft a bespoke output, enabling seamless integration with user applications. Examples include data categorization and obtaining multiple response options.
Attempting Reverse Engineering with Gemini API and Google Apps Script
Attempting Reverse Engineering with Gemini API and Google Apps Script
Abstract
Gemini API on Vertex AI/Studio unlocks new applications with data retrieval and content generation through function calls. This report explores using the API for reverse engineering with a sample interpreter in Google Apps Script.
Introduction
The recent release of the LLM model Gemini as an API on Vertex AI and Google AI Studio unlocks a vast potential for new applications and methodologies. It significantly expands capabilities across diverse situations, paving the way for groundbreaking applications. Notably, the Gemini API allows data retrieval and content generation through function calls. In my recent report, "Guide to Function Calling with Gemini and Google Apps Script", I explore function calls as a launchpad for various applications. This report showcases reverse engineering using the Gemini API, with a sa