Map set of collections into Google Sheet

[Bojan_Tomov]

What is your goal?

I am building a scenario which has a JSON → Parse JSON module which is outputting 4 different collections, each with task_name , description, assignee, deadline and follow_up

Here is the complete output bundle:

[ { “task_name”: “Backlink outreach for real estate client”, “description”: “Finalize the backlink outreach list and start sending outreach emails for the real estate client.”, “assignee”: “John”, “deadline”: “2026-02-14”, “follow_up”: “2026-02-12 15:00” }, { “task_name”: “Three SEO blog drafts for SaaS client”, “description”: “Write three SEO-optimized blog post drafts (topics in Notion) for the SaaS client.”, “assignee”: “Maria”, “deadline”: “2026-02-18”, “follow_up”: “2026-02-17 09:00” }, { “task_name”: “On-page SEO updates for e-commerce product pages”, “description”: “Update meta titles and descriptions for the top 20 product pages on the e-commerce website.”, “assignee”: “John”, “deadline”: “2026-02-17”, “follow_up”: “2026-02-13 12:00” }, { “task_name”: “Monthly SEO performance report”, “description”: “Prepare the monthly SEO performance report covering all active clients.”, “assignee”: “Maria”, “deadline”: “2026-02-19”, “follow_up”: “2026-02-18 10:00” } ]

Now, I need to enter this information into Google Sheet.

How do I add each Collection/Bundle separately?

The output is a Collection generate from a Meeting Transcript, each collection has the task name and the employee that will work on it, which means it needs to be assigned to an employee.

What have you tried so far?

I tried using an iterator and it’s Outputting the results separately but I am not able to map them into Google Sheets.

Screenshots: scenario setup, module configuration, errors

[Stoyan_Vatov]

Hey Bojan,

the JSON is not producing an array, so you don’t need the iterator module here. You can map the values coming from the Parse JSON directly in the google sheets module.

[AnthonyatXRAY]

The issue is that the Parse JSON module is producing an array of collections while Google Sheets is only allowed one row per bundle.

What you need to do is add an Iterator after the JSON parsing and map the whole array in it. The iterator then splits the array into bundles.

After that you can finally add the Google Sheets module after the iterator and map the fields from the Iterator Output. This will allow a row to be created automatically after each iteration.

[Bojan_Tomov]

Thanks. For some reason it was not working last night but I’ve tried it after I read your comment and it worked. I removed the iterator so it’s Parse JSON Module → Google Sheets Add A Row and it’s working fine even with multiple bundles. Amazing.