The biggest challenge in any spreadsheet is converting free-text to structured data. Your most valuable information is often locked away in a digital black box: the single spreadsheet cell. It arrives as a dense “blob of text”—a detailed note from a sales call, a rich inquiry from a new lead, or a full address pasted into one field. All the critical information is there, but it’s trapped.
This is the core frustration of unstructured data. A single cell holding a name, company, email, and project needs isn’t a database. You can’t sort by company, filter by project, or build a report on a foundation of jumbled text. To make it useful, you’re forced into the soul-crushing, error-prone task of manually copying and pasting each piece of information into its own column.
What if you had a key to unlock that black box? What if you could teach your spreadsheet to intelligently read a block of text, identify the distinct pieces of information within it, and automatically place them into a perfectly organized structure?
This is the power of the Sheetgo AI Data Processor. It’s designed specifically for the free-text to structured data transformation, turning messy text into organized columns with a single prompt.
In this guide, we’ll show you how to liberate the data trapped in your spreadsheets. We’ll walk through real-world examples for sales, HR, and operations, providing everything you need to build your own free-text to structured data workflows.
The Problem: Why Free-Text Breaks Workflows
When your data lives as a block of text, your team is forced to become a human parser. The job becomes a slow, manual assembly line of clicks and keystrokes: highlight a name, copy; click another cell, paste. Highlight a company, copy; click, paste. Highlight an email—oops, you missed the “.com”—go back, re-highlight, copy; click, paste.
Ultimately, this manual approach to converting free-text to structured data doesn’t scale. It creates data that is inconsistent, unreliable, and almost always out of date. With Sheetgo AI, you can solve the free-text to structured data problem in seconds — turning narrative into actionable data.
Sign up for Sheetgo
First, you’ll need a Sheetgo account. It’s free to get started, and the process takes less than a minute.
>> Click here to sign up for Sheetgo
Once you’re signed in, you’ll land on the main dashboard. From there, click the + Create workflow button and select Start from scratch to build your first automatic data enrichment workflow.
That’s it. You’re now ready to connect your data and build your first free-text to structured data workflow with the AI Data Processor.
Use Case 1: Free-text to Structured Data for Sales Teams
The Scenario: Your sales team is constantly capturing valuable lead information from discovery calls, web forms, and networking events. To save time, they often dump all the details into a single Notes field in a spreadsheet. The information is safe, but it represents a classic free-text to structured data challenge that makes it impossible to sort, filter, or analyze.
The Goal: To transform these messy, free-text notes into a clean, structured database with separate columns for each piece of information, making the data instantly ready for analysis, reporting, or import into a CRM.
Sample Google Sheet
The spreadsheet contains contact information, company details, and notes about various sales leads.
1. Start Your Workflow : In your Sheetgo dashboard, click the + Create workflow button and select Start from scratch.
2. Click Select source. Choose Google Sheets and then find and select your spreadsheet named July-Lead Notes . Make sure to select the tab containing the lead notes and click Next.
3. Click the (+) button below your source connection to add the next step. From the menu that appears, select AI data processing.
4. A configuration panel will appear. This is where you will give the AI its instructions. In the text box, paste the prompt specific to your goal. This is the most important step of the free-text to structured data process, as the prompt tells the AI exactly what you want to achieve. Paste the following prompt:
From the text in the @Lead Notes column, create new columns called Contact Name, Company, Email, and Product Interest. Analyze the notes to find each piece of information and extract it into the corresponding new column.
5. Click the (+) button again and select Google Sheets as the destination. You can either choose to create a new spreadsheet and give it the name, or name continue within the current spreadsheet and select a new tab. Once done, click Finish and Save.
6. Immediately after saving, you’ll see a screen indicating that the workflow is running. A message at the top will confirm the workflow’s progress.
Your spreadsheet will instantly display clean, structured data — with each key detail like Contact Name, Company, Email, or Product Interest neatly extracted into its own column. It’s the fastest way to convert free-text to structured data and get actionable business insight. To view your results, you have two easy options:
- From the Sheetgo Dashboard: Your destination file in the workflow view is now a clickable link. Simply click on it to open your new Google Sheet directly.
- In your Google Drive: Locate your original July-Lead Notes spreadsheet. It now contains two tabs: one with your original data and another labeled Sheetgo_Lead_Notes (which you can rename) where the AI has seamlessly integrated the new columns.
Use Case 2: Free-text to Structured Data for HR & Recruiting
The Scenario: Your HR team is managing a flood of applications where critical candidate information is buried in paragraphs of text, creating a difficult free-text to structured data problem for the hiring team.
The Goal: To automatically parse these unstructured applicant profiles into a clean, filterable database, allowing the hiring team to instantly sort, search, and compare candidates.
Sample Google Sheet
This dataset simulates real-world applicant notes from various sources like emails, recruiter summaries, and job board exports.
1. Start Your Workflow : In your Sheetgo dashboard, click the + Create workflow button and select Start from scratch.
2. Click Select source. Choose Google Sheets and then find and select your spreadsheet named Applicant Tracker. Make sure to select the tab containing the applicant profiles and click Next.
3. Click the (+) button below your source connection to add the next step. From the menu that appears, select AI data processing.
4. A configuration panel will appear. This is where you will give the AI its instructions. In the text box, paste the prompt specific to your goal. This is the most important step, as it tells the AI exactly what you want to achieve. Paste the following prompt:
From the unstructured text in the @Applicant Profile column, create new columns called Candidate Name, Years of Experience, Key Skills, and Applied For Role. Analyze each profile to find these details and extract them.
5. Click the (+) button again and select Google Sheets as the destination. You can either choose to create a new spreadsheet and give it the name, or name continue within the current spreadsheet and select a new tab. Once done, click Finish and Save.
6. Immediately after saving, you’ll see a screen indicating that the workflow is running. A message at the top will confirm the workflow’s progress.
Your spreadsheet will instantly display clean, structured data — with each key detail like Candidate Name, Years of Experience, and Key Skills neatly extracted into its own column. neatly extracted into its own column. It’s the fastest way to turn unstructured notes into actionable business insight. To view your results, you have two easy options:
- From the Sheetgo Dashboard: Your destination file in the workflow view is now a clickable link. Simply click on it to open your new Google Sheet directly.
- In your Google Drive: Locate your original Application Tracker spreadsheet. It now contains two tabs: one with your original data and another labeled Sheetgo_Applicant Profiles (which you can rename) where the AI has seamlessly integrated the new columns.
Use Case 3: Free-text to Structured Data for Operations & Logistics
The Scenario: A logistics team has a list of delivery addresses where the entire address (street, city, state, zip) is jumbled together in a single field, making it impossible to generate shipping labels or calculate routes.
The Goal: To have the AI intelligently parse the single string of text into structured address components for use in shipping and logistics software.
Sample Google Sheet
This sheet simulates a list of customer shipping addresses. It contains a Full Address column with the complete, unformatted address in a single cell.
1. Start Your Workflow : In your Sheetgo dashboard, click the + Create workflow button and select Start from scratch.
2. Click Select source. Choose Google Sheets and then find and select your spreadsheet named Customer Address List. Make sure to select the tab containing the address details and click Next.
3. Click the (+) button below your source connection to add the next step. From the menu that appears, select AI data processing.
4. A configuration panel will appear. This is where you will give the AI its instructions. In the text box, paste the prompt specific to your goal. This is the most important step, as it tells the AI exactly what you want to achieve. Paste the following prompt:
From the @Full Address column, extract the street address, city, state, and ZIP code into four new columns named Street, City, State, and ZIP.
5. Click the (+) button again and select Google Sheets as the destination. You can either choose to create a new spreadsheet and give it the name, or name continue within the current spreadsheet and select a new tab. Once done, click Finish and Save.
6. Immediately after saving, you’ll see a screen indicating that the workflow is running. A message at the top will confirm the workflow’s progress.
Your spreadsheet will instantly display clean, structured data — with each key detail like Street, City, State, and ZIP, ready for any logistics platform. This free-text to structured data workflow is the fastest way to prepare addresses for any logistics platform. To view your results, you have two easy options:
- From the Sheetgo Dashboard: Your destination file in the workflow view is now a clickable link. Simply click on it to open your new Google Sheet directly.
- In your Google Drive: Locate your original Customer Address List spreadsheet. It now contains two tabs: one with your original data and another labeled Sheetgo_Full-Address-list (which you can rename) where the AI has seamlessly integrated the new columns.
English 
Español 
Português do Brasil 
Français