About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

How do I handle empty PDFs and send emails in Zapier?

  • 12 December 2023
  • 5 replies
  • 32 views
L
Userlevel 1

Hi everyone! 

I receive PDF impact reports into my inbox which is a trigger for my Zap. However some of these impact reports will have data and some of these impact reports won’t have data, depending on the performance of the client that month. Please see the two examples below. 

 

Ideally, for the reports that do have data, I would love to upload these to my google drive (which I already know how to do). However, for the reports that don’t have data I would like to send an email to the client letting them know that there was no activity for the month. I know that Zapier paths will need to be used - but is there any tool or function in Zapier that will allow me to identify if the PDF report is empty or contains data? 

e.g. if sites donating is 0 then send an email to the client. If sites donating is greater than 0 then upload. However, this information will be in a PDF as I need to upload the PDF reports to google drive. 

 

Thanks so much and really looking forward to your responses! 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Lily P 

You can search Zap apps here: https://zapier.com/apps

Each app has a profile page that lists the available Zap triggers/actions.

Check out apps in the Documents category: https://zapier.com/apps/categories/documents

e.g. PDF.co: https://zapier.com/apps/pdfco/integrations#triggers-and-actions

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
L
Userlevel 1

Thanks @Troy Tessalone. Do you know if it is possible for the Zapier filter integration to filter out reports based on the numerical data in the PDF? 

Troy Tessalone
Userlevel 7
Badge +14

@Lily P 

You would first have to parse the PDF before you can filter on the extracted data.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
L
Userlevel 1

Hey team, I’ve parsed the PDF however I’ve received the below error when I’ve attempted to filter the PDF by the email attachment containing numbers greater than 0. Do you have any suggestions on how to go about filtering the PDF attachment so that any reports that have no data (e.g. 0 sites donating) are filtered out? 

 

Troy Tessalone
Userlevel 7
Badge +14

@Lily P 

The Filter won’t pass because you are comparing an Email attachment, which is a file object, to a number, which is a different data type.

Try changing the Filter middle operator to “exists”.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions