Export Local JSON Data to Google Sheets - n8n Workflow

• System Administrators who need to push locally generated configuration or user data to cloud spreadsheets.


• Developers creating data pipelines that start with local file exports and need a reliable n8n workflow.


• Users looking for practical n8n templates for file handling and spreadsheet integration.


• Anyone who needs to leverage the Google Sheets n8n node for batch data imports.

This powerful n8n workflow solves the common challenge of moving structured data from a local file system into a cloud-based spreadsheet for analysis and sharing. By utilizing the readBinaryFile n8n node, the automation securely accesses a specified local JSON file. It then efficiently parses and exports this data directly into Google Sheets. This automation is a foundational example of a core logic n8n workflow, providing a reliable backbone for daily data transfer tasks. Utilizing this robust n8n template saves significant time compared to manual uploads and ensures data consistency every time the n8n trigger is executed.

This automation operates in three distinct phases, initiated manually or via a preceding n8n trigger:

1. File Reading: The read json file n8n node initiates the process by targeting the specific local path (/username/users_spreadsheet.json). It reads the file contents into memory, ready for processing.


2. Data Preparation: The move binary data 2 n8n node handles the essential conversion and preparation. It ensures the binary JSON data is correctly structured into individual n8n items, making the output suitable for spreadsheet appending.


3. Sheet Writing: The final step is executed by the Google Sheets1 n8n node. It connects using secure OAuth2 credentials and performs the append operation. The structured data is written as new rows to the designated Google Sheet ID. This complete n8n workflow provides seamless local-to-cloud data synchronization using optimized n8n nodes.

1. Import the n8n workflow: Copy the provided JSON code and import it directly into your n8n instance.


2. Set Local File Path: In the read json file n8n node, update the 'File Path' parameter (/username/users_spreadsheet.json) to the correct absolute path where your JSON file resides on the n8n host system.


3. Configure Google Sheets: Open the Google Sheets1 n8n node and create or select your Google Sheets OAuth2 credential.


4. Specify Sheet Target: Update the 'Spreadsheet ID' (currently set to qwertz) to the ID of your target Google Sheet, and ensure the data structure matches the expected columns (A:C) for a successful append operation.


5. Execution: Save the n8n workflow and execute it manually to test the file reading and data writing process.

read json file (readBinaryFile n8n node)
Function: Reads the local JSON file from the specified path, loading the data into the n8n workflow context.
Key Configuration: File Path set to /username/users_spreadsheet.json.
move binary data 2 (moveBinaryData n8n node)
Function: A utility n8n node that ensures the binary file content is correctly converted and structured into usable data items for subsequent nodes.
Key Configuration: Default settings used for seamless data transition.
Google Sheets1 (Google Sheets n8n node)
Function: Connects to Google Sheets via OAuth2 and appends the processed data as new rows.
* Key Configuration: Operation set to Append. Range specified as A:C. Requires OAuth2 credentials and the target Spreadsheet ID to be configured. The node ensures the processed data is mapped to the sheet columns (using usePathForKeyRow).