Hi @twerb,
Welcome to the Community.
To automate the extraction and updating of financial data from PDFs stored in Dropbox to HubSpot, first set up a Zapier trigger that detects new files in a designated Dropbox folder, including subfolders. Then, an OCR service such as Google Cloud Vision can process the PDFs and extract specific fields like "Net Income." Ensure the OCR tool is configured correctly for accurate field recognition. Next, establish an action in HubSpot to search for the corresponding company record based on a unique identifier, such as a company name or ID. Once located, update the relevant HubSpot property with the extracted data. Attention to detail ensures OCR accuracy, correct data mapping, and consistency between the extracted fields and HubSpot properties. Before fully deploying the automation, test the workflow with sample PDFs to confirm proper data extraction and classification in HubSpot. Consider potential limitations in Zapier's integration capabilities, OCR accuracy, and HubSpot's API constraints. If challenges arise, consulting the Dropbox or HubSpot support teams may provide additional solutions or improvements.
I hope this helps you set up your workflow successfully! Feel free to ask if you have further questions or need additional support.
Hey @twerb, just checking in—did Jammer’s reply help to point you in the right direction?
Let us know if you still need any help, keen to make sure you’ve got everything you need! 