Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Hi,

We have a CRM which creates a new Excel spreadsheet on the 1st day of every month into a specific directory on BOX. It’s just a list of internal company contacts on a single sheet, but the CRM doesn’t delete the previous version, it simply adds a long random string to the end of the filename, so we end up with a growing collection:

Adviser_List_vlkrcjhvgnshrnl.xlsx
Adviser_List_fgvbnhjdsmmh.xlsx
Adviser_List_gjfngjfgybdvgd.xlsx
…. and so on

My question is, how can I get Zapier to identify the newest Excel file in there, and grab a link to that file, so I can send it out to our member list on Mailchimp? I would trigger the zap to do this once a month.

I have no trouble creating the email part, and I can get Zapier to read the folder, I just don’t know how to target the newest excel file?

Any help would be greatly appreciated.

Mike

Hi @mikenco , 

 

If you have a folder specifically for this excel file, I would then use a Trigger > Box > New File then you can specify the Folder where those files are created. This way Zapier will trigger once the file is sent to Box. 

 

Let me know if this works for you. 

 

Hi,

Thanks for the input, but that is too simplistic, I just noticed that I failed to mention that the CRM automation also adds three logos to the folder with the Excel file for some bizarre reason. I added a filter to find “any new file with a size above 60kB” which then ignores the .png files, but it feels a bit like a hack, because if the CRM one day uploads a new larger logo, it will trigger the email campaign.

It’s frustrating that there doesn’t seem to be a way to specify “file type” in the filter. BOX only sees everything as either a “file” or a “folder”. 

M.

Can you please show me the test results of the trigger? 

Can you please show me the test results of the trigger? 

Can you be more specific?

I mean when you create the trigger and you click on the Test Trigger button it gets a bunch of data. What is the current trigger? New File in Box? I wanna see if for example one of the fields it retrieves is the file type, or if the file name has the extension. If so, you can then create a filter to include/exclude certain file types

Hi @mikenco 

 

Any updates on your issue? Please keep us posted :) 

Terms & Conditions