Skip to main content
2,151 questions
Newest Active Bountied Unanswered

Question list filters

Filter by
Sorted by
Tagged with
Score of 0
0 answers
211 views

I’m trying to build a simple Google Chat bot using Apps Script. I’ve followed the official documentation: Created the Apps Script project with handlers onMessage, onAddToSpace, onRemoveFromSpace. ...
Score of -1
1 answer
75 views

Javascript code that needs to send an email to a specific email from a column list (B). Whenever there is a change between comluns H to M in my Google Sheets. Expected Result: The code should send a ...
Score of 0
1 answer
79 views

I have a master and multiple copies of a sheets workbook. I would like to update the master and have the copies update AND filter the update according to a specified name/id value. I have used the ...
Score of 1
2 answers
653 views

I am trying to open a doc file and replace a value using the simple snippet: function openFile(){ var doc = DocumentApp.openById("docId"); var body = doc.getBody(); body.replaceText(&...
Score of 1
1 answer
85 views

We created a Google Web App in 2019 using the classic version of Google Sites. The associated Google Apps Script was accessible via the "Manage Site" menu at sites.google.com. However, since ...
Score of 0
0 answers
141 views

I'm trying to put a 2D Game made in unity into the google play store. Never done it before and when I'm trying to upload the app bundle in google play console, I get the error, You have uploaded an ...
Score of 0
0 answers
84 views

I'm trying to create a form for my employees to submit their tickets using Google forms. The user is going to receive the ticket id as a confirmation message, and Google sheets will show the ticket id ...
Score of 0
1 answer
138 views

I'm using Google Apps Script (SlidesApp) to dynamically generate a Google Slides presentation. On one of the slides, I need to mix text and a list. I prefer to keep these both within the same textarea ...
Score of 3
0 answers
350 views

I used the following document to use Google as my idP to AWS. I followed the instructions and apart from the final step (Step 7: Google Workspace: Confirm Google Workspace users access to AWS ...
Score of 0
2 answers
730 views

EDIT: Final solution has been added as answer but I marked Tanaike's answer as solution as he pointed me towards the right direction. I'm setting up a Google AppScript to automate a bit of reporting. ...
Score of 0
0 answers
47 views

I have a local link: image.domain.loc/image01 that contains an image, There is any way to access this image in GSheet /GAPPS script without a Proxy or a tunnel? I need an easy way to insert image in ...
Score of 0
0 answers
59 views

My question is, how can I get Macro1 to work as intended (complete the network request(s) and open the model popup with embedded hyperlink) when called from the checkbox onEdit listener? I've written ...
Score of 1
1 answer
115 views

Have this Google Sheet: SourceSheet (sample data) is available: SourceSheet Trying to implement protection rules: The ranges B2:B10 and B13:B21 can be edited by everyone. Ranges D2:D10 and F2:F10 ...
Score of 0
1 answer
119 views

I have a table like this: SourceSheet (sample data) is available: SourceSheet I need to protect all cells but certain ranges can be edited by everyone and some ranges can be edited by only users ...
Score of 0
1 answer
174 views

I am trying to pass data from one Google Sheet: Data transfered to another sheet by URL: https://docs.google.com/spreadsheets/d/1gFuY2i50Vxdl5kx7iHZAupILAW2u35KYSRzCKKXMWIk/edit#gid=0 Data (specific ...

15 30 50 per page
1
2 3 4 5
…
144