Generate Structured Data

The Generate Structured Data node transforms AI responses from text paragraphs into organized tables that you can use in Google Sheets, databases, or other systems.

​

The Challenge with AI Text Responses

When you ask AI to analyze data, it typically responds with paragraphs of text that are hard to use:

• Difficult to import into spreadsheets
• Can’t be used for calculations
• Hard to compare or sort information
• Not consistent between different queries

​

The Solution: Structured Tables

This node ensures AI returns organized data in table format that you can immediately use in other tools. Instead of paragraphs, you get clean rows and columns ready for Google Sheets, your CRM, or any other system.

​

When to Use It

Use this node when you want AI to return tables of data instead of text paragraphs:

• Add calculated columns to existing data
• Extract structured information from text
• Create consistent data formats for other tools
• Convert messy data into clean tables

​

Example 1: Adding Calculated Columns

The Challenge: If you ask regular AI to analyze campaign data, it responds with text like “Campaign A has a cost per conversion of $33.33…” This text can’t be used in spreadsheets.

The Solution: Get the same analysis as an organized table ready for Google Sheets.

Your Data:

Campaign A: $1,500 cost, 45 conversions
Campaign B: $2,000 cost, 80 conversions  
Campaign C: $800 cost, 32 conversions

What You Want: Add a “Cost Per Conversion” column

How to Set It Up:

1. Prompt:

Take this campaign data and create a table with cost per conversion calculated for each campaign:
[Insert your campaign data here]

2. Schema Type: List of Objects (because you want multiple rows)

3. Schema Fields:

   • campaign_name (Text) - “Name of the campaign”
   • cost (Number) - “Total cost spent”
   • conversions (Number) - “Number of conversions”
   • cost_per_conversion (Number) - “Cost divided by conversions”

Result:

This table can be sent directly to Google Sheets or used in other workflow steps.

​

Example 2: Lead Qualification

The Challenge: Regular AI would analyze emails and respond with text like “John from TechCorp seems like a good lead…” This text is hard to organize and compare.

The Solution: Get lead analysis as structured data with consistent scoring for easy CRM import.

Your Data:

Email 1: "Hi, I'm John from TechCorp. We're a 50-person company looking for marketing automation. Budget is around $5K/month. Need to implement by Q2."

Email 2: "Hello, small business owner here. Interested in your services but need to keep costs low. Maybe $500/month max."

What You Want: Qualify leads with consistent scoring

How to Set It Up:

1. Prompt:

Analyze these sales inquiries and score each lead based on budget, company size, and urgency:
[Insert email inquiries here]

2. Schema Type: List of Objects

3. Schema Fields:

   • company_name (Text) - “Company name mentioned”
   • contact_person (Text) - “Person’s name”
   • budget_monthly (Number) - “Monthly budget in dollars”
   • company_size (Text) - “Small, Medium, or Large”
   • urgency (Text) - “High, Medium, or Low”
   • qualification_score (Number) - “Score from 1-10 based on fit”

Result:

Now you have consistent lead data that can go into your CRM.

​

Schema Types

List of Objects: Use when you want multiple rows (like a table)

• Campaign performance data
• Lead qualification
• Product comparisons
• Survey responses

Single Object: Use when you want one summary row

• Total campaign summary
• Overall lead score
• Single product analysis

​

Inputs

​

How to Define Schema Fields

For each column in your table:

Name: Use simple names like campaign_name, total_cost, conversion_rate

Type:

• Text: Names, descriptions, categories
• Number: Costs, counts, scores
• Percentage: Rates (returns as 0.15 for 15%)

Description: Tell the AI exactly what to put in this column:

• “Campaign name from the data”
• “Total cost in dollars”
• “Cost divided by conversions, rounded to 2 decimals”

​

Frequently Asked Questions