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
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.
Copying Sheet Including Charts from Google Spreadsheet to Another Google Spreadsheet using Google Apps Script
Copying Sheet Including Charts from Google Spreadsheet to Another Google Spreadsheet using Google Apps Script
Abstract
This report presents a workaround for copying a sheet, including its charts, from Google Spreadsheet "A" to Google Spreadsheet "B" using Google Apps Script.
Description
In this report, I would like to introduce a workaround for the following goal:
Empowering Everyone to Leverage Various Google APIs using Google Apps Script
Empowering Everyone to Leverage Various Google APIs using Google Apps Script
Abstract
Google offers powerful APIs but using them (except advanced services) can be complex. A new, simpler method would benefit developers creating diverse applications. To address this, I built a Google Apps Script library simplifying API access.
The Gemini API can now do semantic searches, going beyond content generation. This means it can understand the meaning of your search and provide better results, even if your words don't exactly match the data. This report introduces the enhanced search capabilities of the Gemini API.
Similarity Viewer using Gemini API with Google Spreadsheet and Google Apps Script
Similarity Viewer using Gemini API with Google Spreadsheet and Google Apps Script
Abstract
The Gemini API enables both content generation and semantic search, managing data effectively. This report introduces a Gemini-powered similarity viewer for easy visualization of complex text similarity scores, using Google Spreadsheet and Apps Script.
Allowing Access by IMPORTHTML, IMPORTDATA, IMPORTFEED, IMPORTXML, and IMPORTRANGE on Google Spreadsheet with Google Apps Script
Allowing Access by IMPORTHTML, IMPORTDATA, IMPORTFEED, IMPORTXML, and IMPORTRANGE on Google Spreadsheet with Google Apps Script
Abstract
This is a sample script for enabling "Allow Access" for IMPORTHTML, IMPORTDATA, IMPORTFEED, IMPORTXML, IMAGE and IMPORTRANGE functions in Google Apps Script.
Creating Image Bot using Gemini with Google Apps Script
Creating Image Bot using Gemini with Google Apps Script
Abstract
New Gemini API opens doors for developers to integrate its AI power into apps, potentially impacting education, healthcare, and business. The latest Gemini 1.5 brings even more features. This report showcases an image bot using Gemini as one example of its diverse applications. Showcasing its diverse application potential across various fields.
Introduction
The recent release of Gemini as an accessible API on Vertex AI and Google AI Studio empowers developers to integrate its vast capabilities into their applications, potentially revolutionizing fields like education, healthcare, and business. Adding even more powerful features with the recently announced Gemini 1.5, this tool promises even greater impact. Ref and Ref I believe Gemini significantly expands the potential for diverse applica
Semantic Search using Gemini Pro API with Google Apps Script
Semantic Search using Gemini Pro API with Google Apps Script
Abstract
Gemini API unlocks semantic search for Google Apps Script, boosting its power beyond automation. This report explores the result of attempting the semantic search using Gemini Pro API with Google Apps Script.
Returning Class Object of Google Apps Script with JSDoc
Returning Class Object of Google Apps Script with JSDoc
Description
On December 7, 2020, new IDE has been released. Ref This has been helping users develop various applications using Google Apps Script with the new IDE very much. When it develops scripts and applications using Google Apps Script with the new IDE, it is considered that the existence of JSDoc in the script will be helpful for both the developers and the client users, because it is reflected in the auto-completion. However, when I tried to add the built-in Class objects of Google Apps Script for returning an object using JSDoc, unfortunately, I'm worried that the detailed official documents related to JSDoc for Google Apps Script are few. Ref and Ref In this report, I would like to introduce a method fo