Kanshi TANAIKE

taking-advantage-of-Web-Apps-with-google-apps-script. This is a report to take advantage of Web Apps with Google Apps Script (GAS).

ImgApp. A powerful image processing library for Google Apps Script (GAS) to retrieve image size/DPI via binary parsing, resize images, update thumbnails, crop/merge images, and perform OCR using Google Drive API v3.

FetchApp. This is a GAS library for creating and requesting the type of multipart/form-data using Google Apps Script. This library enhances Class UelFetchApp of Google Apps Script.

MCPApp. This text introduces the Model Context Protocol (MCP) for AI interaction, exploring Google Apps Script (GAS) as a server option. It shows feasibility with a sample but notes the lack of a GAS SDK, aiming to encourage understanding and development.

HtmlFormApp. This is a Google Apps Script library for parsing the form object from HTML form and appending the submitted values to the Spreadsheet.

OnedriveApp. This is a library of Google Apps Script for using Microsoft OneDrive.

gdoctableapppy. This is a python library to manage the tables on Google Document using Google Docs API.

ManifestsApp. This is a Manifests library for Google Apps Scripts.

AsynchronousResumableUploadForGoogleDrive. This is a sample script for uploading multiple files with large size (> 50 MB) at the sidebar, dialog of Google Docs and Web Apps using the resumable upload of the asynchronous process with Javascript and Google Apps Script (GAS).

getfilelistpy. This is a python library to retrieve the file list with the folder tree from the specific folder of Google Drive.

RangeListApp. RangeListApp is a GAS library for retrieving, putting and replacing values for Spreadsheet by a range list with a1Notation using Google Apps Script (GAS).

ProjectApp2. This is a GAS project library for Google Apps Script (GAS). This library can be used for the projects of both standalone script type and container-bound script type.

TemplateApp. This is a Google Apps Script library for easily managing the template of Google Documents and Google Slides using Google Spreadsheet as a database using Google Apps Script.

TriggerApp. An optimized Google Apps Script library and MCP Server to efficiently manage complex, flexible, and automated time-driven triggers with high precision.

MoveFolder. This is a Google Apps Script library for moving a folder including files and folders on Google Drive.

FieldsBuilderForGoogleAPIs. FieldsBuilderForGoogleAPIs is a Web Application for building the fields value for using Google APIs. This is mainly used for developing the scripts for using Google APIs.

go-getfilelist. This is a Golang library to retrieve the file list with the folder tree from the specific folder of Google Drive.

A2AApp. This is a library for implementing an Agent2Agent (A2A) server using Google Apps Script. This enables AI agent communication and secure service access for AI-powered workflows.

Linking-Google-Cloud-Platform-Project-to-Google-Apps-Script-Project-for-New-IDE. This is the document for linking Google Cloud Platform Project to Google Apps Script Project for New IDE. And also, several sample scripts using Google Apps Script API and Google Photos API are introduced.

GoogleApiApp. This is a Google Apps Script library for supporting to use Google APIs with Google Apps Script.

UnzipGs. This is a GAS library for unzipping a Zip file protected by a password using Google Apps Script.

GmailToList. This is a library for exporting all messages of Gmail as a list using Google Apps Script (GAS).

HtmlFormObjectParserForGoogleAppsScript_js. This is a Javascript library for sending the HTML form object to Google Apps Script using google.script.run.

MicrosoftDocsApp. This is a Google Apps Script library for using Microsoft Docs files (Word, Excel, and PowerPoint files) using Document service, Spreadsheet service, and Slides Service of Google Apps Script.

ProcessApp. This is a library for retrieving the process and information of Google Apps Script. For example, one of methods retrieves the total execution time of all functions executed by the time-driven trigger at owner's account.

RichTextAssistant. This is a GAS library for supporting editing RichText in Google Spreadsheet using Google Apps Script.

RearrangeScripts. This is a GAS application for rearranging Google Apps Scripts (GAS) in a project which can be seen at the script editor.

ZipFolder. This is a library for zipping a folder using Google Apps Scripts.

GetEditType. GetEditType is a GAS library for retrieving the edit types of the OnEdit event trigger of Spreadsheet using Google Apps Script (GAS).

syncGoogleScriptRun. This is a Javascript library to use "google.script.run" with the synchronous process.

Enhanced-Custom-Function-for-Google-Spreadsheet-using-Web-Apps-as-Wrapper. This is a proposal of the enhanced custom function for Google Spreadsheet using Web Apps as the wrapper.

Managing-A-Lot-Of-Google-Calendar-Events-using-Batch-Requests-with-Google-Apps-Script. These are the sample scripts for managing a lot of Google Calendar Events using the batch requests with Google Apps Script.

tanaikech.github.io. Blog (my memorandums)

ReservationApp. This is the dining reservation system using Google Apps Script.

GASProjectApp. This is a Google Apps Script library for creating, updating and exporting Google Apps Script project of the standalone type using Drive API. In this case, Apps Script API is not used.

DateFinder. DateFinder is a GAS library for searching the date objects from the cell range on the sheet in the Spreadsheet and retrieving the searched range as the RangeList object using Google Apps Script (GAS).

OwnershipTransfer. This is a Google Apps Script library for achieving the ownership-transfer of the specific folder including the files and sub-folders using Drive API.

One_Time_Download_for_Google_Drive. This is a sample script for downloading files from Google Drive by the one time download method.

UnlockSmartInvoiceManagementWithGeminiAPI. This is an application for "Unlock Smart Invoice Management: Gemini, Gmail, and Google Apps Script Integration".

GetFileList_js. This is a Javascript library to retrieve the file list with the folder tree from the specific folder (publicly shared folders and own folders) of Google Drive.

Processing-Various-Types-of-Invoices-using-Gemini-1.5-API-with-Google-Apps-Script. This repository is for Parsing Invoices using Gemini 1.5 API with Google Apps Script.

ImageBotApp. This is the image bot using Gemini with Google Apps Script and Google Drive.

MimeTypeApp. This is a Google Apps Script library for converting files from various MIME types to a specified target MIME type. The library accepts both file IDs and blobs as input values.

Integrating-Gemini-and-Google-Apps-Script-for-Automated-Google-Slides-Presentations. Learn how Gemini AI and Google Apps Script automate Google Slides generation. A developed application demonstrates this synergy, streamlining initial presentation drafting and showcasing AI's automation potential within Google Workspace.

Analyzing-Folder-Structures-with-Google-Apps-Script. This report provides a Google Apps Script to retrieve all files, including those within subfolders, for a designated folder. It addresses the challenges of retrieving files within deeply nested folder structures and obtaining complete file paths.

ProjectApp. This is a project library for Google Apps Script (GAS).

DocNamedRangeApp. This is a Google Apps Script library for managing the named range on Google Documents.

Roadmap-Generator-as-Gemini. Gemini and Google Apps Script automate project roadmap creation in Google Sheets, including Gantt charts, improving efficiency and agile planning.

UploadApp. This is a Google Apps Script for uploading a file to Gemini, Google Drive, YouTube, and so on with the resumable upload.

go-gdoctableapp. This is a Golang library for managing tables on Google Document using Google Docs API.

Creating-PNG-Image-with-Alpha-Channel-using-Google-Apps-Script. This is a sample script for creating a PNG image with the alpha channel using Google Apps Script.

Safe-Uploading-for-Google-Drive-by-HTML-in-External-Server-using-Google-Apps-Script. This is a report for safe-uploading files to Google Drive by HTML put in the external server using Google Apps Script.

FileTransfer. How to transfer files for Google Drive without authorization.

node-getfilelist. This is a Node.js module to retrieve the file list with the folder tree from the specific folder of Google Drive.

Batch-Requests-for-Drive-API-using-Google-Apps-Script. These are the sample scripts of the batch requests for Drive API using Google Apps Script.

File_Picker_using_Google_Apps_Script_and_Javascript_without_3rd_party. This is a sample script for the file picker using Google Apps Script and Javascript without 3rd party.

resumableUploadForGoogleAPIs_nodejs. This is a script for achieving the resumable upload through the stream using Google APIs with Node.js.

SOUWA_GAS. GAS library for summing string elements in an array at the high speed

QAApp. This report explores using Gemini 1.5 Flash/Pro with RAG on medium-sized, Google Spreadsheet-stored datasets for improved accuracy and effectiveness.

SimplePhotoGalleryUsingGoogleAppsScript. This is a sample script for achieving a simple photo gallery created by Google Slides and Web Apps using Google Apps Script.