Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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: 

 

Hello there @ICY, welcome to the Community! 🎉 

You might need to look at using an app like Docparser to extract the data from the PDF on Google Drive. From there you could use the information it extracts from the PDF to create the events in Google Calendar.

Not sure if Docparser would output the information from the different table rows as line items. But if it does then you need want to use a Looping by Zapier action to run through the data in each line item and add it as a new event in Google Calendar. You can find out more about using loops here: Loop your Zap actions

Do you think that approach could work?

If I've misunderstood what you're looking to do or you run into any issues in setting this up just let us know. Always happy to help further!

Terms & Conditions