tanaike - Google Apps Script, Gemini API, and Developer Tips

The Thinker

Changing Values by Checking Duplicated Values of JSON for Javascript

Gists This sample script is for changing values by checking duplicated values of JSON for Javascript. Please see the following script. There is an array with a JSON data with 3 keys and 3 values. It is found that the values for each element duplicate. These duplicated values are changing by adding numbers. I use this for managing filenames. This script also can be used for Google Apps Script. If this was useful for you, I’m glad.

Updated: GAS Library - ImgApp

ImgApp was updated to v1.2.0. New method was added. 3. updateThumbnail() Overview This method is for updating thumbnail of files on Google Drive using images you selected. Description For example, zip files don’t have the thumbnail on Google Drive. An icon is shown as the thumbnail. For the most files, Google Drive can create automatically each thumbnail. But there are sometimes files which cannot be created the thumbnail. Zip file is also one of them.

Updating Thumbnail of File on Google Drive using Python

Gists This sample script is for updating thumbnail of file on Google Drive using Python. This sample supposes that quickstart is used and default quickstart works fine. In order to use this sample, please carry out as follows. Replace main() of the default quickstart to this sample. Script : import base64 # This is used for this sample. def main(): credentials = get_credentials() http = credentials.

Downloading Files Under Specific Folder using Node.js

Gists This sample script is for downloading files under a specific folder using Node.js. It can download files with Google Docs and others. This sample supposes as follows. So please confirm it. quickstart is used and default quickstart works fine. In order to use this sample, please carry out as follows. Replace listFiles() of the default quickstart to this sample. Set folderid. This script can retrieve files in the folder with folderid.

GAS Library - OnedriveApp

This is a library of Google Apps Script for using Microsoft OneDrive. Feature This library can carry out following functions using OneDrive APIs. Retrieve file list on OneDrive. Delete files and folders on OneDrive. Create folder on OneDrive. Download files from OneDrive to Google Drive. Upload files from Google Drive to OneDrive. Demo You can see the detail information here https://github.com/tanaikech/OnedriveApp