Sync Google Sheets with Google Cal. via cell note data input
62 views
Skip to first unread message
Simon M
Apr 29, 2021, 9:09:15 AM4/29/21
to Google Apps Script Community
Hi,
Forgive me if this is rather unusual but I need the following to work:
In Google Sheets, I want a script to recognize data within any particular cell note and sync to Google Calendar. All the sync options between the two require additional cells. I would rather want to keep it simple, and input the required data straight to the specific cell.
Is this hypothetically possible with script?
Of course I imagine this might be too rigorous for simple script.
If that‘s the case, is there any add-on that can do something similar to this?
I imagine the cell note might simply require few keywords as so it is easy to input the basic data into each cell that can afterwards get recognized by the script. All I need to transfer to Google Cal. is the particular date, name of the event [ each all-day ] and event note.
Thank you
Alan Wells
Apr 29, 2021, 10:16:58 AM4/29/21
to Google Apps Script Community
You need to trigger the code to run.
That can be done when a Sheet cell is edited, with an installable On Edit trigger.
Or you could run code from a button, or sidebar, or custom menu, and the code could evaluate multiple cells in the same run instance.
Existing Cal. events can be updated either with the built-in CalendarApp service or the Google Calendar API.
So, it's possible to sync from the Sheet to the Calendar event.
The most difficult part might be finding the correct Cal. event that the cell should match to.
You can search by date and time, but it might be better to get an event by the event ID.
You'd need to store the event ID in the cell note when the event is first created.
I searched the Marketplace for add-ons and found:
But don't try to install them from the link given.
From your Sheet click Add-ons, get add-ons, and search for the add-on by name and install it from there.
The G Calendar Sync add-on is higher rated, and the other one might charge something.
And the G Calendar Sync add-on looks like it's open source at:
If you find out anything about those add-ons I'd be interested to know what your impression is of them.
Here's a YouTube video that looks good.
Reply all
Reply to author
Forward
0 new messages