56,940 questions
0
votes
1
answer
29
views
Copy and paste with .getValues / .setValues, but clearing the array inbetween
I have a table which looks like this:
I want to copy the first two columns of data and insert them before the EOF, but empty them before the paste. The end result should look like this:
So far, my ...
- 167
0
votes
1
answer
41
views
Google Cloud log-based alert policy not triggering any incidents
I’m having trouble getting a log-based alert policy to work in Google Cloud Monitoring. I can see the logs in the Logs Explorer and the filter seems to match correctly, but the alert never triggers ...
-2
votes
1
answer
71
views
Different behaviour running code from IDE compared to button on sheet [closed]
I am testing out array handling with checkboxes and have the following code:
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
function arrayTest() {
var bigArray = ...
- 167
0
votes
0
answers
80
views
Ebay API data visibility issue [closed]
I am working on eBay data automation using Google Sheets. My code extracts data from eBay via the API for specific fields. However, one field — i.e., the Shipping Label — has a value of 0 for some ...
1
vote
2
answers
80
views
Comparing multiple flags at once
I have a script which checks the value of a series of flags before deciding on an execution pathway. Because of the way the script executes, the flag values are held as script properties, therefore ...
- 167
0
votes
1
answer
65
views
Filter in Filter or Query/array for multiple sheets
I'm a long time reader, first time poster.
I'm having a problem showing invoice details for each company id for this sheets.
https://docs.google.com/spreadsheets/d/1iTJ8PR3snsbZKh01-...
Best practices
0
votes
4
replies
65
views
Handling Multiple Sheet Inputs
I have a spreadsheet that receives data inputs externally. That data is used by sheet formulas to calculate an output which is then collected via an HTTP request.
What is the best way to allow google ...
2
votes
1
answer
63
views
Stacked column chart to use column A as header in App Script
I have this table and the chart I want as below:
To acheive this I have to switch rows/columns, and use column A as headers.
However I cannot find the corresponding command for the checkbox "Use ...
- 305
1
vote
2
answers
98
views
Checking for changed checkbox value
To get around the fact you can't pop user dialogue windows on mobile devices, I have created a simple function which posts any error messages to a cell and waits for the user to check a checkbox to ...
- 167
0
votes
1
answer
110
views
Looking for a specific word in a Title in a cell then pushing a numerical code to a different cell in Google Sheets
My situation in Google Sheets: I have a list of target words and phrases in column A (as few as 20 to as many as 400), in column B I have 3 and 4 digit number codes assigned to each target word and a ...
- 1
0
votes
0
answers
33
views
Appscript doPost Logs not showing up [duplicate]
I am using the reserved doPost(e) function to handle my posted CSV file data. When I try to access the data using e.postData.contents and log the contents, nothing is logged. Actually, it is more like ...
-1
votes
1
answer
46
views
How to loop an Apps Script / Cheerio web scraper over multiple urls? [closed]
I have this Apps Script / Cheerio function that successfully scrapes the data I want from the url. The site only displays 25 entries at this url. I can find additional entries on subsequent pages (by ...
1
vote
1
answer
50
views
Why does my Telegram bot repeat the same response after clicking an inline button (callback_query) when using a Google Apps Script webhook
I’ve built a Telegram bot hosted on Google Apps Script, using a webhook to handle updates.
When I click on an inline button, the bot sends the correct reply, but it keeps repeating the same response ...
1
vote
1
answer
63
views
How to test a Google Drive add-on?
I have written a simple add-on using google apps script, and "deployed" it as "Add On".
But whatever I do, I cannot figure out how to connect that add on to my drive account so I ...
- 40.6k
1
vote
1
answer
100
views
Google Sheets script - slow running
I have the following code to copy the last row (effectively used as a template) and paste it a user-defined number of times into the sheet, effectively inserting new rows:
function InsertNewRows() {
...
- 167
0
votes
0
answers
76
views
Google App Script randomy fails with "Summary of failures for Google Apps Script: Not found"
I have a Google Apps Script project that fails randomly.
Sometimes, it will work fine for days and then fail multiple times in a day
Note: The code doesn't change. Code make use of email, google sheet ...
- 150
0
votes
0
answers
39
views
Publish group google calendar event via google script
Through the google calendar publish event interface, it is possible to copy an URL link which can be used by others to see that event, if they have access to the calendar.
Google Calendar Publish ...
-1
votes
1
answer
61
views
Google Workspace Add-on rejected with generic 'Add-on error' when calling external API (UrlFetchApp) [closed]
I have developed a Google Workspace Add-on (published from a standalone Apps Script project) that relies on making an external API call for verification and event logging. The app works perfectly when ...
1
vote
0
answers
52
views
Google Apps Script getOAuthToken() times out when calling authenticated Cloud Function, despite all configurations checked
Goal:
I am trying to call a 2nd Gen Google Cloud Function (Python, private/requires authentication) from Google Apps Script (GAS).
The Problem:
The execution consistently fails. When ScriptApp....
0
votes
0
answers
38
views
Inconsistent Master/Theme Application when Batch-Inserting Slides via Apps Script
I am facing a strange and inconsistent issue with theme application when generating presentations using the Slides API and an Apps Script helper function.
My Goal:
I'm building a service to generate ...
0
votes
0
answers
65
views
Error 405: Moved Temporarily from Google Apps Script even though server still accepts the payload
Assume the following simple setup for sending telemetry to Google Sheets:
Curl -> Google Apps Script deployed as Web App -> Google Sheet -> Cell 1:1
Google Apps script is a simple doPost() ...
- 127
0
votes
2
answers
97
views
Make onEdit work for two separate tables within the same sheet [closed]
How would I be able to make this function work for two separate tables within the same sheet?
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Leaderboard"); ...
1
vote
2
answers
88
views
Fetching overridden events from Google Calendar
I have a Google Apps Script to automate the description of Google Calendar events. The script runs once a week and tries to fetch, and modify, the occurrence for the week to follow.
The code to find ...
1
vote
2
answers
178
views
How do I add a row after a group of data in Google Sheet to overcome its time limit?
I'm very new to using Apps Script, and I'm working with a sheet with over 82,000 rows. I'd like to run a script to create an empty row after a group of surnames (column A) sorted alphabetically to ...
- 11
2
votes
2
answers
168
views
Change default indentation in Google Apps Script editor
How do I change the default indentation in the Google Apps Script editor. It defaults to 2. Even though there are lines, I find it difficult to align the code blocks, especially when they are quite ...
- 8,538