Gists This is a sample script for requesting with keeping cookies using Google Apps Script. This might be similar to requests.Session" of Python. Ref Sample script This is Class SessionFetch. /** * UrlFetchApp is run by keeping Cookie. */ class SessionFetch { constructor() { this.cookie = ""; this.his = []; } /** * Request URL. * @param {string} url URL * @param {object} params Object * @return {UrlFetchApp.
Gists This is a sample script for retrieving the files of ‘Shared with Me’ in the specific folder using Google Apps Script. In the current stage, when you transfer the ownership of your file on your Google Drive to another user and/or copy the file “Shared with me” to the specific folder on your Google Drive, the file becomes the shortcut file. Under this situation, when you want to retrieve the files of “Shared with me” in the specific folder, unfortunately, the following search query cannot be used.
Gists These are sample scripts for achieving the full-text search of Google Apps Script projects using Google Apps Script. I have the case that I want to search a value from Google Apps Script projects using a Google Apps Script. In this post, I would like to introduce the sample scripts for achieving the full-text search of Google Apps Script projects. 1. Full-text search from all Google Apps Script Projects of standalone type in Google Drive Before you use this script, please enable Drive API at Advanced Google services.
Gists Kanshi Tanaike Introduction There is a maximum executing time for Google Apps Script (GAS). That is 6 minutes. And, in the case of the custom function and the simple trigger, it is 30 seconds. Ref So users always have to pay attention to reducing the process cost of the scripts. Especially, it is very important to know the process costs for the array processing, because array processing is often used for spreadsheets and Google APIs.
Following 3 reports have been published at Champion Innovators Content Library. Taking advantage of Web Apps with Google Apps Script Report: Management of Images on Google Spreadsheet using Google Apps Script Report: Handling 10,000,000 cells in Google Spreadsheet using Google Apps Script If these reports will be useful, I’m glad.