Import JSON File from Gmail Attachment to CSV Spreadsheet

This n8n workflow streamlines the process of importing JSON data from email attachments into a spreadsheet format. It starts by retrieving the latest email from Gmail containing a JSON file attachment. The binary data from the attachment is then extracted and processed, finally being written out as a CSV file named 'users_spreadsheet.csv'. A sticky note provides a quick visual overview of the flow: 'JSON file > Sheets'.

The benefits are significant for teams handling data via email: it eliminates manual downloading, parsing, and uploading of JSON files into tools like Google Sheets or Excel, reducing errors and saving hours of repetitive work. Ideal for business operations where structured data arrives via email, such as expense reports, user lists, or transaction logs in JSON format.

Use cases include expense management (categorizing receipts sent as JSON), CRM data imports from vendors, or any scenario where email is the delivery method for tabular data. With just Gmail OAuth credentials needed, it's quick to set up and highly reliable for ongoing automation. Extend it by adding triggers like email labels or scheduling for batch processing.