Posts

Showing posts with the label Google Calendar

How to link schedules to Google Calendar with Google Spreadsheets

Image
I tend to use Google products a lot. My main calendar is also Google Calendar. As I became an executive of the group this time, I had to register my members' birthdays on the calendar. While I was just registering one by one, "What am I doing right now?" I'm starting to feel that kind of shame. The thought of registering the date information (birthday) on the Google sheet at once easily crossed my mind. So I looked it up and... I think it'll be possible if I write a little macro program. So I worked hard to develop it. It took 8 hours to register in an hour, so I made a program. As a result, it was more inefficient. crying But... It was inefficient for me, but I think it could be of great help to others if I disclose this code, so I'm going to reveal the code. Supplies All you need is a Google spreadsheet and a Google calendar. Of course, it's free. Google Calendar First, create a Google Calendar or prepare the calendar you are using. ... on the...