Squarespace new order product form info to Google Sheets

Hi all,

I have a squarespace store that collects information from customers via a custom product form that they fill out before checking out. However, when I run the sequence I’m not able to access the form information. I read various threads on this, with some suggesting using the Make an API call module and some suggesting using get() and map() in order to turn the form data from a complex array into a simple array, but I’ve not had luck. Can anyone help me out, maybe by walking me through either of these ideas or providing a new way? I would be so grateful. Thanks!

Here is my form data that is captured:

I found that this data shows up in my sequence here, but only the last item on the form:
image

This similar topic was marked “solved” but I couldn’t make sense of it: Squarespace New Order - Product Form Questions to Google Sheet Row
Maybe someone can give me more info?

At the bottom of this thread, someone from Make describes a solution that I wasn’t able to implement successfully: Use Integromat to get product form data for Squarespace orders - Customize with code - Squarespace Forum

I tried this:

But I got this error:

I would be so grateful if anyone could help me! Thanks so much.