Give permission in a gmail addon
I’m trying to put together a script for Gmail in Google Apps Scripts add-on that will reply to all email on weekends with an out of office message: function autoReply() { var interval = 5; // …
Tag: google-apps-script
Can’t pass variable to .getRange()
I’m trying to write a script that gets a range who’s size is based on a constant. My the code I’ve been trying is below //Save range based on number of components var numComponents = 3; var …
Applying google app script code in selection in google docs
I have the following code that puts bold style some keywords in a whole google document: function boldKeywords() { // Words that will be put in bold: var keywords = [“end”, “proc&…
Google sheet to PDF Email getActiveSheet()
I am looking for a convert current google sheet into PDF and send mail ActiveSheet. : This code looping all sheet into pdf and emailing me I want mail only active tab. //this code working fine but …
Editing one Spreadsheet from another Spreadsheet in Google Apps Script
Question How do you edit two different spreadsheets from one connected script that is triggered by an onEdit command? My Case I am trying to create a master spreadsheet that sends and deletes …
How do I run through rows and fetch the value of a cell, if another cell is true?
In Google Sheets, I have X rows with data in 10 columns. The first row contain headers. I need to run through every row in my current sheet, check column B, in the current row, and if the value of …
Why function cannot read array element in loop? [closed]
I have a simple function that only checks if the fourth element of an array is bigger or not. Somehow I am getting and error TypeError: Cannot read property ‘3’ of undefined And I have no idea why… …
How to auto assign next letter from a list into a cell depending on value of another?
Here is a basic sheet with list of days of the month that change according to date in a specified cell, trying to find a way to automatically assign next letter from a list and place it in cell …
How to only copy array elements to spreadsheet if conditions met
I am building a script to copy CSV data to a Google Sheet. The CSV is converted to a 2D Array trades, and a forEach loops through each element/row of trades, named trade. I’m trying to make it check …
Creating a Python Request Equivalent in Google Script
I’m trying to upload a video url to Vimeo in Google Script. I’ve set this up successfully in my Python/Django app with the following: url = ‘https://api.vimeo.com/me/videos’ headers = {‘Authorization’:…