Hello Make Folks!
I’ve been stuck on what feels like an easy problem, but no avail.
Goal
I am receiving form data via a webhook. I would like to store each form response as a row in Google Sheets. I’ve also been using the Make built in data store as another possible output. Either works for me.
Quirks of note
A) My form data has inconsistent records; sometimes one response, sometimes many.
B) The webhook data input is tricky to alter, given the limitations of how I’m generating the HTML form. (It’s a separate scenario that iterates over a text aggregator to dynamically render questions on the form. That text aggregator output sits within an email module’s HTML. All this results – as intended – in multiple questions with one submit button.)
C) I’ve tried many different things, and don’t think my current setup is my most efficient.
D) Because the forum is preventing my post for too many links, I have added spaces in all my example emails below.
Current Input
{
"key": null,
"data": {
"Note": "note1, note2, note3",
"Admin": "example@fake. com, example@fake. com, example@fake. com",
"Issue": "Too many mistakes, Too many mistakes, Never showed up",
"Action": "Pat on head, Forgiveness, Called Mom",
"Worker": "Bob One, Jane Two, Kaeli Three",
"Date_Responded": "2024-06-10T20:33:22.369Z"
},
"overwrite": false
}
]
Current Output (v1)
I can consistently create comma separated data within specific fields. This happens when I use the iterator’s array, such as {{52.array.notes}}. For example, column A might read example@fake. com,example@fake. com,example@fake. com
The full output could be described as this, across 5 columns in one row:
“example@fake. com, example@fake. com, example@fake. com”,“Bob One, Jane Two, Kaeli Three”,“Too many mistakes, Too many mistakes, Never showed up”,“Pat on head, Forgiveness, Called Mom”,“note1, note2, note3”
Alternate Output (v2)
I have also been able to create individual rows correctly, but it doesn’t iterate across the other values. This happens when I use the iterator’s specific fields, such as {{52.array.notes}}
Full output might look like this:
“example@fake.com”,“Bob One”,“Too many mistakes”,“Pat on head”,“note1”
Desired Output
“example@fake. com”,“Bob One”,“Too many mistakes”,“Pat on head”,“note1”
“example@fake. com”,“Jane Two”,“Too many mistakes”,“Forgiveness”,“note2”
etc.
blueprint (4).json (13.3 KB)
Huge thanks in advance.
