Skip to main content

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! 

 

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


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? 


@Lily P 

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


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? 

 


@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”.