Questions tagged [google-apps-script]
Use for questions about Google Apps Script, Google's server side Javascript V8-based cloud scripting platform for automating tasks across Google products and third-party services. Use in addition to relevant product-specific (e.g. [google-sheets], [google-docs]) or API-specific (e.g. [google-drive-api]) tags where applicable
google-apps-script
54,885
questions
0
votes
0
answers
7
views
Coloring the searched word in Google Sheets
How do I color all the words in the results that contain the text I searched for with the query function?
In Google Sheets, I use the "query function" to search the column C in Sheet1 for ...
0
votes
0
answers
15
views
HTML form using Google App Scripts Email Notification & Success/Failure Code JavaScript not working
I bootstrapped this code from github - click here if you would like to see the original tutorial
The functionality of the form data transferring to Google Sheets and file upload to drive works ...
0
votes
0
answers
15
views
Email from script Sending as [object Object]
I'm unsure as to why this app script is sending an email with only [object Object] as the whole email?
I'm not smart enough to figure this out.
function scriptattempt() {
let sheet = SpreadsheetApp....
0
votes
0
answers
7
views
Time-Based Trigger Returns Only the Values from Row 1
I have a function that runs based on edits made in Column V starting from Row 2 in a worksheet. That function sends an email on edit.
function onEdit_ColumnV(e){
if(activeSheetName === ...
0
votes
1
answer
11
views
App Script Project deleted - how to restore it?
I deleted a project by mistake and can't retrieve it. Is there any way to restore it?
I tried restoring an earlier version of the gsheet file to which the app script project was linked. I have tried ...
0
votes
0
answers
12
views
AppsScript Open another GoogleSheet and update cell
I am trying to run a for loop to get the sheet URL from Column A, open that sheet and update a cell. Currently when I run it just seems to immediately stop.
function updateTemplate() {
for (var row =...
1
vote
1
answer
21
views
How can I expand the range for a code? How to create a proper loop?
I have a code that is doing what I want, but now it works only for one column of the sheet and I would like to create a loop that will works on multiple columns.
Now the code is checking if column L (...
0
votes
1
answer
30
views
How do I show a date and time in the viewing users local time?
I have a shared spreadsheet that is used by people from many different time zones around the world. On the sheet is a button that runs a Google App Script function which when finished updates a cell ...
0
votes
1
answer
66
views
Get values from for each sheet and put values in another sheet
I am trying to get ranges from all tabs and put values in a specific tab called 'Data' at P col.
I have range values at A2:B between all tabs and am trying to get values by mapping method.
The issue ...
0
votes
1
answer
31
views
Call Chat-GPT Assistant using Google Apps Script
I wrote a small Google Apps Script that basically calls a trained Chat-GPT Playground Assistant to answer my query. The code is working perfectly when using it for example with a default model such ...
0
votes
0
answers
19
views
Depended dropdown with extra nested if statement
I have the following code, that works, for a depended dropdown menu.
Right now it does: IF Colomn 5<>"", then put depended dropdown of that name in Colomn 6.
And if Colomn 6<>&...
-1
votes
1
answer
42
views
Google Sheets Apps Script unexpected setValue() behaviour with some Unicode characters
setValue() when asked to set the value of a cell to certain Unicode characters, refuses and instead decides to set the value to the last digit of the codepoint (as a numeric type)
Disclaimer: I am not ...
-1
votes
0
answers
29
views
Getting TypeError: sheetName.getRange is not a function while using GAS for listing videos in YouTube Playlist
I am trying to create a Google Appscript, where you can input the YouTube Playlist id and then it will print details of all the videos in the Playlist in a spreadsheet. The code is as follows:
...
0
votes
0
answers
30
views
Error when linking Google AppSheet with Dify
*This problem has also been posted on other sites (teratail, Qiita, stack overflow Japanese version).
If you find the answer or hint on another site, please share it as your own answer.
I created a to-...
0
votes
1
answer
25
views
Google Apps Script deployment not working
sorry if this question doesn't have all the necessary information (I'll edit it as I go if I'm missing something critical) but my Google Workspace Add-on isn't showing up after I click on 'Test ...