All Questions
Tagged with gs-installable-triggers or google-apps-script
56,896 questions
0
votes
1
answer
75
views
Exception: API call to sheets.spreadsheets.batchUpdate failed with error: Empty response
I would like to know if there is someone intimately familiar with the Google sheets API who knows precisely what this error means:
Exception: API call to sheets.spreadsheets.batchUpdate failed with ...
- 359
-3
votes
0
answers
87
views
The parameters don't match the method signature for SpreadsheetApp.Range.setBorder [closed]
I am getting a failed execution on my script when trying to set the border of a range. The exception is
Exception: The parameters (null,null,null,null,(class),(class),String,number) don't match the ...
- 3,756
0
votes
1
answer
72
views
Removing/resetting cell background color to null or white conditionally
My function will run without error and it will log the new cell color of white, or null (whatever one I test with), but it will not reset the cell background color of any cells in the range if any of ...
- 707
0
votes
1
answer
94
views
Adding Multiple Guests to Google Calendar Event via Apps Script and Google Calendar API
I'm inserting or updating events from a Google sheet with the guests' names in one column and their email addresses in another column. For events with multiple guests, the emails and names are ...
-1
votes
0
answers
41
views
Extracting live data from listed Walmart products such as the price (ex 1oz gold bar) for apps script? [duplicate]
The goal of this is to query Walmart, filter by product “metadata”, grab top 5 results, average price) is doable in principle. I created the trigger to execute every 8 hours., but the key issue is ...
- 1
Advice
0
votes
0
replies
58
views
Is there anyway to extract live data from listed products (ei 1oz gold bar) for apps script?
The goal of this is to query Walmart, filter by product “metadata”, grab top 5 results, average price) is doable in principle. I created the trigger to execute every 8 hours., but the key issue is ...
- 1
-1
votes
0
answers
71
views
Automating importing live price of gold & silver, setting a trigger every 8hrs, and appending
I want to run a script to automate the process of copying live values into a new row every 8 hours as static data and append new data points to your sheet automatically to build a historical record ...
- 1
Tooling
0
votes
4
replies
55
views
Can Google Docs be converted to Apps Script with full formatting preserved?
I am looking for a method to programmatically reproduce a Google Docs document using Google Apps Script, including all formatting such as headings, fonts, spacing, tables, and other layout elements, ...
-2
votes
0
answers
42
views
GScript command for ‘Who can modify group details?’
How can I use GScript to change the parameter for ‘Who can modify group details?’
According to ChatGPT, this should be possible using the command ‘whoCanModifyGroupMetadata’, but this command isn’t ...
- 269
0
votes
0
answers
58
views
Why does "You do not have permission to access the requested document" script error happen AFTER all code in function has executed?
I have several Apps Script functions bound to a Google Slides file that is owned by a managed Workspace account. The account is the owner of the slide file and also owns the triggers in the script ...
1
vote
2
answers
122
views
Technical Issue: Pie Chart Slice "Distance from Center" and "Color" not updating via Apps Script
I am seeking help regarding a consistent technical issue with Pie Charts in Google Sheets when using Apps Script.
The Problem: When I try to programmatically update a Pie Chart, some visual elements ...
- 13
Tooling
0
votes
4
replies
126
views
Google Drive Folder File Counting Script
I need a reliable Google Sheets script that counts files in multiple Google Drive folders.
Requirements:
Handle all types of links or folder IDs in column E (plain URLs, rich-text links, or raw IDs).
...
Advice
0
votes
1
replies
45
views
Retain value of a cell
I have created a google form linked to a google sheet which captures users' request for a limited resource
It may be that the request fails because there were no resources left
However, the form also ...
0
votes
0
answers
54
views
Issue using .addRange to modify chart
I'm having issues using .addRange to modify an existing line chart. When I run the following code the range does not get added, but the title does change. I've copied this almost exactly from the ...
- 1
Advice
0
votes
2
replies
92
views
daily request limit for incoming HTTP requests
I'm deploying a Google Apps Script as a Web App (doGet/doPost) to serve as a webhook relay. The script uses only CacheService for storage — no UrlFetchApp, no Sheets, no Gmail, no other Google ...
- 1