Convert JSON File to Google Sheets Rows

This workflow automates the conversion of JSON data from a file into structured rows in a Google Sheet. It starts by reading a binary JSON file from a specified local path (e.g., /username/users_spreadsheet.json), processes the binary data to make it usable, and then appends the extracted data to a designated Google Sheet in range A:C using OAuth2 authentication.

Ideal for quick data migrations, this simple yet effective automation saves time on manual copy-pasting or scripting. It handles JSON arrays seamlessly, converting them into tabular format suitable for analysis or reporting.

Use cases include importing user lists, student records, or any JSON-exported datasets into Google Sheets for universities or educational teams. Benefits include error-free data transfer, scalability for batch processing, and easy integration into larger n8n workflows for ongoing automation.