Map Table Rows to Any
This node lets you transform Google Spreadsheets data to any data structure.
This node will help you to transform Google Spreadsheets data into any other data structure .
Example
Let’s say you have data about a group of people in a spreadsheet that’s structured like this:
Name | Age | Location |
Peter | 31 | New York |
Anna | 27 | London |
Sharif | 35 | Paris |
Alex | 29 | Berlin |
By using the Fetch Google Spreadsheets node, you will get this data structured as Rows.
In order to now transform it, i.e. into a list of objects with each person, we can use the Map Table Rows to Any node. Take a look at the example below to understand better how you can use it:
Input Fields
field | schema | explanation |
rows | table_rows | Input the table rows to be converted. |
schema | schema_id | Select a schema of the data input. |
mapping | table_row_mapping | Select mapping for spreadsheet columns to data paths. |
Output Fields
field | schema | explanation |
data | any | Outputs the data in the schema chosen. I.e. as a list of objects. |
Did this answer your question?
😞
😐
🤩
Last updated on November 9, 2022