Dromo

Messy spreadsheets cleaned and imported through AI-powered Dromo workflows

Your customers upload CSV and Excel files that need validation, column matching, and error correction before import. Your AI agent handles the Dromo pipeline, uploading files to headless imports, tracking processing status, and surfacing results without manual data wrangling.

Chosen by 800+ global brands across industries

Data import operations via conversation

Dromo validates, cleans, and formats messy spreadsheet data automatically. Your AI agent manages the import pipeline, tracks upload progress, and delivers results through natural language.

Dromo

Use Cases

Clean data imports, zero manual effort

Practical scenarios where AI manages the spreadsheet import pipeline, from file upload through validation to successful data delivery, keeping users informed at every step.

Customer Data File Submitted via Chat

A client attaches a CSV with 5,000 customer records during a conversation and says 'please import this.' Your AI Agent uploads the file to Dromo's headless import pipeline with the appropriate schema. Dromo validates columns, flags missing emails and duplicate phone numbers, and returns cleaned data. The agent confirms the import succeeded and reports how many records passed validation.

Daily Import Health Check for Operations Teams

Every morning, an operations manager asks the AI Agent 'How did last night's data imports go?' The agent queries Dromo for all uploads from the past 24 hours, filters by status, and summarizes: 14 completed successfully, 2 need manual review due to schema mismatches. The manager clicks the review links to resolve issues without searching the Dromo dashboard.

Handling Failed Validations Gracefully

A partner uploads a product catalog spreadsheet with inconsistent column names. Dromo's schema validation catches the mismatches and puts the import in review status. Your AI Agent detects this, explains that three columns could not be matched automatically, and shares the Dromo review URL where the partner can manually map the fields. Once resolved, the agent confirms the import completed.

Try
Dromo

Dromo

FAQs

Frequently Asked Questions

How does the AI agent upload a spreadsheet file to Dromo?

The agent uses Dromo's headless import flow. It performs an HTTP PUT of the raw file bytes to a signed upload URL with the correct MIME type header. Once uploaded, Dromo automatically begins processing the file against your predefined schema, running column matching and validation rules.

What file formats can the agent import through Dromo?

Dromo supports CSV, XLS, XLSX, and TSV files. The agent specifies the correct content type when uploading. Dromo handles parsing and column detection regardless of format, applying the same schema validation and error correction across all supported file types.

What authentication does Tars need for the Dromo integration?

Tars requires your Dromo backend license key, which authenticates via the X-Dromo-License-Key header. This key is separate from the frontend license key used for embedded importers. You can generate and manage it from your Dromo account settings.

Does Tars store the uploaded spreadsheet data?

No. Tars passes the file directly to Dromo's signed upload URL during the conversation. The raw file data and validated results are stored in Dromo's infrastructure according to your data retention settings. Tars does not retain copies of imported files or processed records.

What happens when an import has validation errors that need manual review?

Dromo sets the import to a 'needs review' state and generates a review URL. The AI agent detects this status, explains the nature of the validation failures to the user, and provides the review URL. Users can open it in a browser to resolve column mapping issues or correct data errors using Dromo's built-in interface.

Can the agent handle imports with thousands of rows?

Yes. Dromo's headless import pipeline processes files of any size supported by your Dromo plan. The agent uploads the file and monitors the processing status. For very large files, the agent can check back on progress and notify users when processing completes.

How is using Dromo through Tars different from the embedded Dromo importer?

The embedded importer is a UI widget your users interact with visually. Through Tars, the import process happens conversationally or via backend API calls. This is ideal for headless workflows, internal tools, and situations where users submit files through chat rather than a dedicated import screen.

Can I check the history of all imports my organization has run?

Yes. The agent queries Dromo's List Uploads endpoint with pagination, status filters, and sort options. It can retrieve your complete import history, filter by completed or failed imports, and sort by date. This works for any volume of imports in your Dromo account.

How to add Tools to your AI Agent

Supercharge your AI Agent with Tool Integrations

Don't limit your AI Agent to basic conversations. Watch how to configure and add powerful tools making your agent smarter and more functional.

Privacy & Security

We’ll never let you lose sleep over privacy and security concerns

At Tars, we take privacy and security very seriously. We are compliant with GDPR, ISO, SOC 2, and HIPAA.

GDPR
ISO
SOC 2
HIPAA

Still scrolling? We both know you're interested.

Let's chat about AI Agents the old-fashioned way. Get a demo tailored to your requirements.

Schedule a Demo