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 Options

You can expose these fields as inputs:

• Additional Context

​

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

1. Requires Authentication with Google - Set up in the Credentials page
2. 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.