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.

I’m trying to set up automated notifications to be sent to customers who’s orders have gone over a certain delivery time frame.

I have automated reports being sent by my courier as an Excel document. One of the columns contains the date an order was collected by the courier and another column contains the date it was delivered by the courier. If the parcel is still in transit then the delivered column is blanks.

I want to automate the following:

  1. Excel report is received into an email address.​​​​​​
  2. If the delivered column is blank and the pickup date is longer than 3 business days old
  3. Send email to customer advising of the delay using Klaviyo (or Shopify).

Does anyone think this is possible?

Hi @mwatsonnz 

Good question.

Can you provide a screenshot with the top few rows of the received XLS?

What app is sending the email notification with the XLS?

 

Wonder if there is a different way to approach this if you can get individual notifications.

If yes, then I’d recommend using an Airtable Base.

You can configure formulas to calculate the days delta between 2 dates.

Then you can use that to trigger automations.

 

Unfortunately i can’t get individual notifications. That would make this process so much easier!

My couriers are sending the XLS directly from their servers.

Screenshot showing the automated data i can receive. For reference i’ve removed some details for privacy reasons whilst posting in this forum.

The other key detail that is on this spreadsheet is the Shopify Order number which would be used on the other end to contact the correct person.

Key columns are I and J - These contain the pickup and delivery data.

 

@mwatsonnz 

You may want to try something similar to this workaround.

 

Upload the XLS file to GDrive.

Then get the CSV version of the XLS.

Then you can use the Formatter > Utilities > Import CSV.

Then you can use the Looping app to find/create + update the records in Airtable.

 

Configure Airtable to trigger Zaps based on the desired filter logic.

Thanks Troy,

I’ll have a crack now!

Hi there, @mwatsonnz! 

Were you able to get this working using the workaround Troy suggested? Keen to make sure you’re all set here! 🙂

Terms & Conditions