You might find yourself needing to extract a file that is within an existing Zap of yours but can’t currently get access to this information. This is where the Formatter transform comes in, you can use it to import your CSV file so that you can use the data in the rest of your Zap.
We can use either a file object or a public URL that points to your CSV file in order to get your data.
You’re sent a CSV file from a client via an email, but you need this data into an existing spreadsheet that you have in Google Sheet. In using this workaround, you can make sure this data gets added without having to manually put this data in yourself.
Our Import CSV File only supports ASCII and UTF-8 encoding today. You'll need to re-encode your CSV in order to import it into your Zap.