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:

Notion image
 

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