What I am trying to accomplish:
I am a student and my course assignments for classes are provided via a PDF file, I want to automate a system to search through these "Course Assignment Sheets" as they are called at my school and input the assignments with the correct date and the corresponding assignment description into all-day events in my google calendar. I will attach an image below of the Course Assignment Sheet for reference, there are two primary columns within it, one for the date and the other for the assignment description. Moving top to bottom through the Course assignment sheet the date on the left corresponds directly to the assignment description on the right. I want a zap that can automate finding this and then input the assignments with the proper date and description into all-day events inside my google calendar. I would like it to search for the PDF files/ look through them from my Google Drive if possible.
I am very new to Zapier and even after multiple tutorials both in and outside the Zapier website I have been unable to figure out how to set this up. It seem what I’m trying to do is a bit more complicated than what the tutorials show so I don’t know how to go about doing it, any help would be much appreciated!
Here are the Course assignment Sheets for reference to have a better idea of what they look like:
