Hello All,

I have a google sheet with dates and titles, I need to create events on google calendar based on the title and date of the input.

My Sheet looks like this:

My goal

To sync inputs of google sheet with google calendar and create calendar events based on the dates on the sheet.

I have succeeded on doing the following:

• Create a new event if the “Project/Talent” columns is not empty.
• Create event on the date and time in “Publish Date” and “Publish time”
  • I have created a row with the following formula in order to have both date and time in a single row, I hid this col and pointed Zapier to get the date/time of the event out of this col.

    =A2 + B2

     

However, I face the following issues:

• When I edit an entry, it will be considered as a new event and I’ll have duplicated calendar events on the same date.
• Deleting and entry wont delete the event from the calendar.

PS: I’m trying to make the Google Sheet very simple and user friendly as it shared between all the team members and the producer / manager has to enter the time, title, and platform.

I wonder if anyone can help me out on solving those issues.

Thanks in advance