Push JSON Data to an App or Spreadsheet File

This n8n workflow demonstrates how to manually trigger a process to take JSON data, transform it, and then either push it to an external application via an HTTP request or save it as a spreadsheet file (e.g., CSV, Excel) in Google Sheets.

What it does

This workflow simplifies the process of handling JSON data by providing two distinct output paths:

1. Manual Trigger: The workflow is initiated manually.
2. Edit Fields (Set): Placeholder for where you would input or transform your JSON data. This node is designed to hold the data you intend to process.
3. HTTP Request (Optional): If you want to send your JSON data to an external application or API, this path allows you to configure an HTTP request (e.g., POST, PUT) with your transformed data.
4. Spreadsheet File (Optional): If you prefer to save your data as a file, this path converts the JSON data into a spreadsheet format (like CSV or Excel) and prepares it for output.
5. Google Sheets (Optional): This node is intended to take the spreadsheet file data and write it to a Google Sheet.

Prerequisites/Requirements

• n8n Instance: A running n8n instance to import and execute the workflow.
• Google Account: Required if you intend to use the "Google Sheets" node. You'll need to configure Google Sheets credentials in n8n.
• Target Application/API: If using the "HTTP Request" node, you'll need the endpoint URL and any necessary authentication details for your target application or API.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Data Input:
   • Open the "Edit Fields (Set)" node.
   • Replace the placeholder data with the actual JSON data you wish to process. You can manually enter data or connect this node to a preceding node that generates JSON output.
3. Choose Output Path:
   • To send data to an app (HTTP Request):
     • Enable and configure the "HTTP Request" node.
     • Set the URL, Method (e.g., POST), and Body Parameters according to your target API's documentation.
     • Add any required Headers or Authentication.
   • To save data to Google Sheets:
     • Enable and configure the "Spreadsheet File" node to convert your JSON data into the desired spreadsheet format (e.g., CSV, XLSX).
     • Enable and configure the "Google Sheets" node.
     • Select your Google Sheets Credential.
     • Specify the Spreadsheet ID and Sheet Name where you want to write the data.
     • Choose the Operation (e.g., Append Row, Update Row).
4. Execute the Workflow: Click the "Execute Workflow" button on the "Manual Trigger" node to run the workflow. You can also test individual nodes by clicking "Execute Node".