Think i’ve figured out why! Our calendars was created with the work email but the sheet belonged to the personal email. which is why it was giving the error.
Now that has been fixed, is there a way we can make the approval manual? and have the script read those approval and note them on the sheet + calendar?