Skip to main content
Best answer

Zap will find and attach the proper file to a Mailgun email only once, then wrong ever after

  • Feb 23, 2024 5:16 PM UTC
  • 9 replies
  • 173 views

Forum|alt.badge.img

I set-up a zap to read customer data in an Excel file, then send them an email with an attachment via Mailgun. The attachments are all stored in a single folder on OneDrive, which Zapier is able to locate. The first email that the Zap sends pulls the correct attachemnt according to the name of the file listed in a row in Excel. However, every subsequent email (pulling data from the next cell along with the next file name) it pulls and sends the wrong attachment, and it is the same wrong attachment everytime (i.e. same file is pulled and sent). Is this a bug in Zapier? Why won’t Zapier find the 2nd, 3rd, file etc. and send them as it did the first time? I’ve checked my Excel file over and over, and it is pulling the proper file name everytime, it just doesn’t attach the file associated with that name. In the attachment step in Mailgun, I select “File: (Exists but not shown).” The Zap works perfectly up to this last step of finding/attaching the wrong file from OneDrive, and the order of the files in the folder doesn’t affect this outcome. Any ideas?

Best answer by cbsmith82

The problem ended up being with the naming convention of the files themselves. Appearantly, Zapier does not like “-” or “_” or “2_13_24” in the name of a file. Thanks for your replies on this.

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Feb 23, 2024 5:26 PM UTC

Hi @cbsmith82 

For us to have full context, post screenshots with how your steps are outlined and configured, thanks.


Forum|alt.badge.img
  • Author
  • Beginner
  • Feb 23, 2024 6:48 PM UTC

Sure; and thank you.

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Feb 23, 2024 7:06 PM UTC

@cbsmith82 

The screenshot for step four does not show how the step is configured for the lookup fields, which we would need to see for more context.

 


Forum|alt.badge.img
  • Author
  • Beginner
  • Feb 23, 2024 9:07 PM UTC

Here you go:

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Feb 24, 2024 12:17 AM UTC

@cbsmith82 

To hep you troubleshoot check your Zap Runs history to see the DATA IN/OUT for each step: https://zapier.com/app/history/

 

Wonder if the issue is related to how your Excel spreadsheet is configured.

Help articles for using Excel ins Zaps: https://zapier.com/apps/excel/help


Forum|alt.badge.img
  • Author
  • Beginner
  • Feb 27, 2024 12:16 AM UTC

Thanks Troy; we will continue to dig into it.


Forum|alt.badge.img
  • Author
  • Beginner
  • Answer
  • Feb 29, 2024 9:35 PM UTC

The problem ended up being with the naming convention of the files themselves. Appearantly, Zapier does not like “-” or “_” or “2_13_24” in the name of a file. Thanks for your replies on this.


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Mar 1, 2024 6:39 AM UTC

That’s great news @cbsmith82! We’re glad to hear you were able to get it sorted!

Also, big thanks to Troy for lending a hand here!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗


Forum|alt.badge.img
  • Author
  • Beginner
  • Mar 1, 2024 4:04 PM UTC

Thank you @ken.a  and @Troy Tessalone!