Node Inputs
Required Fields
- Text: Content to extract data from
- Google Sheet: Select sheet or paste link
- Sheet Name: Target sheet for data
- 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”
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
Important Considerations
- Requires Authentication with Google - Set up in the Credentials page
- Sheet must have headers in the first row