Hi folks,

I need to create multiple records from nested arrays in a web hook payload.

Initially will write them to a Google Sheet until we know it is valid and will write it to our CRM.

Trying to use Loop by Zapier which works great on a flat loop, but nested isn’t supported.

The data is for Products,

• broken out into editions (e. gold, silver, bronze)
• further divided into payment plans (monthly, yearly)
• further divided into price breaks ( 1-100@$20ea, over 100@$15ea)

I need to create product record for every price break.

Webhook data comes in similar to this:

product:
	name: Widgets
	editions:
		1:
			Name: Bronze
			Plans:
				1:
					frequency: monthly
					costs:
						1:
							quantity: 1-12
							price: 20
						2:
							quantity:12-24
							price: 15
				2:
					frequency: yearly
					costs:
						1:
							quantity: 1-500
							price: 10
						2:
							quantity: 500-1000
							price: 5
		2:
			Name: Silver
			Plans:
				1:
					frequency: monthly
					costs:
						1:
							quantity: 1-12
							price: 30
						2:
							quantity:12-24
							price: 25
				2:
					frequency: yearly
					costs:
						1:
							quantity: 1-500
							price: 20
						2:
							quantity: 500-1000
							price: 15
		3:
			Name: Gold
			Plans:
				1:
					frequency: monthly
					costs:
						1:
							quantity: 1-12
							price: 40
						2:
							quantity:12-24
							price: 35
				2:
					frequency: yearly
					costs:
						1:
							quantity: 1-500
							price: 30
						2:
							quantity: 500-1000
							price: 25