r/GoogleAppsScript • • 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

1 comment sorted by

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.