All Questions
Tagged with google-apps-script google-sheets
27,567 questions
0
votes
0
answers
38
views
Exception: Service Spreadsheet Failed while Accessing spreadsheet [closed]
I’m using an api to fetch replies sent via Telnyx sms and populate those replies into my sheet one row at a time.
I ran the script successfully several times today getting as much as 10 replies.
Now ...
0
votes
0
answers
58
views
Menu not showing after install; issues with onOpen() and AuthMode.NONE [closed]
I'm working on a Google Workspace Add-on (a Mail Merge tool), and I keep getting rejected by the GWM review team with this feedback:
*
Menu - Menu options not shown after App is installed. Please ...
-5
votes
0
answers
42
views
Creating a conditional function in Apps Script (Sheets) that auto-populates a new entry [closed]
I'm in the very early stages of building out this script, so any guidance is appreciated.
I have a Sheets document that inventories devices such as laptops. Each entry has a variety of columns ...
1
vote
0
answers
65
views
Change title of table depends on the title in the sheet using data array [closed]
Is there a formula using the data array that, when I change the value in the sheet, also changes the title in the data array and refelect it in the table?
Here a example when i change the April 1, ...
- 27
0
votes
1
answer
75
views
How to troubleshooting a Google Script on a sheet to auto-send Emails [duplicate]
I have been trying to make this code work to send an email when I edit my sheet. It's just not working, can someone give me guidence?
photo of the sheet
photo of code in editor
function onEdit(e) {
...
0
votes
3
answers
117
views
Sort Sheet Range in Natural Order
Using Google Apps Script (not using functions), in Google Sheets, how can I sort a range in natural order (so that "4. This thing" comes before "10. That Thing"). Here is what I've ...
- 2,663
-1
votes
1
answer
83
views
Exception: The parameters (String,String,null,(class)) don't match the method signature for CalendarApp.Calendar.createEvent
I am trying to create a google sheet that I can use to schedule a workshop servicing calendar.
I have followed the below tutorial but am getting something wrong, hoping someone can easily identify the ...
0
votes
2
answers
62
views
How can I prevent my Apps Script code from timing out?
I have the following code:
function onOpen() {
const ss = SpreadsheetApp.getActive();
ss.getSheets().forEach((sheet, index) => {
if (index < 9) {
const lastRow = sheet.getLastRow();...
- 53
-6
votes
0
answers
41
views
In google sheets if a cell colour changes to yellow perform a vlookup in that cell [closed]
In google sheets is there an app script where if the cell colour changes to e.g. yellow, then within the same cell it performs a vlookup against a table. The value returned then needs to multiply by ...
- 11
-2
votes
1
answer
60
views
TypeError: targetSheet.appendRows is not a function in Google Apps Script (even in a new sheet) [closed]
I am encountering a persistent TypeError: targetSheet.appendRows is not a function in my Google Apps Script, even in a brand new Google Sheet.
My overall goal is to copy data from multiple sheets (...
- 5
-2
votes
1
answer
110
views
How to sort a 2d array in Apps script (google sheet) base on a 1d array
I have a script that I have been using for some time, but I recently had a bug on the data sorter and since then I have been unable to fix the problem.
I transpose arrays because they are normally ...
0
votes
1
answer
112
views
How do I write a function to validate a UK Postcode in a Web App
I have a web app which works fine but I would like to validate a UK postcode as the input postcode field is entered (if possible).
A code snippet of the HTML input field is included with the regex ...
-3
votes
0
answers
43
views
Automate Phone Calls with Google Sheets Apps Script [closed]
I have a Google sheet with 400+ names, emails, and phone numbers that I am calling. I have already written an Apps script that automatically sends mass emails out on the click of a button. I automated ...
-9
votes
0
answers
63
views
google sheet scrip to automate sending an Email contain parts of google sheet [closed]
Can I get help in this
My boss asked me to send him part of my google sheet daily to his Email ( Outlook).
I want to automate this so I searched for many solution.
But the issue is my boss needs that ...
0
votes
1
answer
59
views
Google Sheets to Google Doc Template - Table [duplicate]
I am trying to create a automation that takes a Google Sheet and autofills its data into a Google Doc from a template. In the template document, some of the fields that will be replaced are inside of ...
