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,877
questions
0
votes
0
answers
9
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
0
answers
7
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
10
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
0
answers
23
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 ...
0
votes
0
answers
15
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
18
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
19
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 ...
0
votes
0
answers
21
views
How to solve error TypeError: Cannot read properties of undefined (reading 'response') onFormSubmit @ Code.gs:3
I faced an error when I build up google script for google form the purpose from the script only that if the birthdate that entered from the form is after 1-Oct-2020 stop submitting form after I finish ...
0
votes
0
answers
14
views
Google Sheets Web App getActiveUser not working
A web app script I'm using for Google Sheets doesn't seem to be working half the time.
It's a timestamp that should also show the user ID of the editor. But most of the time it works for like a few ...
0
votes
0
answers
9
views
Vertical stacking of columns from 365 pairs of rows
Link to example sheet with faux data:
So, here's a formula that works, but iterating the pattern is way too long to type by hand. I tried using chatGPT to simply iterate the pattern but it basically ...
0
votes
0
answers
10
views
How can I fix my sliderstore() function to actually pass the data into google sheets?
`
window.timer = 0;
window.intervalId = null; // To hold the interval id for clearInterval
function sliderstore(range1) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var ...
0
votes
0
answers
25
views
Shopify rest api gives 200 response but product price is NOT updated
Using the Shopify Rest API and Google Apps Script environment to update product prices using the following code,
// Function to update product price
function updateProductPrice(shopUrl, product, ...
0
votes
0
answers
22
views
AppScript WebApp File Upload Error: "Cannot read properties of undefined (reading 'getFoldersByName')"
I'm developing an Apps Script WebApp that includes an upload function. This function should allow users to upload a file from their machine to Google Drive and allocate it to a specific folder based ...
0
votes
0
answers
30
views
Script to Recall data from a Google Sheet row to another sheet
I need some help.
googling somewhere I made a script to copy my sheet data into another sheet single row
this is my 1st sheet where I enter data:
link image1
and this is my other sheet save on row
...
0
votes
0
answers
22
views
dont work the Google Apps script redirection and data comparison from google sheets
I created a site in Google Sites, which is: https://sites.google.com/view/appuntiig/home, when you open it at the register button I connected a Google Forms file which does the registration and sends ...