Category "google-sheets"

Date/time output has single quote in front of variable in Google Sheet

I have some code to export some output to a Google Sheet. The command I am using for that is: row = [timestamp, float(temperature), float(humidity), current_tem

How to change the pixel quality and size of Image using Google Apps Script?

I have a list of image URLs and I want to get all those images which are more than 14Mb in size or 14 Megapixel in quality and resize them to under 5Mb in size

In AppScript, for Workspace Published Add-On Sheet Extensions, how do I switch to Head version and stop Deploying every bug fix?

Each time I fix a bug I have to Deploy and update the Version in theconsole.cloud.google.comI'm 17 Versions in and I don't think this is how it's supposed to wo

Google Spreadsheet MAX + Join of other cells

I have a spreadsheet like this - I can't figure out how to dynamically search for this. I want to find the MAX Score Value + output the related name (no worries

How to get max values for each unique value in a different column in Google Sheets?

I have two columns, the first column (A) has names and the second column (B) has values. A B apple 10 orange 12 orange 14 apple 8 Is there a way to get only r

Sheets ArrayFormula. Find nearest number by group

Master Data Group-Value pairs 1 | 1 1 | 2 1 | 3 2 | 5 2 | 8 3 | 10 3 | 12 Work Data Group-Value pairs + desired result 1 | 4 | 3 (3≤4, max in group 1)

How do I delete that specific Cell with Sheets API?

I want to Delete a cell in my google sheet using the sheets API! I did with adding A1 Notation but I'm doing this in a no code application and I need to delete

Find and replace duplicate rows with the newest data in a defined range using Google Apps Script

Google sheet using columns A:M. Each day a new set of raw data (around 30 rows) is pasted on the next available row in column B manually. This raw data contains

add data to a range from a dropdown in google sheets

I have a real estate office that uses google sheets to show address, buyer name, realtor name, and seller name. For the realtor name column I created a dropdown

Google Sheets API: How to find a row by value and update it's content

I am working on an Android application that uses a Google Spreadsheet as a database. The application should GET, APPEND and UPDATE values in a spreadsheet, usi

Google Apps Script basic authentication

I'm an absolute beginner when it comes to programming. I've been trying to import data table from "http://www.rotowire.com/daily/nba/value-report.htm" into goog

Date showing as serial number in formula

I'm currently having an issue with the date format. I have basically extracted the month and year from a standard dd/mm/yyyy date and wish this to be formatted

Python for Google Sheets: write dataframes to different sheets in the same workbook

Using the code below, I am able to write the dataframe df1 to the default first sheet (starting at cell ‘B7’) of the Google Sheet workbook. In the s

Switch values and headers

I have a google sheet with a table card1 | card2 | card3 | card4 | card5 | card6 | card7 ------+-------+-------+-------+-------+-------+------ set3 | set1 |

e.source returns Spreadsheet instead of Form object?

I create google form 'on the fly' using data in spreadsheet. Also I install trigger on submit form event. ScriptApp.newTrigger('onSubmit') .forForm(form)

Sytax error: Missing ), but I don't see it. My quotation marks don't seem to be the problem either

I've been working on this app script trying to automate data from a Google sheet to create events on Google Calendar. I've tried changing the Quotation marks fr

List names of sheets in Google Sheets and skip the first two

I found code to list the names of all the sheets in Google Sheets (from here): function SheetNames() { // Usage as custom function: =SheetNames( GoogleClock() )

TypeError: Cannot read property 'getRange' of null [duplicate]

I have a spreadsheet with data in columns A:Z. In column AA is the name of a sheet in the workbook. I'm trying to copy the data in A:Z to th

Saving as CSV through google script handling newline characters

So I'm attempting to take a sheet from a Google Spreadsheet and save it as a .CSV file just like you can manually do. It is working fairly well, but I've ran in

Protect Sheet when condition is met by change (Google Sheet)

There is a case where test is given to a certain student. The student can only work with the answer for the test before a given period. Here is the sample case: