Extract to Table
This document explains the Extract to Table node, which converts unstructured text into organized data in Google Sheets.
Node Inputs
Required Fields
- Text: Content to extract data from
- Google Sheet: Select sheet or paste link
- Sheet Name: Target sheet for data
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.
Optional Fields
- Extract Multiple Rows: Enable for list-type data
- Manual Columns: Add data points for some columns manually instead of having them extracted by the AI model.
- Additional Context: Help guide the extraction
Show As 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.
Node Output
- Table Link: URL to your Google Sheet with extracted data
Node Functionality
The Extract to Table node:
- Analyzes text using AI
- 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.
Important Considerations
- Requires Authentication with Google - Set up in the Credentials page
- Sheet must have headers in the first row
In summary, the Extract to Table node helps transform unstructured text into organized, tabular data in Google Sheets.