SurveyMonkey headaches - nested comments to map

How To
,
1

Hi everyone,

I’m new to Make.com, but I’ve already worked through several advanced tutorials. For the past two days I’ve been trying (unsuccessfully!) to complete what looked like a simple scenario, so I’m hoping someone can point out what I’m missing.

Goal

I have a SurveyMonkey survey with two questions:

  1. Question 1 – four multiple-choice options plus an optional comment field
  2. Question 2 – four multiple-choice options

I want each response written to a Google Sheet with three columns:

A B C
Main answer to Q1 Comment on Q1 Answer to Q2

What I’ve set up in Make

  1. SurveyMonkey → Make an API call – pulls all survey responses.
  2. Iterator – splits the array; the output bundle shows every answer and the comment.
  3. SurveyMonkey → Get a response – confirms the same data.
  4. Google Sheets → Add a row – maps the fields into columns A, B, C.

Problem

I can map and write the main answers for Q1 (column A) and Q2 (column C) without issues, but column B (the Q1 comment) always comes through blank, even though I can see it in the previous module’s output bundle.

Question

What common mistake might prevent that comment field from appearing in Google Sheets, and how can I fix it? Any guidance would be hugely appreciated!

Thanks in advance.

2
2788×790 107 KB

1
1827×766 106 KB

1 Like
2

Hi @Guillaume_Besson,

I think you need to include indexes in the datapill. I’ve marked where in Red.

image
image1183×1182 192 KB

You need to iterate on pages potentially. To get the values on the first page you can input a “0” in the first rectangle.

Hope this helps!

-@Trainward_Consulting