Map Any to Table Rows

This node lets you transform any data into Google Spreadsheets data.

This node will help you to transform any data into Google Spreadsheets data. If you want to build a report in Google Sheets based on Facebook Insights, you need to use this node before you use Append Google Spreadsheets nodes. Rows field at the output can be used as an input for any of the Spreadsheet rows nodes. Take a look at the example below to understand better how you can use it:

 

Example

Notion image

Input Fields

field
schema
explanation
data
any
Input the data that needs to be transformed into rows format.
schema
schema_id
Select a schema of the data input.
mapping
table_row_mapping
Select mapping for spreadsheet columns to data paths.
add_header
boolean
Enable this field if you want headers to be present in your Spreadsheet.

Output Fields

field
schema
explanation
rows
table_rows
Outputs the data in rows format that can be used to append Spreadsheets.

Video Tutorial

Did this answer your question?
😞
😐
🤩

Last updated on October 11, 2022