How can I insert a JSON datatable as multiple rows in Google Sheets using n8n?

Below is a recommended approach using native n8n nodes:

1. Convert the JSON Array to Individual Items

n8n’s Google Sheets node appends data row by row. To insert a table (i.e. multiple rows) you need to split your JSON data into separate items. You can do this by using the Split Out node. This node takes an array field from your JSON and creates an individual item for every element.

2. Map Fields to Match Your Google Sheet Columns

Each resulting item from the Split Out node should have keys that correspond exactly to the column headers in your Google Sheet. If needed, use an Edit Fields node or a Set node to ensure the field names match.

3. Use the Google Sheets Node to Append Rows

Once you have individual rows, add a Google Sheets node configured with the Append Row operation:

• Set Resource to Sheet Within Document.
• Choose the correct Document and Sheet.
• For Mapping Column Mode, you can choose:
  • Map Each Column Manually so you can specify exactly which field goes to which column, or
  • Map Automatically if your keys exactly match the column names.

Each item output by the Split Out node will trigger an append operation for one row.

Troubleshooting Tips

• No Output: If testing the node shows no results, double-check that your JSON data is actually an array and that the field you’re splitting on (for instance, data or similar) really contains the row objects.
• Mapping Errors: Ensure that the keys of each JSON item exactly match the headers in your Google Sheet. Otherwise, the appended row might not work as expected.
• Looping Alternative: Although using a loop (i.e. iterating over rows) is essentially what the Split Out node does, ensure you’re not including an extra intermediate step that might drop your output.

Workflow Summary

1. Input Node – Your incoming JSON datatable.
2. Split Out Node – Converts the JSON array into individual items.
3. Edit Fields / Set Node (Optional) – Adjust the field names if needed.
4. Google Sheets Node (Append Row) – Appends each row to the designated sheet.

This method mirrors what the documentation describes for inserting an array (or table) into Google Sheets by processing each row individually. Enjoy building your workflow!