Originally launched in 2021, Zoho DataPrep started as an efficient self-service data preparation solution. We are excited to launch our new version 2.0, with significant enhancements to our platform to help you manage your end-to-end data needs with the help of AI
With the increasing volumes of data, preparing and managing your business data is time-consuming, complex, and prone to human errors. That’s where Zoho DataPrep comes into play.
Key highlights of our new launch:
Visual Pipeline Builder: Build Complex Pipelines with Ease
Understanding the flow of your business data can be confusing. With Zoho DataPrep's no-code pipeline builder one can easily create complex pipelines by visualizing the flow of data. The pipeline builder makes it effortless to build, test, and run complex pipelines within minutes.
Ask Zia – Your AI Assistant for DataPrep
Even though our DataPrep Studio's text selection feature simplifies data cleaning and preparation, the integration with Ask Zia has makes the entire data preparation process a breeze. Simply explain your data preparation needs in natural language, and Ask Zia, our generative AI assistant, will generate the required data transforms instantly.
Example: "Remove duplicates from email column and delete rows with @gmail"—and just like that, it’s done!
Save Time with Reusable Pipelines and Pre-built Pipeline Templates
If your business has redundant processes, it can get tiring to build multiple similar pipelines. Zoho DataPrep 2.0 introduces reusable pipeline templates where once you build a pipeline, it can be saved as a template and reused for other similar processes. Pipeline Templates gallery is also available, which enables you to kick start your data preparation journey with pre-built templates for common use cases.
Real-Time Monitoring Dashboard: Keep Track of Everything
Monitoring and managing your data has become easy with our new Monitoring Dashboard. Review pipeline statuses instantly and monitor all your data jobs in real-time. The monitoring dashboard gives full visibility over your various active and historic pipeline jobs within the platform.

Orchestrate Data Workflows with Zoho Flow and Webhooks
Let your data pipelines run with more flexibility with the new orchestration capabilities. With Zoho Flow, create workflow triggers for job monitoring alerts and pipeline sequencing with the exhaustive lists of applications that Zoho Flow supports. Custom webhooks lets you set up triggers for your pipelines from any business applications to ensure seamless data pipeline automations.
More Integrations for Seamless Data Transfer
Zoho DataPrep 2.0 data connectors list now includes Salesforce, Zoho Bigin, Zoho Forms, Zoho Creator, Sharepoint, and more to make data management easy by connecting to various business applications and storage solutions.
Why Zoho DataPrep 2.0?
With these new and improved features, Zoho DataPrep 2.0 is designed to make your data preparation faster, smarter, and more efficient. Whether you’re looking to streamline complex data flows, leverage AI for faster data transformations, or gain full control over your data pipelines, DataPrep 2.0 has everything you need.
Ready to experience the power of Zoho DataPrep 2.0, head to our
What’s New page.
Recent Topics
How to Bulk-Update Sales Orders in CRM
Hi - I need to bulk update existing sales orders with dates from our ERP of when the sales orders were created. I made a date field on the Sales Order module where I want to insert that data. I can't Mass Update because I am not updating the fields to
How to track salesiq on google analytics without GTM
Hello! We had to move the installation of the SalesIQ widget from GTM to directly do it in our wordpress site. The SalesIQ widget was being blocked by Adblockers which caused a lot of our visitors to not be able to see it. This issue was fixed from deleting
Feature Request - Improved booking layouts, specifically for individual booking links
I would like to see more layout options and specifically to have the meeting description beside the calendar booking function, when sharing booking links to specific consultations/meetings. Below is a screenshot from Calendly. I love this layout and it
Announcing New Features in Trident for macOS (v.1.2.0)
Hello Community, Trident for macOS has quite a few new features that will improve your business email communication. Let's take a quick look at them. Creating templates Earlier, you could save email drafts as templates in Trident. With the current update,
Zoho Commerce
Hi, I have zoho one and use Zoho Books. I am very interested in Zoho Commerce , especially with how all is integrated but have a question. I do not want my store to show prices for customers that are not log in. Is there a way to hide the prices if not
Products in time entry
Morning, Is there a way to add the product field to the time entry layout? Giving us the ability to identify a product per time entry. Thanks Rudy
Zoho.eu and U.S. Cloud Act? Can U.S. request Zoho.eu data?
Given the current political situation in the U.S. and possible near future implications for data privacy and security, I am curious about Zoho’s obligation to comply with the U.S. cloud act or other U.S. requests for private customer information from
Zoholics Europe Awards
We're excited to announce that at this year's Zoholics events across Europe, we're holding customer awards for the first time ever! This is your chance to shout about the amazing things you've created, connected, or achieved with Zoho's developer application!
Fetching whole month availability via API
We are currently building a custom calendar component that books directly into our client's Zoho Bookings instance. The challenge we are facing is that your API only allows fetching availability one day at a time, which is problematic. Our second workaround
Why "balance due" for the VOIDED INVOICE is not zero?
We wonder why the "balance due" for the VOIDED INVOICE is not zero? For example our case, we issued invoice for a client for MYR1000, then after client request for cancellation. Client haven't make payment yet. So we marked the invoice as void. We think
Format handling error
Hi, I'm having an issue when merging a document using a custom function when with decimal numbers. In my template preview, it's seems correct ,but when I do the merge and attach the file to a record, all types of docs aren't displaying the number correctly.
Announcing New Features in Trident for macOS (v.1.20.0)
Hello everyone! Trident for macOS is here with interesting features and enhancements to elevate your workplace communication and productivity. Let's take a quick look at them. Change the "From" email address easily. When composing or replying to an email,
we need to add a Customer Number field to the PDF document templates
Hello everyone. We are currently using Zoho Inventory for our small business operations and have found it to be a valuable tool. However, we’ve encountered a specific requirement: we need to add a Customer Number field to the PDF document templates (such
Announcing new features in Trident for Windows (v.1.27.6.0)
Hello Community, Trident for Windows is here with exciting new features to elevate your email communication. Let’s dive into what’s new! View and manage .pst files. A .pst (Personal Storage Table) file is an Outlook Data Storage file format for storing
Email limit reached
I'm assessing whether zoho crm will work for our startup, however I tried to send emails to my leads and after 12 emails got the notification that email limit has been reached. That is ridiculously low. Whats wrong and how can you fix that. I am still
Importing Into Zoho CRM
Do you have a list in Excel that you would like to import into Zoho CRM? If your administrator has not restricted your ability to import, the process is fairly easy to accomplish, but understanding the options can make everything go smoother. First you may need to prepare the spreadsheet Remove any extra rows from the top of the spreadsheet, like titles or blank lines. Row 1 should be the column headers. Row 2 should be where the data starts. Make sure that there is a column for any required fields
Agent working hours
Hi, I know it is possible to set company business hours but is it possible so that agents can have different ones? I.e. some agents cover later hours on specific weeks - can these be set so those agents that are "working" get notified about tickets etc.
Analyze the Name of the Deal Owner and Created by
I need to display the Name of the User who created a deal and the Deal Owner. Since both fields are lookups to the same table (Users), it defaults to the user record of the Deal Owner and I cannot display the name of who created it. I can generate the
Date Import Problems
I'm trying to import products from csv/xls files, but I can't get the Sales Start Date field to import. I know the import is working because all the other information is imported, but the Sales Start Date field is left empty. I think it must be a format
Canvas and Related lists
Hi, As much as I like canvas, when adding in a asection with related lists,it doesnt mimic the same functionality as the standard view within the CRM e.g left hand panel will show the module and total number of records. Is there a way of indicating this
Conditional Layouts On Multi Select Field
How we can use Conditional Layouts On Multi Select Field field? Please help.
New Search Function
Hey Team, The search function updated in our CRM about a week ago, so I assume it was an automated update across Zoho. It no longer displays leads/deals etc in Chronological order so that the most recently created or updated is the first to display which
Better integration between Zoho CRM and Zoho Bookings
I've noticed that when a meeting which was created in Zoho Bookings is updated by a sales person in Zoho CRM, the change is not reflected back into Zoho Bookings. I have raised this with support who advised that meetings created in Bookings need to be
Offline mode on Android TV app?
Hello! Is there a way to use Zoho Show offline in the Android TV app? I have an Android TV based projector, and I travel with it, and don't want to have to rely on a steady internet connection when giving a presentation.
Enhancements to Custom Connectors in Zoho Creator
Hello everyone, At Zoho Creator, we believe in providing you with the necessary tools to achieve a well connected ecosystem of apps. Our Custom Connectors feature is a testament to this, enabling you to integrate with a wide range of external services
issues with manually shipping sales orders - advise needed please
we are new to zoho inventory. we are going to roll the program out to our company within a couple of weeks and during the implementation process we have come into a roadblock with manually packaging and shipping sales orders. its important to note important
Problem with the "Search" function
Hi, I've been using Workdrive for a few days and lately, the files I added in Workdrive don't appear in the search. It looks like my latest files aren't indexed. Are you aware of this issue ?
Connect Woocommerce new order to zoho books via zoho flow
Hello i want help to create a flow to create a new sales order from woocommerce to zoho books. Can someone send me step by step flow, functions and fields?
[Webinar] Deluge Learning Series - AI-Powered Automation using Zoho Deluge and Gemini
We’re excited to invite you to an exclusive 1-hour webinar where we’ll demonstrate how to bring the power of Google’s Gemini AI into your Zoho ecosystem using Deluge scripting. Whether you're looking to automate data extraction from PDFs or dynamically
Getting error "invalid warehouse_id" when trying to update any transaction in Zoho books
I got a message from Zoho saying that the Warehouse and Branch has been merged into one category "Locations" Once I migrated to this setup I was no longer able to edit any invoice / create creadit notes - got an error saying "invalid warehouse_id" I never
customize payment page
Is there a way to customize, other than the theme colour, the payment page that customers are taken to from invoices? I can't seem to find a way. I just don't like the formatting of the current page and would like to make it look better. I've looked at
Delay function execute
I've got a workflow which uses a webhook to send information to Flow, which in return updates a record in Creator. Problem is, by the time this has executed, the rest of my script has run and can't find the (yet to be) updated info in the record. Is there
Return "kit_quantity" when fetching Kit items via "List all the items" API call
I have been appreciating the new Kits feature quite a bit, it is exactly what we were looking for in Zoho to solve many pain points. However, there is 1 problem I am running into and that is the fact there is no stock information that can be pulled for
Automating Pricing in Zoho Inventory Based on Brandline Quantity
I am currently setting up my Zoho Inventory system and would like to implement an automatic pricing feature for sales orders. We have created a custom field called "brandline" for our items. All products with the same brandline value should have the same
Tags with Zapier
Maybe I'm missing something....I hope so... Using tags for triggers is a key need. This prevents us from having a ton of different lists. I am trying to find out how to add a tag using zapier when someone makes a purchase....but it doesn't seem to be
Print & PDF Support for Composite items
There needs to be a way to print a composite item showing all the components, qty & images.
Build custom AI solutions with Catalyst’s QuickML capabilities in CRM
Hello everyone, We’re thrilled to announce an improvement for our Zoho CRM Enterprise users: the ability to create custom AI solutions using Catalyst’s QuickML directly from Zoho CRM. As you may already know, Zia, Zoho CRM’s AI-powered assistant, offers
Querying CloudSQL using NodeJS?
How can I query CloudSQL over nodejs? Are there any rest apis from which I perform Select Queries in the data of a Workspace? In the v1 we had C#, Python, Java for CloudSQL Now I only see Java? I am confused about the overall API of Analytics, there any
We cant create a custom function
More context, fewer tabs: View lookup modules' data within a CRM Canvas page
Hello everyone, How often do your users juggle multiple browser tabs just to piece together the full context of a record? This update can make their lives easier. You can now add lookup modules' fields to a Canvas detail view page and a Canvas list view
Next Page