Import Excel from email into CRM

Import Excel from email into CRM

I receive a daily Excel file by email and I would like to have it automatically imported into a custom Zoho CRM module. Do you think there's anything that can be done?

My first idea was searching for a native option in CRM, such as "send an email to a special address and any attached excel will be imported". It doesn't seem to exist.

Another idea was doing it through Zoho Flow, having a flow that takes an Excel file as input and imports it into CRM. However, I don't see any action in Flow to import a file into CRM. Perhaps reading the Excel row by row and creating records, but I didn't see a clear way of doing that.

I've looked into Dataprep but there seems to be no way that you can trigger a Dataprep pipeline from an email. In fact, the only suggestions I have seen involve using Zoho Flow to automatically run Dataprep, and my attempts to implement that, following some instructions, didn't work.

Is there any way that I could import an Excel into Zoho CRM without manual intervention? Thanks.
    • Sticky Posts

    • Free Webinar - Digital signatures for digital contract management with Zoho CRM

      Hi, Did you know you can seamlessly send and collect signatures on important business documents like business proposals, vendor agreements, sales contracts, invoices, and other inventory documents with Zoho Sign’s extension for Zoho CRM? Join our upcoming
    • New User Interface for your Email integration in Zoho CRM

      Hello folks,  As most of you may already know, Zoho Mail recently got a new user interface that's a lot better and easier to use. As a result, this change will affect your email integration with your Zoho CRM account**.  If you have your email integration in Zoho CRM set up through POP, your Emails UI in CRM will be moved to the new Zoho Mail UI. We hope that you like the new and improved Emails interface inside Zoho CRM. Feel free to share your feedback by commenting below.  **Please note that,
    • Fetching leads from Zoho CRM into Zoho Creator, automatically

      I'd like to pull new leads from the CRM system, into Creator, on a daily basis. Is this possible?   Yes, it is possible. Zoho Creator and Zoho CRM are integrated with each other, enabling you to synchronize data between them. This is done by fetching records from CRM into a Zoho Creator form. In order to achieve this, you'll have to configure a workflow alert in Zoho CRM.  For instance, you can maintain the lead details in CRM on a separate form in Zoho Creator by fetching the details automatically