How do I output dropdown text (not ID) into Google Sheets from a Tally.so webhook in Make.com?

[Magnus_Bossen_Herlin]

Hi everyone,

I’m building a Make.com scenario that starts with a Tally.so form → Webhook → Google Sheets “Add a Row”. One of my questions in Tally is a single‐select dropdown (e.g. “What task do we have to perform?”. Answers: “Private Cleaning”, “Commercial cleaning”, etc.).
When I map the dropdown answer into my Google Sheet, I’m only getting the ID value (e.g. 70168e1e-c5f7-48e0-9f81-8b352d5f5a5f) rather than the readable text label “Private Cleaning”, that I want.

What I’ve tried so far:

• Directly mapping 3.data.fields[5].value[1] into the sheet → returns only the ID.
• A switch()‐formula with all ID→text pairs in the Google Sheets module — but it still falls back to my default (“Unknown”).
• A map()/get() formula to filter the webhook’s options array, but I’m having trouble referencing the correct path in the JSON.

I’ve attached screenshots of: (Watch below)

• The Webhook output showing fields[5].value (the ID) and fields[5].options (the list of {id, text})
• My Google Sheets module configuration where I need to enter the formula.

Do you have an idea on how to make this work?

Some of the text is in danish, but hopefully it makes scense. Thanks in advance for any examples or pointers—this will save me a ton of time!

[Magnus_Bossen_Herlin]

For reference, I tried writing this to make it return the text instead of just the ID number, but without success. That field in Google Sheets remains blank, while the other fields update correctly.