I have a purchases folder in Dropbox which has sub-folders by vendor names where I have the pdfs for purchase orders. So the path is Dropbox>Main folder>Vendor folder>pdfs, where the pdfs are sorted by date in the Vendor folder.
The pdf names are in the following format: DATE_VENDOR_PO# number.pdf
For example: 20230630_ABC_PO# 2789.pdf
My sheet has a DATE column, a VENDOR name column and a column with the PO# numbers.
My goal is to be able to attach pdfs of PO# files that exist on my Dropbox folders to each of the relevant cells in Smartsheet. The data is worth 6 years (a lot!).
I also want to be able to automate this process from now onwards. So whenever I add a pdf file to this folder my Smartsheets sheet will automatically be updated.
How can I use Zapier to achieve these two things?
