Conduit Docs
  • Getting Started
    • Importing Data
    • Connecting Multiple Accounts
    • How To Invite Additional Team Members to Your Account
    • How Does the Trial Work?
    • What's a Table/Data Schema?
    • Number of Sub-Connections
    • Default Time Range for Downloading Data
    • Conduit Data Lake
    • Conduit vs Boost.Space
    • Conduit vs Reportz.io
    • Conduit vs Google Looker Studio
  • Use Cases
    • Use Case: AI-powered Text Extraction
    • Use Case: Track Ad Campaign Performance with Conduit
    • Use Case: Enhancing Project Management with Copilot
    • Use Case: Using Conduit for Financial Analysis
    • Use Case: Use ChatGPT with your data
    • Use Case: Build financial models from raw transactional data and generate P&L statements.
    • Use Case: Marketing data analytics
    • Use Case: Using data science frameworks using your data in spreadsheets Low-Code
    • Use Case: Custom Dimensions for Ad Operations
    • Use Case: Custom dimensions for E-Commerce
    • Use Case: Extract invoices from PDF
    • Use Case: Export data from SaaS applications to your spreadsheet
    • Use Case: Online store and a physical retail locations consolidated
    • Use Case: Pull data from Advertisement platforms to a spreadsheet
    • Use Case: Consolidation of data received as separate files, for example, separate Excel reports
    • Use Case: Names, IDs, SKUs normalization
    • Use Case: Integrating Conduit with a custom CRM using SSO/OAuth2
    • Use Case: Chat Bot for Your Data
    • Use Case: Display Net sales On a Dashboard by Subtracting Ad spend from Total Sales
    • Use Case: Conduit for Healthcare Applications
  • Security & Data Privacy
    • Data Retention Policy
    • How Conduit Complies with GDPR?
    • Security
  • Spreadsheets
    • Writing data to spreadsheets: Overwrite and Update
    • Using Formulas in Spreadsheets
    • The Time Range in formulas
    • The table in the spreadsheet does not start from the first line
  • Conduit for Digital Agencies
    • How to Use White Label
    • What is a Workspace and a Sub-account
    • Use Case: Creating a Dashboard for Two Clients
    • Users in Your Team vs. Sub-Accounts in Workspaces
    • Deleting a Workspace
    • How to Log Into a Workspace
    • How to Buy Additional Workspaces
    • Schedulers in Workspaces
  • Troubleshooting
    • Error codes and how to troubleshoot data-related issues
    • Google Drive Refusing To Connect
    • Why Are my Shopify stats different?
    • Facebook Integration: How to Fix the GraphMethodException Error
  • Copilot
    • Copilot Roles: Data Analyst vs AI Generalist
    • Conduit Copilot vs. ChatGPT – What's The Difference?
    • How to Tune the Copilot
    • Data Sources for Copilot
  • For Developers
    • IP Addresses of Conduit Servers
    • Create an AI Сopilot for your app
    • Manage your AI Copilot users
    • Upload CSV files to Conduit via API (Guide)
  • Integrations
    • Instagram Integration
    • Dashboard Widgets Based On a SQL Connection
    • GA4 Integration Notes
    • Salesloft Integration
    • Self-service and Manual integrations
    • Installing Google Sheets Add-On
    • Slack Integration
    • YouTube Integration
    • HubSpot Integration
    • Conduit integration for Bigcommerce
    • Xero Integration
    • Recharge integration
    • Wrike Integration
    • Zoho Integration
    • Monday.com Integration
    • ActiveCampaign Integration
    • ClickUp Integration
    • FreshSales Integration
    • Google Ads Quality Score
    • Facebook Ads Reach
    • Shopify Net Sales and Returns
    • Gorgias tickets with Spam/Deleted/Auto-Close statuses
    • Looker Studio Connector
  • Workflows
    • Workflows – Adding New Columns
    • Workflows – using the Join by Key block
    • Workflows – using the Union block
    • Workflows – using the Transpose block
    • Workflows – creating a weekly Ad Spend report
Powered by GitBook
On this page
Edit on GitHub
  1. Use Cases

Use Case: AI-powered Text Extraction

PreviousConduit vs Google Looker StudioNextUse Case: Track Ad Campaign Performance with Conduit

Last updated 11 months ago

Introduction to Conduit's AI-powered Text Extraction

Scanning documents can sometimes introduce challenges with unstructured text data. Conduit steps in as the solution, offering powerful AI capabilities for post-processing scanned text. Once you've scanned your documents, Conduit empowers you to go beyond mere recognition.

Imagine you have the results of recognizing various scanned documents, where the scanned textual data is within table cells. Your goal is to transform this unstructured text into a table format, with essential information neatly organized into separate columns.

Key Post-Processing Capabilities:

  • Data Structuring: Conduit's AI assistant effortlessly transforms raw, scanned text into structured data, making it easier to analyze and interpret.

  • Entity Recognition: Identify and extract specific entities or information from the scanned text, streamlining the retrieval of essential details.

  • Multi-column Mapping: Seamlessly map diverse data points within the scanned text to multiple columns, enhancing the granularity of your structured data.

A couple of brief examples showcasing the functionality of Conduit's AI post-processing capabilities:

Invoice Data Extraction: Conduit excels in extracting critical details from scanned invoices, seamlessly mapping data like billing amounts, dates, and vendor information to distinct columns. This ensures quick and accurate processing for financial analysis.

Contract Parsing: Transform lengthy, unstructured contract texts into organized tables with Conduit's post-processing. Identify key clauses, parties involved, and contract dates, allowing for efficient contract management and review.

Survey Responses Analysis: Post-process scanned survey responses using Conduit to categorize and map textual answers to multiple columns. This simplifies sentiment analysis and aids in understanding trends and patterns within survey data.

Now, let's dive into the detailed instructions!

Selecting Essential Blocks for the Text Extracting Workflow

  1. Start by adding a 'Pull CSV Import' block to your canvas.

  2. Attach to this block the link to your sheet.

  3. Drag and drop the 'Ask AI (for each row)' block.

Configuring the Ask AI block

The Ask AI block in Conduit serves as an intelligent intermediary, prompting the AI to extract specific information from raw data. Placed in the workflow, it enables precise data mapping by instructing the AI on what to extract and where to place the results. This block has three configurable parameters:

Dataset: The dataset containing the digital documents. Input Column: The column that contains the data you want to process. This is typically the column where your raw digital data is located. Output Column: The column where you want the processed data to be placed.

Prompts Crafting Techniques

You have the flexibility to define precise instructions for the AI by crafting natural language commands, commonly referred to as prompts. In the following example, we'll attempt to map the order details to several columns within the same sheet

So, here is how our raw data looks like

Let's compose the following prompt for extracting date & time of the order and run the workflow.

Extract the date of the order from the text in the dataset. Just print the date of the order {value}

Important: Please do not modify the {value} parameter and bear in mind, that it would be necessary to keep it within your prompt

If everything were done correctly, you should receive a notification on the bottom right corner of the screen, once the workflow is successfully performed. And here are the results of our workflow

Mapping the multiple cells

In the previous example, we've already mapped the date and time of the order to the Date column. Our goal for now is to modify that workflow to map the customer's name, shipping address, and the full name of the fulfilling employee into the separate columns

To achieve this, you can add several Ask AI blocks in a Workflow, assigning to each:

  • Source Dataset

  • Input Column

  • Output Column

  • Prompt: Input prompt text

Important: It's crucial to have for each subsequent Ask AI block, the previous Ask AI block selected as the dataset.

Now, let's add to the canvas the block, that would be responsible for extracting the customer's name and use the following prompt:

Extract the full name of the customer and print it as is {value}

Then, drag to the canvas another block, that'd stand for extracting the shipping address and this prompt:

Extract the shipping address of the customer and print it as is {value}

Now, we need to add the final Ask AI block to the sequence. This one would handling extracting the employee name. And here is the prompt for it:

Extract the full name of the employee who fulfilled the order and print its name as is {value}

Add the 'Save to Google Sheet' block and link it with the output sheet (this could be the same sheet with your raw data)

We're almost set. Let's click on the 'Run Workflow' button and wait for the workflow to finish its job. Here is the output of the workflow:

Log into your .

Navigate to the tab and click on the 'Create New Workflow' button tab and click on 'Create New Workflow.'

Conduit account
Workflows