About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • How Do I
  • Gmail email has multiple attachments but cant select right file to save to drive
Question

Gmail email has multiple attachments but cant select right file to save to drive

P

Hi All,

Hoping you can help as this has stumped me. I wish to move a email attachment of a csv from an email received which has multiple attachments to my Google Drive. The email usually contains one csv and at least one image.

I have setup a Gmail New Attachment Trigger and then added a Drive action. I have tried two scenarios.

  1. Action to replace existing file - This results in the following Error “'NoneType' object is not subscriptable”
  2. Action to add File - It picks up the Image file attached but not the CSV.

When i look at the “File” field enter specific data to select the CSV file their is no obvious details that refer to the CSV file alone only the PNG file.

 

The email definitely has both files attached as i can forward the email to another email address and download the files manually and access the data.

Does anyone have any ideas on what i can try next?

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

13 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @PJW99 

Good question.

Try adding a Filter as Step 2 in your Zap: https://zapier.com/apps/filter/help

The condition should be “Attachment Details Mime Type” contains ‘csv’

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P

Hi Troy,

Thanks for your help. Unfortunately the Mime Type of text/CSV is not selectable. I can only select the Attachment Details Mime Type for the png file. There is no available reference to the CSV in the format of “Attachment Details Mime Type text/csv”. It is selectable elsewhere as per the screenshot below but this results in the text “image/png,image/jpeg,image/jpeg,text/csv” being inserted into the final file.

Is there a way to filter the details Mime Type other than selecting it from the drop down?

Just to reiterate that the CSV file is definitely in the email.

 

Thanks

 

Pete

 

Troy Tessalone
Userlevel 7
Badge +14

@PJW99 

In your Filter step, try these conditions

“Attachment Details Mime Type” contains ‘csv’

 

Then turn the Zap ON and test, and check your Zap Runs: https://zapier.com/app/history/

If configured correctly only files with a Mime Type that has ‘csv’ will pass the Filter step.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P

Thanks for your patience,

I think I'm still missing something. I have applied the filter but the only “Attachment Details Mime Type” selectable contains the PNG and it wont let me enter freeform text. So the query says it wouldn't proceed past the filter point.

At this stage I'm not a paying user so cant turn on the Zap history on a 3 step Zap.

 

 

 

Troy Tessalone
Userlevel 7
Badge +14

@PJW99 

The left side argument in the Filter condition is dynamic for every Zap Run.

Turn the Zap ON, test, then check your Zap Runs: https://zapier.com/app/history/

Help article for changing your trigger test data: https://zapier.com/help/create/basics/change-the-test-data-in-your-zap-trigger

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P

Hi Troy,

I have tried multiple examples of the email as it is sent daily to me. All show the attachment in the email data as below but the CSV is not selectable within attachment details mime type only the PNG file.

 

Troy Tessalone
Userlevel 7
Badge +14

@PJW99 

You’re gonna have to trust me.

The left side argument in the Filter condition is dynamic for every Zap Run and is based on your current Zap trigger example.

Turn the Zap ON, test, then check your Zap Runs: https://zapier.com/app/history/

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P

Thanks Troy,

Understand its dynamic but Zapier in this case is not recognising all the attachments for every email i have been sent from this particular source. Will go back to source and ask for the email to be sent as text only with attachment and see if this solves the issue, as i suspect it will and will note the outcome here.

BTW, i have the exact same Zap working for another source email so think this is likely something to do with the way the email is coded and in turn Zapier not picking up all the attchments in the dynamic selections.

 

Troy Tessalone
Userlevel 7
Badge +14

@PJW99 

When the Zap triggers with Gmail New Attachment as the trigger event, then for each attachment on an email the Zap will run.

The Filter condition will evaluate the Mime Type and only pass when the Mime Type contains csv.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
P

@Troy Tessalone 

Yes, understood. The problem i have is that the dynamic filter condition of text/csv is not available, despite the file being attached to the email and trying multiple versions of the email. It is always a png file in this case. So if Zapier isnt able to pick the attachment up, i will need to either change the way the email is being sent to me or engage Zapier in solving the issue which i appreciate is unlikely.

 

 

Troy Tessalone
Userlevel 7
Badge +14

@PJW99

Zap triggers only pull thru up to 3 of the most recent examples.

In a previous screenshot it shows this:

That means there are 4 attachments on the email, with the CSV file being the 4th attachment, which is likely why you are not able to detect it as part of the example trigger test data.

 

Have you actually tried testing with the Zap turned ON and then check your Zap Runs to see how those processed?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
T
Userlevel 3
Badge +4

Hey @PJW99! I just wanted to check in and see if you were able to get your zap working correctly? 🤔 It seems like you and Troy were pretty close on figuring out a solution using the current setup from your email source instead of having to have information sent to you differently, which seems like it would be the most ideal! To build off of what Troy mentioned above, if the zap trigger only pulls up the 3 most recent examples, that could explain why your attachment might have been missing when you went to set it up as test data. Were you able to turn the zap on to test it?😊

P

Hi @TamRazzleDazzle 

Unfortunately i couldnt. It works when it is sent from another email provider but not from the original email address. Seems to have been an outlier case. I dont have a premium account so maybe it would work with that.

Terms & Conditions