Sheets2GCal is a Google Sheets add-on with over 85,000 users, written and maintained by Neil Gerstenberg, Platinum Product Expert for Google and the developer of desktop software GCalToolkit and the free Chrome Extension GCalPlus which has over 20,000 users.
Based in the South of France working as a professional musician playing jazz and traditional music in pubs, clubs and festivals across Europe, Gerstenberg started working in his spare time with the Google Calendar API when it was first released to help Palm users migrate data from the discontinued Palm Desktop software to Google Calendar. It became clear that many users were unhappy with the limited search and lack of bulk editing capabilities of Google Calendar, so he wrote GCalToolkit which has grown over the last 10 years to become the leading Google Calendar management software for individuals and businesses who need advanced search, sorting, filtering, de-duplication, and mass-editing of events.
A regular contributor to the Google Calendar Community Support Forums, Gerstenberg realized that many people prefer to manage their events in familiar spreadsheet software, often using CSV to import their data to Google Calendar. However, the CSV format is very limited with no support for repeat events, timezones or Meets/Hangouts. Existing solutions for linking Google Sheets and Google Calendar were outdated and lacking many essential features, and Sheets2GCal was born!