56,899 questions
Advice
0
votes
0
replies
36
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
0
votes
0
answers
35
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
1
vote
1
answer
37
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 ...
- 11
Tooling
0
votes
4
replies
46
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
39
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
54
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 ...
-3
votes
0
answers
39
views
Script "name" experienced an error, console log shows nothing just says failed [closed]
Script "name" experienced an error, console log shows nothing just says failed. Then they re run it a couple times and it runs fine
1
vote
2
answers
114
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
106
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
86
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
Advice
0
votes
0
replies
88
views
How to optimize slow initial load in Google Apps Script (HtmlService) with 1MB bundle
I am developing a Web App on Google Apps Script (GAS) using React and Ant Design. I use Vite with vite-plugin-singlefile to bundle everything into a single index.html for deployment.
The Problem:
The ...
- 1
-1
votes
1
answer
161
views
Drive API v3 rejects OAuth token when Gmail scopes are included in manifest
Problem Summary
I have a Google Apps Script that needs to:
Generate sharing links using Drive API v3 Advanced Service
Send emails with alias using Gmail API via REST
These work independently, but ...
-1
votes
1
answer
88
views
Google Sheets API PivotFilter.getFilterCriteria yields "Service error: Spreadsheets" when the filter contains a formula
PivotFilter.getFilterCriteria returns the expected result when the filter references values directly as in: 'Text contains A'. However, when the filter references formulas as in: 'Text contains =&...
- 25