Note: The Google Sheet must have headers in the first row. The schema (i.e., the data you want to extract) is automatically generated using these headers.
Example: If your sheet has the following headers:
Name
Website
Contact
Schema will automatically be generated to extract values for name, website, and contact from the provided input.
The node allows you to configure certain parameters as dynamic inputs. You can enable these in the “Configure Inputs” section:
Extract Multiple Rows?: Boolean
true/false to enable extraction of multiple rows of data
Use when processing list-type content
Table Type: String
Currently only supports “Google Sheet”
Use Link: Boolean
true/false to use a Google Sheets URL instead of sheet selector
When enabled, allows direct input of spreadsheet URL
Add Columns Manually?: Boolean
true/false to enable manual column value input
When enabled, allows setting fixed values for certain columns
Additional Context: String
Extra information to guide the extraction process
Example: “The text contains company information with employee counts and revenue data”
When enabled as inputs, these parameters can be dynamically set by previous nodes in your workflow. If not enabled, the values set in the node configuration will be used.
Identifies relevant data points using the headers in the sheet
Structures data into table format
Writes to Google Sheets
Handles single or multiple rows
Note: Extract to Table uses OpenAI’s structured JSON output to extract data. For more details on structured outputs, see the OpenAI structured outputs guide.