Turning a collection from GSheets into an Array that I can iterate over

Beginner Questions
,
1

:bullseye: What is your goal?

I need to convert data that I have in a GSheets matrix (with dynamic rows AND columns), into a format that is better suited to Airtable.

In Gheets I have a matrix that shows users (in Rows), message templates (in Columns), with the values showing a send date.

In Airtable, I’d like this to be a simple table showing user, template, and send date.

:thinking: What is the problem?

I’ve tried searching the range with the GSheets module, converting the outputed bundle data into an array, and then iterating over it - but it’s not quite working. As you can see in the screenshots, the column name (ie the message template) is present in the GSheets extract, but doesn’t materialise as the ‘key’ in the array that is iterated over… The date (value) does as is shown in Bundle 14 below.

Why isn’t it working, and am I approaching the problem in the right way?

:camera_with_flash: Screenshots: scenario setup, module configuration, errors

1.png
1.png819×421 10.9 KB

1b.png
1b.png764×1043 68.1 KB

2.png
2.png1376×445 50.2 KB

3.png
3.png750×943 45.6 KB

3

Hey Oliver,

why are you mapping the entire JSON [bundle] item coming from the module in the iterator? I see this done time and again here on the community. Is there some youtube tutorial that I missed that suggests doing this?

Anyways, so you want to create a new items per message in airtable right?

Use the Search Rows module to get the rows you are looking for in gsheet and after that have 4 airtable modules to create a new row for each message - user is mapped, message template is hardcoded as the respective column and the send date is mapped from the respective column.