Hello everyone, a pleasure to greet you. My name is EJ, and I've been using Zapier in my growth marketing agency for a few weeks now. I currently want to make a series of integrations between Hubspot CRM and Zapier to more efficiently manage my customer base and monthly recurring subscriptions. 

The idea is to track a custom company property (expiration date) to analyze daily if there is a company in the CRM that has an expired service expiration date (comparing it with the current date) in order to perform several actions:

1. change the company field in CRM (lead status) from green emoji (would indicate that the service is active) to red emoji (indicates that the customer has not renewed yet). 
2. Send a series of internal and external alerts with Asana, Google Calendar, that indicate me those customers that have expired dates to send follow ups, internal reminders, etc. 

I can not link in “Find a Company in hubspot” the custom property expiration date and its value. To tell Zapier to extract all the companies with expiration dates and apply the conditional filter. 

Attached is the workflow I have created. 

Thank you all for the support :)