Need information on Zoho Creator

Need information on Zoho Creator

Dear Team,

We are currently working on exploring no-code capabilities of Zoho Creator application for our organization.
Problem Statement:
1. We are currently maintaining Project Lifecycle Data on Google Sheets and different teams manually input data on Google Sheet which in turn generates report based on the entered data.
2. Data is maintained across multiple other systems such as an HRMS application, Financial Application, Google Drive, Project Management Tool, Sales Application and are not connected to each other.
3. High cost involved in building a custom application to address Pt 1 and Pt 2.

We worked on a POC on Zoho Creator but wanted to understand if points mentioned below are possible in Zoho Creator:
1. Custom API integration with other applications
2. Custom Development for example, if we want to run a python script to use any existing libraries in Python to generate reports, charts etc.
3. Workflow Automation
4. Access to Zoho Creator Database to plug into any existing Analytics Tool outside Zoho suite.

Also, wanted to understand the typical timelines to develop the application as defined in the Problem Statement along with budget and complexity involved in custom API integration and integration work?

It would be also useful to know the limitations of Zoho Creator so that we can keep in mind while planning for the overall architecture and scope of work.

Thanks,
Deepanjan Chowdhury
+91-9903521124