How to bulk upload Google calendar entries
Now we have our images, the next step is to create the Google Calendar entries. We could do this by hand – but the chance of making a mistake is high so I prefer to spend time automating it. The idea here is to fool Google Calendar into accepting a CSV file which it thinks has been exported from Outlook. Instead, we have hand crafted it in Excel. This spreadsheet should make life easier for you:
Basically you fill in the boxes on the first sheet.
Switch to the second sheet and it is already filled out, ready for you to export as a CSV file. Don’t worry that there are empty rows towards the bottom of the sheet (it will create up to 366 calendar entries – enough for a full year countdown), or that there are some numbers in column A (used as part of the functions to fill the fields). Google Calendar seems to just ignore any data it doesn’t understand.
You will need to select “CSV” from the “Save file as type” dropdown menu.
During the save you will be prompted by two warning boxes. One tells you that CSV files can only contain one sheet (click “OK”), and the other talks about features that are not compatible with CSV format (Click “Yes”).
Now you need to import your CSV File to Google Calendar. I’ll assume you already have a Google calendar set up.
The first thing to do is to turn off default reminders. This is because you don’t want an email or text message at midnight each night to tell you that the profile image is changing! I have bolded it because Google Calendar won’t allow you to reimport the same appointment twice, so you need to get it right first time!
In Google Calendar, select “settings”
and then remove the default reminder settings:
Save your change and go back to the calendar. It is now time to import the CSV file. Select “Other calendars –> Import calendar”.
Now choose the CSV file you saved earlier.
and hey presto – 180 calendar entries (well 181 – because of the “Slide0” one) ready and waiting to be picked up by IFTTT.
Next page: How to tie it all together with IFTTT…