Use this tag for questions about interacting with Google Sheets programmatically.
I have a Google Sheets workbook with more than 70 tabs, or sheets, in it. In one of them, I have …
google-sheets google-sheets-apiI have a bunch of ISO-8601 formatted strings in a column of my sheet. How can I get google sheets …
google-sheets google-docsI am trying to figure out, how do the following in Google Spreadsheet. Send email when a value changes in …
google-apps-script google-sheets spreadsheet sendmessageI want to convert the time HH:MM into H.xx Like I am getting it in this format: Sat …
google-apps-script google-sheets google-sheets-apiI would like to use Google Sheets for its convenient global access, but I really need to display numbers in …
google-sheetsI want to create a scraper using Google Spreadsheets with Google Apps Script. I know it is possible and I …
javascript parsing google-apps-script google-sheets html-parsingIn a Google Docs spreadsheet, I'm looking for something like =EVAL(A1) where A1 is set to "=1+2". I found out …
google-apps-script google-sheets google-sheets-formula evaluateI'm working on a spreadsheet in Google Sheets that takes lap times (from running track splits) and subtracts them (to …
time google-sheets addition duration subtractionyou can't move columns in the table from side to side since doing so would disrupt the structure from the …
google-sheets google-formsI have a large sheet with around 30 importxml functions that obtain data from a website that updates usually twice a …
google-apps-script google-sheets google-sheets-formula google-sheets-importxml gs-installable-triggers