All Questions
Tagged with google-apps-script google-sheets-api
1,856 questions
0
votes
2
answers
66
views
Moving Value from Google Sheets Cell to Google Doc
I have a Google Sheet that has long blocks of text in each cell of column H (it is input from a long-form response box in a Google Form). I want to take each response and move it onto a new page of a ...
0
votes
1
answer
45
views
Google Workspace Add-on doesn't display homepage card in Sheets, only shows “Help” button after installation [duplicate]
I'm building a Google Workspace Add-on for Google Sheets using CardService. I’ve configured the homepageTrigger properly in the manifest and the onHomepage() function returns a simple card with a ...
0
votes
0
answers
72
views
SheetsChart refresh not working in "Slideshow" mode
I want to updated a liked SheetsChart for Google Slides. It works instantly when the slide is in edit mode, doesn't refresh the chart with latest data from Google Sheets when it's in "Slideshow&...
- 17.5k
0
votes
1
answer
104
views
How to Automatically Trigger a Webhook on New Row Addition in Google Sheets Using Google Apps Script?
I’m working on a feature where a client can link their Google Sheet to my system. Whenever a new row is added to the sheet, the system should send the new order data to a webhook. My initial approach ...
- 93
1
vote
1
answer
66
views
Not able to convert Excel file into google sheet
I have an XLS file in Google Drive. Using Google Apps Script, trying to convert to Google Sheets. But it is being stored as Google Docs instead.
function readBlob() {
var file = DriveApp.getFileById(...
- 71
0
votes
0
answers
38
views
Is it possible to update (add/edit/delete) named functions using apps script [duplicate]
Context
We have a master template and many users using copies of it in their accounts.
I'm using apps script to update users sheets to new version, once we make changes to master template spreadsheet.
...
- 1,580
0
votes
0
answers
50
views
When do time-driven triggers initially go off?
I'm using time-driven triggers in my apps script to get it to run my code every 2 hours. The problem is that there are reasonably specific times I would like this to happen - it doesn't have to be ...
0
votes
2
answers
316
views
Bundling changes made by a script, so that it can be reverted by one undo (ctrl+z)
I've written an Apps Script function that sets values to non-contiguous cells in multiple sheets. This particular function is tied to a custom sheet operation that the user can call from a custom menu ...
- 347
0
votes
2
answers
68
views
Why after adding 30+ codes into App Script all codes in it started to work with bugs
I'm trying to organize my partner management using Google Sheets. I have a main spreadsheet where columns F-I are dynamic, meaning I want data from these columns to be transferred to columns A-D in ...
- 1
1
vote
1
answer
70
views
Custom Menu Not Displaying in Google Sheets Add-on After Deployment
The problem:
I am developing a Google Sheets add-on using Google Apps Script. The goal is to create a custom menu in Google Sheets that allows users to apply specific formatting options. The add-on ...
1
vote
1
answer
91
views
How do I center my pdf download using app script?
I've used a script from a kind and helpful commentor and it worked if my format in the sheets are the same. However, when i type in the details and the row size changed, the page is shifted to the ...
- 47
1
vote
0
answers
181
views
App Script to download specific cells in Google Sheet to PDF [closed]
Edit: I've used a script from a kind and helpful commentor and it worked if my format in the sheets are the same. However, when i type in the details and the row size changed, the page is shifted to ...
- 47
2
votes
1
answer
71
views
Trouble Populating Google Sheet Column with CVE Descriptions - CVE ID Undefined
I'm trying to use Google Apps Script to populate column D of my Google Sheet with the corresponding CVE description based on the CVE ID from column A. I'm getting the CVE descriptions/summary from the ...
- 21
0
votes
1
answer
85
views
Resolving TypeError when trying to use findIndex
I'm trying to figure out why I'm getting the following error:
TypeError: Cannot read properties of undefined (reading 'includes')
The error occurs at the line var nameIndex = dataFlatArr.findIndex(s =&...
- 772
1
vote
2
answers
122
views
How do I compare new IDs with a column of existing IDs and allowcate a timestamp if two IDs match on Google Sheets?
I would really appreciate it if someone could help me get this tricky function right on google sheets.
Everytime stock is scanned I would like to see the timestamp next to that stock ID on google ...
- 13