I have 40-50 different google sheets (each sheet is for a different person) and I collect the data from all those sheets.
I want to add some functionality to all those sheets by running a script. Right now, I have to open each and every sheet one by one and manually write a different script for all those spreadsheets.
I have a file.gs script with me and I want to run this script on every sheet.
My question is how do I write a script which will allow me to trigger file.gs in every google sheet.
question from:
https://stackoverflow.com/questions/65661585/run-a-script-in-multiple-google-spreadsheets 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…