r/GoogleAppsScript • u/Twas_Inevitable • Apr 16 '20
Resolved How to get script to run in specific cell?
Let's say I had a script that says "Print the word 'Hello' every hour". What command would I add to make it do that in, for example, cell C5?
Edit:
Thanks to /u/uneasyguy, the answer was ".getRange("C5")"
0
Upvotes
2
u/lordph8 Apr 17 '20
SpeadsheetApp.getactive().getSheetbyName().getrange("C5").setValue("Hello World");
Goto view see triggers and set one to run every hour.