Skip to main content
56,954 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
66 views

as per below code, from GoogleSheet, I wanted WhatsApp to open with some specific text ready to be sent when user sets a cell to "Ready to Print". The problem is every time a column in ...
Valerie Ho's user avatar
  • 11
0 votes
0 answers
35 views

I have recently gotten into Google Scripting to manage a School's IT space. I am currently working on a script that should check any students who have left and remove their paid licenses. However, I ...
Leon Sangster's user avatar
  • 1
2 votes
1 answer
97 views

I have an application (running on an IoT Boron device from Particle) that posts error messages to a Google sheet via a Webhook Web Form. The sheet serves as a log of application faults and this has ...
blshaw45's user avatar
  • 1
1 vote
1 answer
53 views

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 ...
Stuart L's user avatar
  • 179
-2 votes
1 answer
39 views

I am trying to create a simple Invoice generator that includes our company logo, but the logo will NOT render in the final PDF. I am designing the invoice template using HTML instead of a Google Doc ...
Amanda Schneider's user avatar
  • 1
0 votes
1 answer
61 views

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 ...
Kacper Bednarski's user avatar
  • 1
0 votes
1 answer
68 views

Hopefully, the title is clear. What I am NOT asking. How to update the cells background color to match the Theme via hex color code. How to update the spreadsheet theme colors themselves via appscript....
JesseRigon's user avatar
  • 43
0 votes
1 answer
59 views

I’m building a Google Docs add-on using React + Google Apps Script (via clasp). From the sidebar, I receive a .docx file as a Base64 string (binary content). I can successfully convert the .docx to a ...
Muhammad Talha's user avatar
  • 77
1 vote
3 answers
148 views

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 ...
Stuart L's user avatar
  • 179
Advice
0 votes
4 replies
58 views

I have an Add-On under review in the Google Marketplace. My Add-On runs in Google Slides and needs to access Google Sheets data to create various visuals in Slides. Specifically my Add-On pulls data ...
steeveesas's user avatar
  • 67
0 votes
1 answer
78 views

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-...
Remmerboy's user avatar
  • 3
3 votes
0 answers
57 views

I'm developing a Google Workspace Add-on for Google Drive and have run into a strange rendering bug. When my add-on is opened in the Drive sidebar, the card generated by my homepageTrigger function is ...
Yamanqui García Rosales's user avatar
  • 21
Best practices
0 votes
4 replies
70 views

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 ...
Sentient Onion's user avatar
  • 5
0 votes
1 answer
89 views

So as per previous suggestions, I'm using checkboxes to replace the .getUi method so my project will work properly on mobile devices. I've come across a strange scenario and I wanted to confirm this ...
Stuart L's user avatar
  • 179
2 votes
1 answer
74 views

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 ...
benchenggis's user avatar
  • 305
1 vote
2 answers
109 views

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 ...
Stuart L's user avatar
  • 179
1 vote
1 answer
82 views

I have a column of checkboxes, which drives some downstream processing if they are checked. At the moment, my code creates the array of checkbox values but only uses it to check if any checkboxes have ...
Stuart L's user avatar
  • 179
0 votes
1 answer
122 views

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 ...
Eastland's user avatar
  • 1
0 votes
0 answers
54 views

I have a add-on app where i have added multiple commands . In that I have a slash command called /share which should open dialog . so its opening and closing after some time and the error says Server ...
Integration Developers's user avatar
  • 1
0 votes
0 answers
33 views

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 ...
Unexperienced dude 69's user avatar
  • 13
0 votes
1 answer
90 views

I am facing a critical authentication issue where a newly generated Google AI Studio API key consistently fails with a 400 API_KEY_INVALID error, both from Google Apps Script and a standard Node.js ...
Ângelo Fernando Cruz's user avatar
  • 1
-1 votes
1 answer
48 views

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 ...
zambonidude's user avatar
  • 9
-1 votes
1 answer
134 views

I'm facing a persistent 404 NOT_FOUND error when trying to call any Gemini model (e.g., gemini-1.5-pro-latest, gemini-1.0-pro) via the Vertex AI API from a Google Apps Script. I have exhausted all ...
Ângelo Fernando Cruz's user avatar
  • 1
1 vote
1 answer
53 views

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 ...
Joey Perkins's user avatar
  • 9
0 votes
1 answer
74 views

I have a script which applies protection (ie, performs a .removeEditors) via an installed trigger to a sheet row depending on some user input. There is a possible use case whereby the user (not the ...
Stuart L's user avatar
  • 179
1 vote
1 answer
64 views

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 ...
Dima's user avatar
  • 40.6k
1 vote
1 answer
61 views

I have a spreadsheet from last year and it worked OK then. Without edits, I opened it and now it throws this execution error: Exception: The parameters (SpreadsheetApp.Range,number,(class)) don't ...
Majal's user avatar
  • 1,771
1 vote
1 answer
102 views

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() { ...
Stuart L's user avatar
  • 179
1 vote
1 answer
70 views

Depending upon a specific input in a set of cells on my Google Sheet, I want to be able to freeze a particular row and stop it being updated. I have the following script: function testFreeze() { ...
Stuart L's user avatar
  • 179
0 votes
0 answers
77 views

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 ...
CodePanda's user avatar
  • 150
0 votes
0 answers
51 views

I am running a Google Apps Script to programmatically update Gmail signatures for users across my Google Workspace domain using a Service Account with Domain-Wide Delegation (DWD). Despite confirming ...
nano nano's user avatar
  • 53
0 votes
0 answers
41 views

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 ...
FernandoT's user avatar
  • 1
0 votes
1 answer
64 views

I have a published Web App in Apps Script set to "anyone in my domain can view" that I need to "execute as me". If an end user is only signed into Google accounts that aren't in my ...
xd1936's user avatar
  • 1,211
-1 votes
1 answer
62 views

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 ...
Hoàng Huy's user avatar
  • 1
0 votes
1 answer
70 views

I have a file that includes a variety of reference sheets and sheets that are only used at the end of the academic year plus a tab/sheet for individual students. Students come and go so I need the ...
Charity's user avatar
  • 17
1 vote
0 answers
52 views

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....
Jinnosuke Yamada's user avatar
  • 1
-7 votes
1 answer
150 views

I have a javacript that create an Html file and i wanna send it to some email addresses So i made an app script doPost seen below... But everytime try to send the emails with my button on my web page ...
Rapport Dexpulsion Rive-Sud R's user avatar
  • 1
0 votes
0 answers
40 views

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 ...
Antoine Gendron's user avatar
  • 1
0 votes
0 answers
36 views

I am developing a script that will update all the user signatures in our workspace. It works however the signature label is "My Signature" instead of the primary email e.g. [email protected]. ...
Carmad94's user avatar
  • 79
0 votes
0 answers
69 views

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() ...
Noideas's user avatar
  • 127
0 votes
1 answer
68 views

As part of an onEdit function, I compare two times. If the second time is less than the first time, I will get the user to re-enter the time so that it is later. My problem is in comparing the two ...
Stuart L's user avatar
  • 179
0 votes
2 answers
98 views

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"); ...
Daniel Ostrosky's user avatar
  • 9
1 vote
1 answer
65 views

I have a script which is trying to clear a range of cells. However, it doesn't do anything: function smlsmlTest() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(...
Stuart L's user avatar
  • 179
1 vote
2 answers
88 views

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 ...
Christoffer Bergman's user avatar
  • 376
1 vote
2 answers
95 views

I have an onEdit script that check for updates to certain cells and then does stuff based on the contents of the cell: function onEdit(e) { var sheet = e.source.getActiveSheet(); if (sheet....
Stuart L's user avatar
  • 179
1 vote
2 answers
186 views

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 ...
C. V.'s user avatar
  • 11
0 votes
0 answers
35 views

I have the following code: /** * Setup function to install the onEdit trigger * Run this once to set up the installable trigger */ function setupTrigger() { try { // Delete any existing ...
orschiro's user avatar
  • 22.2k
2 votes
2 answers
170 views

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 ...
cup's user avatar
  • 8,548
0 votes
0 answers
78 views

I have created a Google Sheet and paired Apps Script with which I am sending emails. Now, I understand that there is a limitation with the SendMail function where you can’t amend the “from” field, ...
James Patrick-Gleed's user avatar
  • 1
1 vote
1 answer
145 views

I’m building a Google Apps Script library and I’d like to expose some constants as a nested object. var CONFIG = { LEVEL0: { LEVEL1_A: 'A', LEVEL1_B: 'B' } }; When I use this library in ...
kuba.jal's user avatar
  • 65

1
2 3 4 5
…
1140