search

GCalTools / Sheets2GCal

Issue Tracker for Sheets2GCal Google Sheets Add-on
1 stars 2 forks source link

Can no longer update or sync #44

Closed sequatchiecovecreamery closed 8 months ago

sequatchiecovecreamery commented 8 months ago

Sheets will no longer export to calendar as of two weeks ago. After copying import data into master sheet and selecting update and attempting to sync the response we receive is that "0 events created" and "0 events updated." Nothing has changed on our end as far as we know, everything just stopped syncing two weeks ago. Any suggestions would be appreciated. I have attached a screen capture of the issue as well. Capture Capture

GCalToolkit commented 8 months ago

Hi, you can move most of the columns around but column A must be "Delete" and column B must be "Update". If you put those 2 columns back where they were originally it should work normally!

sequatchiecovecreamery commented 8 months ago

Thank you. I believe that was definitely part of my problem. When I made the switch on the columns it still did not work though so I determined it must be something else as well. What finally worked was Importing my Calendar to Sheets and then Deleting back-logged events from the past two years. I believe the issue had to due with having to much data in the Google Calendar that it was exceeding the limit for "Google Quota" (maybe at least for the free version of Sheet2GCal?). Once I deleted some old events, I was able to upload new Calendar events no problem.

Thank you for the input and help. It got me on the right track.

GCalToolkit commented 8 months ago

Glad to hear you managed to sort it out, and please let me know if you run into any other issues!