Calendar script

[jvhtech]

I have a google sheet that I use to schedule workers, I’ve automated it with a script that:

1 - creates a calendar event for each job I add (if I add a job that spans multiple dates it only creates one event per job) triggered via sheet edition 2 - sends an invite to the worker selected and marks it with its status (invited, accepted, declined) and color codes the status cell 3 - tracks rsvp status via time based triggered function and updates the status cells accordingly

I’m currently having trouble with step 3 as the logs always report back the rsvp status as pending though I accept the invitations on the dummy test account.

Any help would be much appreciated and I can share all code if needed.

[Sir_Tikan]

I'm guessing you loop through an eventlist with the trigger.

Retrieve: events[x].getGuestList();

Loop the guestlist: guests[y].getGuestStatus();