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.

3 Likes
Mass upload events through a CSV spreadsheet
Allow users to add events to the calendar
Mass upload events through a CSV spreadsheet
Mass upload events through a CSV spreadsheet
Mass upload events through a CSV spreadsheet
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!

1 Like
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.

1 Like
Mass upload events through a CSV spreadsheet
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:

1 Like
8

2 posts were split to a new topic: Where to find the template csv file to import events