56,854 questions
Score of -6
0 answers
58 views
"Unable to open file" on requests with query string, but no execution logged [closed]
Problem description
I have a Web App published with Google Apps Script (deployment type "Web app", Execute as: Me, Who has access: Anyone). After working normally for months, today the Web ...
- reputation score 1
Score of -4
0 answers
104 views
Web app requests take 30-59s client-side while Executions log shows 1-2s — delay outside script execution [closed]
I'm seeing severe latency on an Apps Script Web App, and I've isolated the delay to somewhere outside my script's execution.
Executions log vs client-side timing for the same requests:
Executions log ...
- reputation score 19
Score of 0
2 answers
176 views
Automatic Static Date Stamp
I'm trying to add an automatic static timestamp in this ticketing process:
Sheet A column B is labeled "Data Received". The user manually inputs the date when they receive a ticket.
When ...
- reputation score 3
Advice
0
votes
1
replies
140
views
Apps Script limits for a personal account
It's important for me to understand if I pay for the starter plan, whether I'll get an increased Apps Script limit, like enterprise accounts.
Либо нужен другой, более дорогой тариф. Не могу найти ...
- reputation score 1
Score of 1
1 answer
231 views
429 Error on Google Sheets script pulling from Google Books API
I've created a Google Sheet where I enter a book ISBN in cell A2 and want the book title returned in cell B2 upon the click of a button that I've associated with function getBookData(). However, my ...
- reputation score 13
Score of 0
1 answer
153 views
Google Sheets doesn't catch the user email via event [duplicate]
The task is: several users edit Google Sheets table. All of them have Editor's role. Some of the users are masterusers - they can edit everything. Some are clients - they can edit only empty time-...
- reputation score 356
Score of 0
1 answer
112 views
Timed Email Notifications for multiple tabs, specific emails, based on dates in spreadsheet
I have a task manager spreadsheet for my company's project managers. Each person has their own tab that they add in their projects, due dates, etc. They get email notifications sent when an upcoming ...
- reputation score 1
Score of 0
1 answer
242 views
Error in fetching pdf file from a website using google apps script UrlFetchApp
I have a Google Apps Script that downloads a daily PDF rate sheet from a public financial website. This script ran perfectly for months but suddenly stopped working around April 9th.
Instead of ...
- reputation score 113
Best practices
0
votes
7
replies
170
views
Static URL for Google Apps script?
Although each project has a name, Google Apps scripts use an automatically generated URL to make them available via the internet. This URL changes with each iteration of the code. Meanwhile a schedule ...
- reputation score 48380
Score of 0
1 answer
143 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 ...
- reputation score 359
Score of 0
1 answer
104 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 ...
- reputation score 703
Score of 0
1 answer
147 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 ...
- reputation score 71
Advice
0
votes
1
replies
104
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 ...
- reputation score 1
Tooling
0
votes
4
replies
88
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, ...
- reputation score 1
Score of 1
2 answers
152 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 ...
- reputation score 13
