All Questions
Tagged with google-workspace google-apps-script
552
questions
1
vote
0
answers
95
views
Testing my Sheets Workspace Add-on will Install but will not "run" onOpen in a new test sheet
Here is my expected and actual breakdown, based on my reading of the various Google Developer documentation for building a Google Sheets Editor and Workspace Add-on
Expected outcome: After navigating ...
0
votes
0
answers
29
views
How to create loop through moving an array over 2 columns
i have name:value pairs in the range RA1:RB21 that I want to 2 columns over. I need to repeat the process 480 times but I'm struggling with how to create a loop to move over 2 columns.
See below for ...
-1
votes
1
answer
50
views
How to change a list so that .setValues will display it in a specific range on a Google Sheet?
I'm basically a beginner with coding and Google Apps Script and have hit the limits of my abilities. I have a list of values in Column A on sheet 1, and a second list (subset) in Column A on sheet 2. ...
0
votes
0
answers
24
views
google apps script to return sheetnames along with isActive and isHidden state, on deploying the web url does not output as expected in doGet function
the implement function returns the sheetname, sheet active or not, sheet hidden or not accurately. Function given below -
function doGet() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var ...
0
votes
1
answer
91
views
Google Apps Script: creation of PDF Documents out of Spreadsheet data and providing the PDF URL into the Spreadsheet
I am trying to create PDF Documents with Spreadsheet Data and I wanna paste the PDF URLs of the created PDF Documents back into the Spreadsheet.
My Code seems to be working mostly, it creates the Temp ...
0
votes
0
answers
88
views
Google App Script cannot fetch CSS file hosted on Google Drive (403 unauthorized)
I have a problem with Google App Script accessing Google Drive hosted assets. And the strange fact is that it was working all the time and just stopped working several days ago.
What is happening: In ...
0
votes
0
answers
61
views
OnSelectionChange trigger works only after page reload
I have a simple script that is triggered when the selected cell is changed. Unfortunately, when the document is freshly opened, the script does not start, no matter how many cells I click on. It ...
1
vote
1
answer
899
views
why Image is not Display in web app made in google app script? [duplicate]
Why is not displayed in the web app made in the app script and using Google Workspace ID as well as Gmail ID, in both cases image is not displayed, but in some domain IDs, the image is displayed with ...
1
vote
1
answer
85
views
How to copy a cell with a mention to another cell
I have 2 spreadsheets.
In the first I have a column filled with the values made by @mention as shown in the image below.
enter image description here
The second spreadsheet I use to receive this data ...
0
votes
0
answers
107
views
Google Apps Script: Problem with error "Exception: Couldn't open document ... Unable to load document."
I keep getting the following error message when I run my code:
"Exception: Couldn't open document with id 1IOwbcFWrh_jEeZbhVgw5fEbGOtM6zXKpmdrO_qUGNZM: Unable to load document."
I can't see ...
0
votes
1
answer
59
views
How can i make gmail send me HTTP request everytime i get new message [closed]
I am creating a laravel app to manage my Gmail using google client api to manage my customers and connect them with the emplyees
In my app there is last_interaction attribute to each client that ...
1
vote
0
answers
33
views
Google App Script Error : API call to bigquery.jobs.getQueryResults failed with error: Not found: Job [duplicate]
I'm attempting to use Apps Script to retrieve data from BigQuery and put it to a spreadsheet, but I'm getting the following error notice when my script runs:
GoogleJsonResponseException: API call to ...
0
votes
1
answer
346
views
Checking student submission marked as "Excused" in Google Classroom
There is a new feature in Google Classroom that allows the teacher to mark a student submission to an assignment as excused. This renders the submission "Graded" but allows the grade to ...
0
votes
0
answers
75
views
How can we make the Google App script able to send POST request on a webhook which is only accessible within my Internal Network
I have created a Google-app Script which will take the slash commands(/job;/help etc) from the GoogleChat App and sends the POST request to respective webhook api which is only accessible within ...
0
votes
1
answer
66
views
Google Form - Delete rows/records older than 3 years
I have a google form that records sales of certain items to customers. I need to automatically delete rows that are older than 3 years. This is for GDPR data retention reasons.
I though I could have a ...