Help Needed: Automating Data Transfer from Google Sheet 1 to Google Sheet 2

How To
,
1

I want to automatically update the “Total Sold” column in Google Sheet #2 whenever new rows are added to Google Sheet #1. Specifically, I need the “Quantity Sold” values from new entries in Google Sheet #1 to be summed and reflected in the “Total Sold” column for the corresponding product in Google Sheet #2.

scenario
scenario882×430 28.4 KB

GOOGLE SHEET #1 (GFORM RESPONSES)

GSHEET 1
GSHEET 1895×248 11.2 KB

GOOGLE SHEET #2

GSHEET 2
GSHEET 2802×257 4.22 KB

Issue:

Let’s say there are two DEF items

Instead of summing the quantities correctly, the new value is concatenated to the old one, resulting in values like “105” instead of “15”.

Could anyone guide me on how to properly sum these values within Make.com, ensuring the total sold is updated correctly? Any detailed steps or examples would be greatly appreciated!