MongoDB AppiWorks
Interact with MongoDB directly from Zoho CRM
What is MongoDB AppiWorks?
MongoDB AppiWorks for Zoho CRM is a Zoho CRM extension that integrates Zoho CRM and MongoDB. It helps users to export data from Zoho CRM to MongoDB, import data from MongoDB to Zoho CRM and show contextual data from MongoDB inside Zoho CRM.
Why do you need it?
If you are looking at integrating Zoho CRM with MongoDB and getting your processes automated, look no further. MongoDB AppiWorks for Zoho CRM covers you fully.
How does it work?
See the demo video on how to use MongoDB AppiWorks for Zoho CRM
Key Features
✅ Auto Interaction: Automatically insert records into MongoDB when a new contact/ lead or any record in a Zoho CRM module is created or Updated.
✅ On Demand Interaction: Insert records into MongoDB on selected contacts/ leads or any records in a Zoho CRM module.
✅ Bulk Import: Import data from MongoDB directly into Zoho CRM with a guided setup.
✅ View Contextual data: Show related data from MongoDB inside Zoho CRM module GUI
✅ Configurable Services: A fully configurable automation that lets you take control of your integration and automation needs between Zoho CRM and MongoDB.
Sample Use Cases
► Insert a new record into your database when a new lead/contact is created on Zoho CRM
► Export 200 selected contacts from Zoho CRM into the MongoDB
► Import contacts/Leads from the MongoDB into Zoho CRM Contacts/Leads modules.
► View related data from a homegrown system (that uses MongoDB)
Read more Articles on MongoDB AppiWorks for Zoho CRM
Installation
Go to Zoho Marketplace
Search for MongoDB AppiWorks
Click on the Install Now.
It will open a dialog to agree with the terms of services of the vendor and Zoho Marketplace and the privacy policy of the vendor.
The users need to agree with that and then click on continue.
Select your Users/Profiles (Select the profile to whom this extension is to be visible, based on the profile selection the extension will be displayed to users) and then click on Confirm.
Extension Installation is completed and added to your Zoho CRM and you will also get a confirmation email from Zoho Marketplace.
Setup
After installation is successful, Sign in to Zoho CRM and click on the three dots (...) symbol (shown right side).
Select/ Search for MongoDB AppiWorks
You will now be redirected to MongoDB AppiWorks homepage/landing page.
Please wait for AppiWorks basic initialization or until the START AUTOMATING button is enabled.
Click on START AUTOMATING.
It will redirect you to the Service listing page where you can see all your services.
Here Click on + Create to create the new service.
Give a name to your automation service.
Choose the Automation type
Click on Next
Choose a Zoho CRM module.
Click on Next to establish and configure mongoDB Coneection.
Establishing and maintaining MongoDB connection :
In order to Establish MongoDB Connection you can either choose from an existing connection Or Create a new one.
Creating a new MongoDB Connection :
click on the plus icon associated with the connection field.
There are two types of authentication, either through a direct URL or by providing all required credentials.
Click on Connect.
Once the connection is successfully established, choose an object or collection in mongoDB database, from the list of collections/objects that are available.
Next select the appropriate action from the action selection field and finally click on Next button to move on to the next section, which is mapping.
*Mapping is required for import/export automation types.
Configure the mapping section.
While some fields are intelligently mapped, the remaining can be mapped manually.
Click on Next
Finally Save the service.
How to create an Export service?
Choose the Connection Or Create a new connection.
Choose an Object/ Sheet from MongoDB
Choose the Action.
Click on Next
Mapping Configuration: *Mapping is required for import/export automation types.
While some fields are intelligently mapped, the remaining can be mapped manually.
Click on the + Add button to create a new mapping between the Zoho module & MongoDB object/ table.
Click the icon next to + Add for the Intelligent/ Automatic mapping.
Click on Next
Choose an App Field.
Choose the mapping type.
Choose the Source field (selected Zoho CRM module fields).
Template mapping type supports multiple field insertions with a message (see eg. on the right side)
You can add multiple fields by clicking on three dots symbol for the templated type (shown on the right side)
Click on Add to add the mapping
Switch on [ ] new [ ] edit checkboxes, if you want to trigger the export automatically on the creation of the new record, or edit of a record.
Switch on the Allow Manual Execution if you want to export inside the Zoho CRM module page.
Activate the service by switching on the final switch. Otherwise, the service will not get executed.
Click on the Save button to save the service in your workspace.
Now, this service is listed on the services list page and ready for automation.
You can create as many services as you want.
Go to the services list page by clicking on the Previous Page button.
Notes:
Service execution will happen in two ways. Automatic and Manual (based on whether automatic and manual triggers are enabled or not).
Service required to be active for either Automatic or manual execution.
Automatic execution will happen when the user either creates or edits a record for that module configured in that service.
Manual execution is done through a custom button MongoDB AppiWorks located in that module configured with service by selecting records or editing/creation page.
How to execute export service manually?
In manual execution, you can execute services for multiple records.
Go to the Zoho CRM module tab (eg. Contacts).
Select the records and click on the MongoDB AppiWorks button.
Services created for the module and enabled for manual execution are listed on the MongoDB AppiWorks manual tab.
Click on the corresponding service Execute button to execute the service for the selected records.
After the execution of the service, the execution response will be embedded below the service.
Please see right side image carousel for a glance at manual execution.
How to create an Import service?
Go to the Setup section above and follow those steps and get back here.
Choose the Automation type as Import
Choose the Connection Or Create a new connection.
Choose an Object/ sheet from MongoDB.
Click on Next
Do the mapping between the Zoho module and MongoDB object/ Table fields.
For the steps, you can follow the same steps as mentioned for the export service in the above section.
Click on Next
Setup the Query Filter (If applied it will bring only filtered records from MongoDB Server, else it will bring all the rows)
Click on the (+) button to add the query filters. You can add multiple filters.
Choose the App Field and Operator.
Enter the value to be matched.
Click on the Query button to see the results.
Choose the rows from the table to import.
You can also choose the columns to see on the table.
It will show you the number of records selected for the import.
Click on Next
Click on the Import Now button to Import into the Zoho CRM.
You can see the import execution status after import.
Activate the service
Click on the Save button to save the service for future use.
How to create a View service?
Go to the Setup section above and follow those steps and get back here.
Choose the Automation type as View.
Choose the Connection Or Create a new connection.
Choose an Object/ Sheet from MongoDB.
Click on Next
Setup the Connecting filters (connecting filters is basically a hook between the Zoho CRM module & MongoDB)
Click on the (+) button to add the connecting filters. You can add multiple filters.
Choose the App Field, Operator & Zoho Field.
Click on Next & Save the service.
Go to the Zoho module tab on which you have created the view service in the first step of service configuration.
For eg. Here in this demo, we have chosen the Zoho CRM contacts module. So we will go to the Contacts tab in the Zoho CRM dashboard.
Click on any record (in this case, any contact).
Scroll down to the end, and you can see the MongoDB AppiWorks widget.
You will see all the services configured for the corresponding module (here Contacts)
Click on the service to see the results
How to achieve Auto export for the Custom Modules in MongoDB AppiWorks?
If you want to automatically export the content of your custom modules to MongoDB, you will need to configure Zoho CRM automation workflow rules and create custom function to trigger AppiWorks. Please follow the instructions below.
Step 1: Configure automation workflow rule
Log in to your Zoho CRM account using your credentials.
Click on the "Settings" icon (gear icon) in the upper-right corner.
Under "Setup," select "Automation."
In the Automation section, click on "Workflow Rules."
Click the "Create Rule" button to create a new workflow rule.
Give your rule a name and description for reference.
Choose the custom module you want to apply the rule to from the "Module" dropdown.
Choose when the rule should be evaluated. If you require the workflow to trigger for both create and edit then choose as shown on the right side.
Specify what actions should occur when the rule criteria are met. Here choose Function as an action.
Step 2: Configure a new Function to trigger AppiWorks
Configure the Function, and choose the "Write your own" option.
Give the function name and display name as written below.
Function Name: triggerMongoDBAppiWorksForCustomModule
Display Name:
Trigger MOngoDB AppiWorks For Custom Module
As you can see on the right side, add the below line in the script editor.
mongodbappiworksforzohocrm.invokeExecuteServicesEndpoint(moduleId,id);
Step 3: Setup Argument mapping to your Custom Module
Click on Edit Arguments
Do the argument mapping, and provide your custom module API name as moduleId and dynamic record ID field for your custom module.
Save your arguments changes
Save the custom function.
Save your workflow rule.
Step 4: Configure an Export type service on your Custom Module
Finally, configure an export-type service in MongoDB AppiWorks for your Custom Module with relevant field mapping. Refer to the above section on configuring export service. The workflow rule will be triggered on creating or editing a record in the Configured custom module.
Test it and roll it out to widespread usage 🚀