• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

Parsing the file extension for a Gmail to Dropbox automation

In Gmail, I have a filter set up that automatically forwards emails with a specific subject line to Pabbly's email parser.

In Pabbly Connect, I use the email parser as a trigger to then save the email's attachments to a specific Dropbox folder. And since each email has two attachments, I repeat the step (shown below) to first find the Attachment Links 0 and then Attachment Links 1.

Since the attachments all use the same name (sales report.xls and sales report.pdf) each month, I opted to use the subject line of the email as the filename since that's specific each month.

But somehow, I need Pabbly to recognize the file extension of the attachment and retain that. So, while it needs to note if the file is an Excel file or PDF, I want it to apply the subject as the filename.

Is that possible to do?

Here's my original attempt. This version stores the file in the DropBox, but because of the colon in the filename, it only appears in the online version of DropBox. My Windows application can't show it because of the special character. So I have to rename it in the browser version for it to appear on my computer.

1671467468875.png


To get the file extension to be retained, I tried appending an underscore and the Attachment Links 0 to the filename.

1671468166631.png


But that gives me a malformed path error when I test it.

1671468197570.png


I have not made any changes to the path, which worked fine when I first started working on this last week.

I'd appreciate any help I can get in trying to set this up successfully. Please note that I'm coming from Zapier to Pabbly and finding the learning curve to be very challenging. So, if you could be very specific in your suggestions, I'd appreciate it.

All the best,
Tara
 

Supreme

Well-known member
Staff member
Hey @emeraldlake

The attachment URL that you are supplying to DropBox's API in the file name field looks to contain some special characters, which is why the file is not being accepted for upload by DropBox's API.

Please enter the limited characters and refrain from entering the URL in the file name area.

1671518909915.png
 
Great! Thank you. I have that working now.

A couple more questions, when my Gmail filter forwards the email to Pabbly's email parser, do you know if it will include "Fwd:" in the subject line? If it will, I need to know how to strip that out of the filename since Windows can't handle the semicolon in a filename.

Also, sometimes, this email will have two attachments, and other times, it will have three. Is there a way to tell Pabbly to repeat (and increment) the process until all the attachments are processed? Right now, I've just duplicated the Split Text and Upload File steps for the second attachment. But if I do that a third time and there is no third attachment, what will happen when Pabbly tries to execute this workflow?
 

Supreme

Well-known member
Staff member
A couple more questions, when my Gmail filter forwards the email to Pabbly's email parser, do you know if it will include "Fwd:" in the subject line? If it will, I need to know how to strip that out of the filename since Windows can't handle the semicolon in a filename.
You can refer to the following screenshot to parse the Fwd: from your email subject.

1671690348606.png


Also, sometimes, this email will have two attachments, and other times, it will have three. Is there a way to tell Pabbly to repeat (and increment) the process until all the attachments are processed? Right now, I've just duplicated the Split Text and Upload File steps for the second attachment. But if I do that a third time and there is no third attachment, what will happen when Pabbly tries to execute this workflow?
Regarding that, you can use the first capture of the webhook response again but in the advanced response by toggling the "Simple Response" button and then you can process that attachment field data in the Iterator action step which will process your attachment in your DropBox one by one.

 
Top