Questions tagged [google-apps-script]
For questions about using Google Apps Script to extend Google applications
1,834 questions
2 votes
1 answer
160 views
Error when sending an email with attached PDF using Google Script
I'm trying to make a code that will create a filled out PDF based off the answers in a Google Form and then email that PDF to the person who filled it out. So far, my PDF is created and I'm able to ...
- 21
-1 votes
1 answer
78 views
getValue() Not Working
I'm trying to build a simple vocab practice game. Strangely, the script is breaking on getValue(). I want to retrieve the selected variable from the dropdown menu. // Global Variables const ss = ...
- 1
2 votes
2 answers
102 views
Is there a way to modify the script to color characters in a spreadsheet when formulas are used?
I have tested this script and it works fine if all the data in the spreadsheet is put in by hand. But I have a spreadsheet that is populated using importrange, so this script will not work. Is there ...
- 23
-1 votes
1 answer
65 views
How do I create a Google Sheet graph that adds imported data over time
I'm creating a spreadsheet for a game I play, and I wanted to track my guild's power level. I can get the raw data easily using IMPORTXML in google sheets, but my main problem is I don't know how to ...
- 1
0 votes
1 answer
77 views
Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues [duplicate]
function fetchReportIDFromAPI() { var spreadsheetId = '***'; function fetchDataFromAPI(spreadsheetId) { var spreadsheet = SpreadsheetApp.openById(spreadsheetId); var apiSheet = spreadsheet....
- 11
0 votes
0 answers
20 views
Google Apps Script Not Functioning [duplicate]
Just posted a question a bit ago about how to make a dropdown sort of self-edit. Details Adding a value to the selected value of a dropdown For more context, I'm working on a sort of form-fillable ...
1 vote
1 answer
45 views
How do I make Google Sheets copy a tab and change the name to a referenced cell?
I would like to make copies of the 'Master' tab and re-name the tab to the date in the 'Data' tab (column C). I found the following script, but have not been successful with getting the names to ...
-2 votes
1 answer
133 views
Code for Checking empty cell in AppsScript
I have a simple script to read a google sheet for email addresses, send a message and if necessary send with an attachment. My code is working if all cell have data, but I want to check if the "...
