Morning!
I see that I can create a google calendar event entry on creation of a google sheet row.
what I would like to know is: can I create an event when a particular cell has a particular word entered?
more deets:
I am a dog walker and have a ssheet with listed where I am when - once a fortnight I am in a local town called Yackandandah - Yack in brief.
I would like to automate so when in column C the word Yack appears then an event is created in google calendar. If this could be a 9am-1pm event vs a whole day event it would be great!
thanks!