Cleaning data often slows down import workflows. Variable formats, missing values, and inconsistent entries can turn what should be a straightforward import into a mountain of a task—making workflows more complex and time-consuming than they need to be.
That’s why we’re thrilled to introduce Prompts to our Ingestro Data Importer. This future-facing capability streamlines data preparation directly within your import workflow. Whether you need to standardize formats, split columns, or run calculations, it’s all just a prompt away.
With Prompts, you can bulk-edit unpredictable data using natural-language instructions. The solution makes it easier to process messy files for import, reduce implementation time, and improve data quality—no coding required. Here’s how to unlock its full potential.
Prompts empowers users to apply custom data cleanings by submitting plain-text instructions during the Review Entries step of the import process. Our powerful Ingestro AI can interpret your instructions and generate a JavaScript transformation tailored to your selected column.
All data cleaning runs directly in your browser. Ingestro AI uses only your prompt and defined schema in the Target Data Model (TDM) to generate cleaning logic. It never processes the imported data itself, ensuring full compliance with strict data privacy and security standards.
Here’s how Prompts works:
Each transformation runs once and applies only to the current dataset state. If you make changes later, such as manual edits or adding new rows, the AI-generated formula will not run again.
| Key benefits of Prompts | |
|---|---|
| Simplified data cleaning | With built-in guidance, your customers can easily bulk-edit their data using natural language and get it ready for use in no time. |
| Adaptable to any use case | You don't need to anticipate every possible import scenario in advance. Prompts lets you handle unpredictable data cleaning requirements directly within the import workflow. |
| Faster implementation with reduced engineering effort | Avoid the need to write custom cleaning functions. With Prompts, your engineering team can focus on core development, while users can easily clean their data as needed. |
| Enhanced data quality | Automating cleanings with Ingestro AI helps eliminate the inconsistencies and errors common in manual edits, ensuring more reliable, accurate data. |
| Secure by design | As Prompts doesn't process imported data, it ensures strong privacy safeguards and removes compliance concerns. |
Prompts offers the flexibility to handle a wide range of data transformations without writing code or relying on pre-configured logic. These include tasks such as:
Standardize formats
Normalize values
Enrich data
Remove data
Merge columns
Split columns
Fix errors
Perform cross-column calculations
Extract data
Categorize data based on values in other columns
Validate data
These are just a few examples—there’s a lot more you can do. You can use Ingestro AI Prompts for your transformation as long as it does not require external data sources and can be expressed as a formula.
In this video, you’ll learn about several data transformation scenarios, from extracting and categorizing data to performing calculations.
Prompts brings powerful, flexible data cleaning right into the import experience—no code, no delay. With a simple prompt, users can transform data in seconds, all without compromising data privacy.
It’s built to handle the unexpected, so your team spends less time on edge cases and your users get cleaner data, faster.
Ready to try it out? Reach out to our team to enable Prompts in your importer.
.png)
.png)
