I found this piece of code and need to modify it so that if it doesn’t find a result it will return and keep running next lines of code So if it doesn’t find “JOHN” it currently stops running and throws an error. I would like it to move onto next piece of code if no result found. appreciate any
Tag: google-sheets-api
App Script new Google Sheet creation issue
I am trying to write an App Script that takes string data from multiple different spreadsheets (completely separate documents) and puts them all in a new spreadsheet. When I run the logger, it shows me all the data I want. I want each piece of data to show up in Column A, but when I run my script, it only
NodeJS accessing Google SpreadSheets
I made this code (index.js): I’m trying to connect my code with a google spreadsheet. For the connection, I’m using node.js, but I’m getting this error message. Does anyone know why I’m getting this error? What am I doing wrong? Answer When I saw your showing script and your error message, I’m worried that the current version of google-spreadsheet you
How to sort sheet by cell’s background color – have the code, but don’t understand the error
I’m trying to finish this project but the last part is holding me up for 2 days now. I have a Google Sheet, very simple, and I just need it to auto-sort by cell’s background color. I have 7 colors that I need in this order, and I have tried using the Sort Range Plus extension, which does work, but
google script sheet, merging rows duplicate in array [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question lets say i have a 3D array data with something like this (dynamically duplicates, sometimes 2-5 records) after processing from a sheet get range and
Find Google Sheets that matches a value in a cell of a sheet and execute a piece of code
I am sorry for this hideouts looking question but I have to ask. So bare with me. I am using google app script and trying to achieve following. I have two google spreadsheet books. 1.) Book A has only one sheet. 2.) Book B has 10 sheets. 1.) In Book A’s sheet column A contains range of text values. Ex:
Replace multiple occurrences in String on Google Spreadsheet
So I have a spreadsheet up for the purpose of documenting descriptions of functions found in some python files. TLDR these descriptions are hard to read due to the clutter left over from the files. So my solution to solve this was: But it only works on the first occurrence when I need it to happen multiple times. Everything I’ve
Google Sheets API v4 write data
I am trying to write data to a Google Sheet using the Nodejs API v4. I can sucessfully read and clear data, so I have set everything up correctly. However, using the example in the docs here for the update method, I cannot work out how to specify the data I want to put in the Google sheet. I would
Vis.js JSON data to Google Spreadsheets Range
I have a little issue trying to retrieve the data from the Vis.js (here a example!) nodes position and edges related to the id, to a Google SpreadSheets range. Here’s the code (HTML and GAS) I think the problem is here, in the HTML Side 🡇 Recap: At this point, i have problems to read the data from the google
Trying to add a hyperlink to Google Sheets via API
I’m using the gapi.client.sheets.spreadsheets.create() method and passing in an object to create a spreadsheet with some predefined values. I’ve tried various implementations and haven’t yet succeeded in pulling it off. I’m referring to the docs here: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets#CellData. My Object looks something like this: Google says: “To set it, use a =HYPERLINK formula”. Is this not the hyperlink formula? When the