Hello,
I’m working in n8n cloud and trying to build an automation that extracts data from a Google Sheet and inserts it into a predefined template. The source file is a product table sent by another team, and one of its sections contains volumetric data (product dimensions, weight, etc.).
This section always contains three categories:
- Volumetry info for selling unit
- Volumetry info for box unit
- Volumetry info for pallet unit
They might not always be populated, but they are always present in the file.
Here’s a preview of the data:
The current flow:
Google Drive Trigger — triggers on changes to a specific file (where I insert the full source data).
Google Drive → Copy File — makes a copy of a template file (where the final processed data will be inserted).
Google Sheets → Get Rows — pulls data from the source file; data location: header row 2, first data row 3.
Edit Fields node — maps and prepares the data.
Append Row in Sheet — inserts data into the template copy created in step 2.
The issue appears in the last step where volumetric values like length, width, height, weight, and volume are sometimes duplicated or incorrectly assigned (surely i’m doing something wrong here).
Ideally, each value should look something like this: “Volumetry info for box unit - Length [mm]”: “438”, “Volumetry info for selling unit - Length [mm]”: “210” etc. and then be sent to my destination template, which follows the same column structure.
The result is that I often get only one set of values inserted, and not always for the correct unit.
And if I set the data location to “Header row 1” and “First data row 1”, it causes a misalignment, as the volumetric subcategories (like height, weight, etc.) are not captured properly under their full, expected labels.
Any tip will help. Thank you!