Mapping n8n Set Node Rows to Separate Google Sheets Tabs

Below is one approach you can take using n8n’s built-in Google Sheets operations:

1. Split the data:
   Since you have five rows of data in a single Set node, start by splitting them into separate items so you can process each website individually. You can do this using the “SplitInBatches” or “Item Lists” feature (depending on your setup).

2. Determine the target tab per item:
   Each item should include the website name or an identifier. Later, you’ll use this attribute to decide which tab (sheet) to send the data to. For example, you might have a field “website” that holds the website name.

3. Ensure the target tab exists:
   Use the “Google Sheets” node set to Sheet Within Document and choose the Create operation to add a new sheet (tab) to your document if it doesn’t already exist. You can:

   • Pre-create all tabs manually or in a separate workflow.
   • Or, within your workflow, detect if the tab exists and create it if needed (for example, by maintaining a list of created tabs or by using a conditional branch).

4. Append data into the target tab:
   For each individual item, use another instance of the Google Sheets node with the Sheet Within Document resource and choose the Append Row operation.
   In the node’s settings:

   • Set the Document parameter to your spreadsheet (by list, URL, or ID).
   • For the Sheet option, use an expression based on the website name (or other identifier) so that the correct tab is selected dynamically.

   For example, for the Sheet parameter, you might use:

   {{$json["website"]}}
   

   assuming your item has a property “website” with the desired tab name.

5. Mapping your data:
   Choose a Mapping Column Mode (manual or automatic) to send the health score metric along with any other details for that website. If using automatic mapping, ensure your field names match the header names in the Google Sheet.

Workflow Outline

• Set Node: Contains your five rows of website health scores.
• SplitInBatches (or equivalent): Processes each row individually.
• Optional – Create Sheet (if not pre-created): Checks/creates a tab using the “Create” operation.
• Google Sheets Node (Append Row): Uses the dynamic sheet (tab) name from your item to append each row in the correct tab.

Additional Tips

• Keep a consistent format: Use the node options (see the “Mapping Column Mode” and “Data Location on Sheet” settings in the docs) to ensure values align across tabs.
• Testing: You can use the Test mode in n8n to verify that for each website data item, the row is correctly added under the appropriate tab.
• Error Handling: If a tab isn’t found (if you’re not pre-creating them), consider adding a conditional branch to create the tab before appending the row.

This workflow lets you leverage n8n’s Google Sheets node capabilities (both creating new tabs and appending rows) so that each website’s health score is recorded in its own tab within a single spreadsheet.

Hope this helps! Let me know if you have any questions about configuring any of these nodes.