Sync events to Google sheet

Wishlist Event Calendar
1

It would be amazing if there was a way to sync the calendar to a google sheet, so that when new events are added to the sheet, they are automatically added to the calendar. I envision this being similar to the way spreadsimple works. The spreadsheet would contain columns for each input in the ‘add event’ function in elfsight, and would automatically sync them at regular intervals.

2

Folks, our former Wishlist portal, where our users shared their requests and suggestions, was transferred to this forum. You’re most welcome to vote, add new ideas, and leave your comments here — we surely will consider them all! :star_struck:

Original Votes: 5

3

Hello there,

Thank you for adding your idea!

It sounds really nice to be able to sync the calendar to your Google Sheets with further auto-updates. We’ll try to think in this direction in one of our future updates :slight_smile:

Thanks a lot for helping us!

4

Original comment from Marion Catlin transferred from the previous Wishlist portal:

5

Original comment from Katja Jaqueline transferred from the previous Wishlist portal:

6

I would like to request a Google Sheets integration that allows for incremental syncing rather than a full overwrite.

The Current Problem: As I understand it, uploading a file currently replaces or deletes existing events in the widget. This is risky as we lose data if the file isn’t perfect.

The Proposed Solution: A direct sync with a Google Sheet (where columns match the widget’s ‘Add Event’ inputs) that updates automatically at intervals or via a manual “Sync” button.

Desired Logic:

  • New Rows: Automatically create new events in the calendar.

  • Modified Rows: Update the specific details of existing events without removing the event itself.

  • Moved Rows: If a row is moved in the sheet, the widget should recognize it is the same event and not duplicate or delete it.

Suggestion: Could this be handled via a Unique ID column in the spreadsheet? This way, the system tracks the specific Event ID rather than the row number, preventing confusion, overlaps, or data loss.

7

Hi there, @Bianca_Grisolia :waving_hand:

Thanks a bunch for the feedback!

We already have a request for this feature. I’ve merged your comment with the existing request, where we’ll keep you updated :slightly_smiling_face:

9

This would be a game changer and @Max has provided a temporary fix Event Calendar: How to Collect and Approve Event Submissions via Form Builder , but being able to sync directly with Google Sheets would allow a true community event feature and enhance this product for Main Street Programs and Libraries. Elfsight is already highly recommended in this industry for the ease, but this feature would increase value. This feature would allow community organizations to whitelist organizations and use other automations to import Library, Visitor Center, and known css sources directly to Google Sheet that is then uploaded to Event Calendar.

10

Thank you so much for the feedback, @Connect_Downtown_Joh!

I totally agree that a built-in Google Sheets integration is much handier option comparing to the workaround you’ve mentioned. We’ll keep this idea in mind and if it gets more traction, we might think it over in the future updates :slightly_smiling_face: