Skip to main content

I’m using Email Parser by Zapier to push information into a Google Sheet and it’s working great except all the attachments are zipped into a file together. The email actually only has 1 attachment (a .png photo) but all the little icons and other small things are being zipper together into a .zip folder. How can I have just the main attachment separated out and a URL to that, rather than everything in a .zip folder? Thank you!!

Hi @opszaps 

Good question.

You may have to use a workaround.

Dropbox has automated folders.

You can configure a Dropbox automated folder to unzip files.

https://help.dropbox.com/organize/dropbox-automations


Hi @opszaps 

Good question.

You may have to use a workaround.

Dropbox has automated folders.

You can configure a Dropbox automated folder to unzip files.

https://help.dropbox.com/organize/dropbox-automations

 

How would this work exactly? I’m looking for all emails within a particular filter in a particular gmail inbox to parse into a GoogleSheet and one of the columns to be a URL to the image attachment. How would I use dropbox automations for that? Thanks for your help!


Hi @opszaps

I did some checking and it looks like Email Parser only returns email attachments as zip files. There’s an existing feature request for to have email attachments supplied individually rather than as a zip file, so I’ve added your vote to that. I can’t make any promises as to when it will be added but we’ll send you an email notification as soon as it is!

I think Troy was suggesting that you could use Dropbox to unzip the files. Then, in theory you could set up another Zap that triggers on the new files (that were unzipped) and then search for the relevant row in Google Sheets to then add a link to the image file on Dropbox. You’d need to have someway of identifying the correct row based on the name of the file though, so that may not be possible since you’re not naming the files that are then unzipped.

In the meantime, it might be possible to use a different email parsing app to get the attachments supplied to the Zap individually rather than zipped. I’ve not tested it myself but I believe Mailparser would be able to do it.

That said, I’m not sure whether Email Parser also zips singular file attachments. If it doesn’t, then perhaps you could create another Zap that uses the New Attachment (Gmail) trigger to send the email message and single email attachment to Email Parser? The New Attachment trigger would trigger on each attachment individually, so you could set up a filter in the Zap to make sure it only runs for certain kinds of attachments. Then in your Email Parser Zap it would receive a single attachment instead of a zip file (assuming it won’t zip a singular attachment). 

Hope that helps. If you do manage to get it working any of the above suggestions, or find a different solution, please do let us know! 🙂


@opszaps 

Another option is to use a different email parser app such as Mailparser: https://zapier.com/apps/mailparser/integrations

 

https://mailparser.io/