A Free Google Calendar Tool to Meet your Workflow Deadlines
I am a serial procrastinator, I will do it tomorrow is a common theme. However my goal this year is to meet my deadlines! Nothing is more unprofessional than missing a deadline for a client. With Google Calendar and a simple Excel / Google spreadsheet file I am able to schedule a multi-deadline schedule in a few clicks.
Google calendar has the ability to import calendar entries via a CSV file (which is a spreadsheet). With some simple excel formulas I have created a template that will add a calendar reminder for each step in my workflow and help me meet my deadlines. After I enter the Bride and Groom’s name and the wedding date the excel formulas fills out the remaining dates and creates my timeline. The dates are created off a -/+ date range from the wedding date (which acts as the anchor point), I have this -/+ date in the description field.
Once the formulas are calculated I save the excel sheet (or google doc) as a CSV file for uploading. Open your Google calendar and navigate to the gear on the top right and then settings.
Once here click on calendars and then import calendar.
Select the CSV file for uploading and the correct calendar to add the events to.
Once imported you will get a message that confirms upload or tells you the events have already been created.
All the events have been uploaded and added to your calendar. Now time to do some work!
Feel free to edit the formulas and text to match your workflow. My Formulas are located in the cells in Columns A,B, and H. You can also delete all the formulas and just do a mass dump of dates on your Google Calendar.