Looking to do this server-side (Google Apps Script) ideally rather than to do it client-side (JS).

I’m using the below code to check if the input value match with any value of google sheet column.

I’m using the below code to check if the input value match with any value of google sheet column.

i have these column that i want to work on
i have initial list of name on ItemDB!D3:D
and these 2 column Purchasing!E2:E and Sale!G14:G that have part of the name from ItemDB!D3:D, also on Purchasing!E2:E and Sale!G14:G i use data validation from list of ItemDB!D3:D.
Then i make a button with the name of updateValues, and i try to make a apps script so when i clicked the button, it will check cell that change on ItemDB!D3:D then after find the change, it will also change the cell on Purchasing!E2:E and Sale!G14:G

I’m using a function made in javascript in a platform called voiceflow. It has an input variable known as range which only fetches a specified sheet name data. I want to modify the function to fetch data from all sheets present in the Google spreadsheet.

I have a column with data in google sheets like this:

I’m trying to utilise the exec function within a forEach loop, as follows:

How to give permission to Authorized users to use the apps script web app without them giving access the google sheets? I am so confused right now. Please help me…
So I also create AuthorizedUsers sheet where there is the list of the emails of the authorized people I want to give access. So when they click the link of the web app the authorized users should be redirected to the index page while the non authorized users should get the message “You are not authorized to access this application.” but the issue here is that, when the other users tried to access the web app even if their email is in the AuthorizedUsers sheet they are still getting a message like this “You are not authorized to access this application.”

I am trying to get ranges by using getRangeList method but I am getting error Exception: The parameters (String) don't match the method signature for SpreadsheetApp.Sheet.getRangeList

I work for a big organisation and we have some large google sheets that multiple users use (however maybe at one time it would be maximum 7-10). I am working on automating some processes for this sheet. For example one of the app scipts i am working on, I would like users to once they have inputted data into a row to complete a QA check and once completed they would input ‘r’ into one of the cells and this will then print out the users email and date they reviewed. The issue is, this does work. however sometimes it wont work for some cells and some sheets. some days it wont work at all and some days it does. I checked the google app script quota limits and from what it seems we are not exceeding the limit here. Therefore I am completely baffled as to why its not working, perhaps its my code? maybe theres a way to optimise this code also? its annoying to have to keep updating the column index numbers if changes happen to the sheet. the title of the column is the same on all the sheets (QA) so i thought about using that as a reference instead of referncing each sheet and the index of the column affected?