56,899 questions
-3
votes
0
answers
55
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
64
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
88
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
40
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
52
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
56
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
0
votes
0
answers
55
views
Google drive api v3 transfering ownership keeps stated that i don't have permission
I'm want to transfer files quickly to my other account using python. But I get a problem whenever I tried, it always returns
2026-04-17 17:22:45,421 INFO file_id=...<file-id>....- status=failed ...
- 9
Tooling
0
votes
4
replies
52
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
40
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
57
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
119
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
113
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
43
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
90
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
