I am trying to create a workflow to import a CSV file through zapier, however, the CSV data will be coming from multiple emails which means different CSV links that I will not have until they get emailed in & even then the links will be different each time. Trying to stay away from any manual work or manually updating one CSV file each time.
Any advice/tips will be greatly appreciated!
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
@Troy Tessalone Gmail can be used, I was also thinking of using parser by zapier to set up multiple emails to distinguish the different sources however I do not think the parser can transfer the csv files. I will just need to be able to separate the multiple sources sending in these emails.
To get attachments from Mailparser, you need to create a new parsing rule in the account which returns the meta data of the attachments. This gives the Zap the URL to where the attachment is located on their server which you can then find on the Zap!
@Troy Tessalone Ok so if I am using gmail, can different sources send me csv reports attached via email, go through zapier to then upload to another connected app? The csv url will be different each time as it will be from a weekly auto-generated report.
@Troy Tessalone Okay that makes sense. I will be uploading it to QuickBase. I have done this before but not with attachments, just regular text. I am trying to send the actual text data from the csv file to upload into an existing table in Quickbase. However I wonder how the data text will be separated or if it can be distinguished to be able to assign the rows to different fields.
To clarify, it will be a file object from the email attachment, not a link.
Yes, you will need to map (using the ‘CUSTOM’ option) the file object (aka CSV attachment) from the GmailNewAttachment trigger step to the Formatter > Utilities > Import CSV File action step.
+14
