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
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.
Technique for Protecting Google Spreadsheet using Google Apps Script
Technique for Protecting Google Spreadsheet using Google Apps Script
Abstract
Google Apps Script automates tasks like managing protections in Google Spreadsheets. These protections control user access to specific cells. While scripts exist for this purpose, users still encounter challenges, prompting this report. The report aims to introduce techniques for managing protections using sample scripts, helping users understand and implement this functionality.
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
Guide to Function Calling with Gemini and Google Apps Script
Guide to Function Calling with Gemini and Google Apps Script
Abstract
Powerful AI tool Gemini's API release (Vertex AI & Google AI Studio) opens doors for diverse applications. Its recent upgrade to version 1.5 boosts capabilities. This report demonstrates using simple Google Apps Script function calls to leverage Gemini's power for both data retrieval and content generation.
Introduction
The recent release of the LLM model Gemini as an API on Vertex AI and Google AI Studio unlocks a world of possibilities. Ref Excitingly, Gemini 1.5 was just announced, further expanding its capabilities. Ref I believe Gemini significantly expands the potential in various situations and paves the way for diverse applications. Notably, the Gemini API can retrieve new data and generate content through function calls. In this report, I introduce the basic flow of function
Applying Gemini Pro API to Flexible Templates using Google Apps Script
Applying Gemini Pro API to Flexible Templates using Google Apps Script
Abstract
New "semantic search" features in Gemini API help find desired information within its corpora. While using these features with Google Apps Script was complex, a new library simplifies the process. This report proposes using this library with Gemini-generated content to automate template processes in Google Docs and Slides, creating a more flexible workflow.
Convert Contact URL to Resource Name for People API using Google Apps Script
Convert Contact URL to Resource Name for People API using Google Apps Script
This is a sample script for converting a contact URL of "person/c###" to a resource name "people/c###" for People API using Google Apps Script.
When you open each contact at Contacts with your browser, you can see the URL like https://contacts.google.com/person/c###################.
Here, you might have a situation where you are required to retrieve the resource name for People API from this URL. But, in the current stage, person/c################### cannot be directly used as the resource name people/c###################. In this report, I would like to introduce a sample script for converting from person/c################### to people/c###################.