This workflow demonstrates the conversion of a CSV file to Excel format. First, an example CSV file is downloaded via a direct link. The source file is taken from the European Open Data Portal: https://data.europa.eu/data/datasets/veranstaltungsplaetze-potsdam-potsdam?locale=en The binary data is then imported via the Spreadsheet File node and converted to Excel format. N.B. Note that as of version 1.23.0 n8n, the Spreadsheet File node has been redesigned and is now called Convert to File node.
Tags
Related workflows
See all General Automation→Listen on new emails on a IMAP mailbox
Listen on new emails on a given IMAP mailbox. Converts the binary XML attachment to a stringified xmlproperty on the $data object and converts it to JSON. The Setnode could be replaced with Function nodes for example to do a conversion/mapping/transformation. The JSON is ultimately sent to a HTTP Endpoint via POST. This could be a starter for EDI purposes like receiving or transmitting XML data and conversion via JSON object property mapping.
Extract post titles from a blog
This workflow uses n8n to extract the names of all the posts from the Hackernoon homepage.
Create a new DigitalOcean Droplet
Uses a DigitalOcean Personal Access Token to create a new Droplet. Add your personal access token and change the parameters to create droplets of different sizes. You can also specify more options; refer the API docs