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.

Find Cell Matching Value And Return Rownumber

The employee sheet contains the name of the employee in cell C2. The name of the employee should also be …

google-apps-script google-sheets google-docs row-number
get value in one column in spreadsheet using google apps script

I want to get a string value -to compare it later on with an if condition- from only one column …

javascript google-apps-script google-apps
How to use "not" in Gmail filters?

I need to create a Google App Script to respond to machine generated emails, except those also sent to one …

google-apps-script filter gmail
Create a new sheet in a Google Sheets with Google Apps Script

How to create a new sheet in a Google Sheets with Google Apps Script? I know it seems obvious but …

google-apps-script google-sheets
Retrieve the e-mail address of a Google Form respondent without asking for their e-mail address in the form

The scenario goes: Via email, a Google Form is sent to a respondent. Via this sent email, the respondent answers …

forms google-apps-script google-sheets google-forms
How to add a simple calculated field to a google form?

I'm looking for a way to add simple calculated field in a google form that will be dependent on other …

google-apps-script google-forms
How to do I locate a Google SpreadSheet ID?

https://developers.google.com/apps-script/guides/rest/api#parameter_and_return_types When using the Google Execution Api for Java, …

java google-apps-script google-sheets
Fill down - Google Apps Script for Spreadsheets

Is there a function that can fill down data to all empty cells from the row above? If not, could …

google-apps-script google-sheets
Collapsing Elements in a Google Doc With Google Apps Script - Is This Possible?

I'd love to be able to collapse and expand sections in my Google Docs document, making large documents easier to …

google-apps-script google-docs google-docs-api
Retrieve rows from spreadsheet data using google app script

I am using Google app script to write form data to spreadsheet. Now I would like to fetch the values …

google-apps-script spreadsheet google-spreadsheet-api