I’m working on our marketing campaign master plan that has a lot of moving pieces including types of campaigns, platforms to post, person in charge and date it needs to go out. I want to put into a separate google calendar that everyone has access to so that its very easy to see when something should be going out and who is responsible for it, as well as be able to get notifications and reminders about it.

I followed this guide by google which explained how to link the sheet to a google calendar. https://workspace.google.com/blog/productivity-collaboration/g-suite-pro-tip-how-to-automatically-add-a-schedule-from-google-sheets-into-calendar . I followed the steps and the script runs fine. I was also able to get the button up onto the sheet to sync changes on to the calendar, but it won’t go onto the calendar. I created a new calendar for the information to go onto that everyone will have access to, but even with that calendar ID linked into the script, there seems to be an issue.