Top "Google-apps-script" questions

Use for questions about Google Apps Script, Google's JavaScript-based cloud scripting platform for automating tasks across Google products and third-party services.

From Array to setValues gives: "Cannot convert to ."

BACKGROUND. I want to change a timesheet from a week format (every row shows 7 days, no date is available only …

multidimensional-array google-apps-script setvalue
How do I search Google Spreadsheets?

I am doing a few exhaustive searches and need to determine if a new domain (URL) is already in a …

search spreadsheet google-apps-script
Periodically refresh IMPORTXML() spreadsheet function

I 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
How to create custom keyboard shortcuts for google app script functions?

I'm trying to get a sense of the viability of replacing some of my Microsoft Excel spreadsheets with Google Doc …

google-apps-script google-sheets keyboard-shortcuts
You do not have permission to call openById

Problem: When I run the script, Google tells me, You do not have permission to call openById I had copied …

google-apps-script google-sheets google-apps-script-addon google-sheets-custom-function
Can a Google Form be auto filled and submitted, using data from a spreadsheet?

I am trying to determine how to get a script to take data from a spreadsheet and fill out a …

google-apps-script google-sheets google-forms
Is there a way to enlarge an image on mouse click in Google Sheets?

I basically have small images in a table that I'd like to enlarge on mouse click. I'd like the enlarged …

google-apps-script google-sheets google-spreadsheet-api
How to get Google docs last edit date

I am working on an app in which I need to show the date when google doc was last edited. …

google-apps-script google-docs google-docs-api
Simple popup or dialog box in Google Apps Script

I'm looking for simple code that adds a popup in my Google Apps Script Ui that comes up when I …

popup google-apps-script popupwindow
Find id of element on already made google form?

I have a form made on google docs, and I have a script that I've just created (that isn't complete) …

google-apps-script google-forms