55,573 questions
1
vote
1
answer
33
views
Exception throw when attempting to read Chart.ChartOptions for existing chart
I'm trying to programatically modify an area chart within a Google spreadsheet. I want to read the existing chart's options like so; the string values in AREA_CHART_PROPS have been taken from Google's ...
- 2,321
1
vote
0
answers
30
views
Using Google File Picker to reduce drive scopes in apps script add-on
I am working on a Google Docs Extension (Add-on) that exports a file into the same folder as the current document. I need my script to use the narrowest scopes so it can pass the verification process ...
- 3,281
0
votes
1
answer
42
views
How to save changes from a web app to Google Sheets using Apps Script?
In Google Sheets, I want to take certain columns from a table and create an app through deployment. I need the user to be able to edit these fields, and all changes should be reflected in the original ...
-5
votes
0
answers
48
views
How to distribute professionals in a schedule in Google Sheets [closed]
I'm working for a client and they want me to distribute their professionals, which have different availability each in a schedule (always 1 hour duration) of specific times with 3 categories of ...
-3
votes
4
answers
116
views
How to sum up to a specific value in Google Sheets
I have a complicated situation in Google Sheets and I don't know if it there is a possible solution for this in sheets. I have a list of records with various values both positive and negative, the ...
- 1
0
votes
1
answer
35
views
Using apps-script-oauth2 lib - getting 'Cannot read properties of undefined (reading 'code')' error with handleCallback function
I'm getting below error with my authCallback function
TypeError: Cannot read properties of undefined (reading 'code')
at Service_.handleCallback(Service:440:40)
at authCallback(Auth:69:39)
Does this ...
0
votes
0
answers
50
views
Why is my G-Sheets Script not working properly? [closed]
I am in the process of updating a list that is used in my company, with an older one. The older one has critical info, that the new list doesnt have, and there are about 36000 rows and some coloums, ...
-1
votes
1
answer
29
views
How to create a GoogleGroup about a GScript
In my script I get the error back:
API call to directory.groups.insert failed with error: Not Authorized to access this resource/api
I logged in as SuperAdmin.
Thanks
function createGroup() {
var ...
- 271
1
vote
1
answer
43
views
Not able to convert Excel file into google sheet
I have an XLS file in Google Drive. Using Google Apps Script, trying to convert to Google Sheets. But it is being stored as Google Docs instead.
function readBlob() {
var file = DriveApp.getFileById(...
- 71
0
votes
1
answer
50
views
Google Sheets App Script: Trigger on a copied sheet
I am trying to run a Google Sheets App Script whenever a checkbox is ticked.
Other users should be allowed to tick the checkbox.
When ticked, an App Script shows/hides different parts of the sheet.
...
- 43
-1
votes
0
answers
37
views
How to hot reload Google App Script server side code?
Currently, I'm working on Google App Script Sheet Application in VS Code. I'm using this template, so I can open my Google SpreadSheet and debug it in "real time" without constant re-pushing ...
-5
votes
0
answers
37
views
DocketWise api query to get the matters that were updated just today [closed]
I want to get the matters that passed to the next status in appscript so i was thinking about the next link
https://app.docketwise.com/api/v1/matters?status_changed_since=2025-02-20&limit=200&...
0
votes
2
answers
55
views
Exporting Google Drive files (.docx, .xlsx, .pdf, Google Docs, Google Sheets) as .html files with Google Apps Script
I am trying to export various files (.docx, .xlsx, .pdf, Google Docs, Google Sheets) in a Google Drive folder as .html files with Google Apps Script to load into a Salesforce Knowledge Base. The code ...
-1
votes
0
answers
61
views
Google Form Triggers [closed]
I have a training system built with Google Workspace where:
System Structure:
Master templates (forms, docs) are stored in admin-only accessible location
Each student has their own folder with ...
0
votes
1
answer
57
views
Trouble getting Post/Get Requests Between Google Web Apps
I have two Google Web Apps, one with a POST request and one with a GET request but the GET request seems to only receive a Google error page HTML and I'm not sure how to move forward.
The end goal is ...
