This is a sample script for disabling the buttons put on Google Spreadsheet using Google Apps Script.
When a script is run by clicking a button on Google Spreadsheet, there is the case that you don't want to make users run the script in duplicate. This sample script achieves this situation.
| /** | |
| * Promise-friendly google.script.run call | |
| * @param {String} funcName | |
| * @param {...*} params | |
| * @returns {Promise} | |
| */ | |
| const asyncGAPI = (funcName, ...params) => { | |
| return new Promise((res, rej) => { | |
| google.script.run | |
| .withSuccessHandler(data => res(data)) |
| //serpApiKey from serpapi.com | |
| var GLOBAL_VARIABLES = { | |
| serpApiKey : "add your api key" | |
| } | |
| /* | |
| /*************************** | |
| /BEGIN PRESENTATION SCRIPTS |
In this sample script, all pages in the Figma file are retrieved and the retrieved pages are put to new Google Slides as the image.
You can see the method for retrieving the access token at here. Although there is also OAuth2 for retrieving the access token, in your situation, I thought that the method for directly generating the access token on the site might be suitable. So in this answer, the generated access token on the site is used. Please retrieve the access token as follows.
| /** | |
| * Get a GCS Signed URL | |
| * | |
| * @param {object} JSON credential | |
| * @param {string} the base URL to sign | |
| * @param {string} optional; TTL in seconds, defaults to 60 | |
| * @param {string} optional; the httpVerb, eg. 'GET','POST'; defaults to 'GET' if not specified | |
| * @param {string} optional; the content type, ie. one of the valid mime content types. Your HTMLService HTTP header must set have a matching content type | |
| * @return {string} The complete URL. | |
| * @private |
April 20, 2019: GAS library for this situation was published. Please check it at https://github.com/tanaikech/FetchApp.
These sample scripts are for requesting multipart post using Google Apps Script.
In most cases, the multipart request is used for uploading files. So I prepared 2 sample situations as follows. For each situation, the request parameters are different.
| // Setup: Spreadsheet in Pacific time, Script in Eastern time, Calendar in Mountain time. | |
| // Sample spreadsheet: https://docs.google.com/spreadsheets/d/1neePK1YPKMKnVwI8dld0HSJjI1kSFPpcY8g7kG8xG4U/edit#gid=0 | |
| // A2 = 3/1/2016 9:00 AM, B2 = 3/1/2016 10:00 AM | |
| /** | |
| * The dates and times in the spreadsheet refer to exact moments in time, and the clock | |
| * on the wall may show a different time. | |
| */ | |
| function copyMoment() { | |
| var ss = SpreadsheetApp.getActive(); |
This tutorial demonstrates how to use Google Apps Script to:
Create copies of the Google Sheet in the desired destination folder automatically at set intervals.
Append the time stamp with each backup file's name.
Adjust time trigger for backing up every day/hour/minute.
| function createEventWithAttachment() { | |
| var driveFileId = '...'; | |
| var file = DriveApp.getFileById(driveFileId); | |
| var event = { | |
| summary: 'Test Event with Attachments', | |
| description: 'Woot!', | |
| attachments: [{ | |
| fileId: driveFileId, | |
| fileUrl: file.getUrl(), | |
| mimeType: file.getMimeType(), |
| function exportSpreadsheet() { | |
| //All requests must include id in the path and a format parameter | |
| //https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export | |
| //FORMATS WITH NO ADDITIONAL OPTIONS | |
| //format=xlsx //excel | |
| //format=ods //Open Document Spreadsheet | |
| //format=zip //html zipped | |
