CRMConnect: Cliniko → HubSpot

version 1 22 or higher (current version 1 30) overview patient and contact sync frequency every 15 minutes limit up to 100 items per execution appointment sync frequency every 15 minutes limit up to 100 items per execution invoice sync frequency every 15 minutes limit up to 100 items per execution patient and contact updates to trigger an update, add or edit a record, such as updating the "extra information area " these updates will be processed during the next synchronization cycle, within 15 minutes ensuring data integrity the importance of maintaining established crmconnect configurations in hubspot when working with the cliniko groups and deals in hubspot, it is crucial to maintain the integrity and consistency of the existing pipeline stages and properties changes to these elements can have significant implications on data integrity, reporting accuracy, and the overall functionality of the crm system it is crucial that users do not alter or supplement the content created by crmconnect apiant cannot be held accountable for any data mismatches that result from modifications made by the end user to existing content key reason to avoid modifications the primary reason to avoid altering any properties, groups, pipelines, or stages within crmconnect is that these components are configured in very specific ways to ensure accurate data transfer from cliniko to hubspot any modifications to these elements can lead to incorrect data being populated, which disrupts the entire crm ecosystem the system's configurations are designed to support specific workflows and data integrity, and altering them could compromise the reliability and functionality of the crm integration implementing custom stages if additional stages are necessary for specific business needs, it is recommended to create a separate pipeline rather than modifying existing ones this allows for customization without disrupting the established processes and systems a separate pipeline ensures that custom stages are tailored to specific tasks or departments while preserving the integrity of the original system configuration resources for a detailed view of the properties used in the integration of cliniko and hubspot, please refer to our comprehensive list of custom properties available in the following spreadsheet crmconnect cliniko → hubspot / custom properties list spreadsheet link understanding the "individual appointments days forward" setting the cliniko to hubspot integration keeps appointment data synced between the two platforms the "individual appointments days forward" setting determines how many days into the future the system looks for new or updated appointments to sync, while also automatically checking the past 7 days for any recent changes how it works the system will always check for appointments from the last 7 days to capture any recent updates or changes it will also look ahead for new or updated appointments based on the value set in the "individual appointments days forward" field for example, if the setting is configured to 45 days, the system will check the past 7 days (for any recent updates) the next 45 days (for future appointments) this ensures that both recent and upcoming appointments are synced between cliniko and hubspot best practices set the number of future days based on your typical appointment scheduling needs if appointments are often booked far in advance, a higher value like 45 days ensures future appointments are captured and synced correctly contact support\@apiant com mailto\ support\@apiant com if you need to make changes to this setting using the preferred first name field from cliniko to update hubspot contact properties with the "preferred first name" field from cliniko, simply enable the corresponding setting in your crmconnect account's general settings once activated, the next synchronization of your patients and contacts will automatically update this field in hubspot understanding the "add amount to appointments" setting the cliniko to hubspot integration allows for financial data to be automatically included in appointment records the "add amount to appointments" setting enables the system to calculate and assign a monetary value to each appointment, which is then mapped to the "amount" property in the associated hubspot deal this value is determined using a formula that references specific mapped fields "price" from the "get billable item" action "rate" from the "get tax" action the formula calculates the total amount by applying the tax rate to the price and then adding the result back to the original price (price rate / 100) + price = deal amount this ensures that the final amount includes both the base cost of the billable item and any applicable tax, providing financial data within hubspot for each appointment note it is not recommended to enable this setting if you are already subscribed to sync cliniko invoice deals, as doing so may result in revenue being reflected twice in hubspot this feature is typically used by customers not subscribed to the invoice deal sync, as it allows a deal value to be associated with each appointment how to enable this feature in your crmconnect account how to export csv file from cliniko for initial patient record import to hubspot the criteria in cliniko that you want to use is up to you as far as which patients are included in your csv export step 1 step 2 how to export csv file from cliniko for historical appointment record import to hubspot the criteria in cliniko that you want to use is up to you as far as which appointments are included in your csv export step 1 email the csv in its exported format to support\@apiant com how to update a hubspot record to sync with a cliniko record maintaining synchronized records between hubspot and cliniko can enhance your data integrity and workflow efficiency this guide provides instructions on manually triggering a sync, as well as setting up automation via hubspot workflows overview of data flow data initially flows from cliniko to hubspot, setting up a base for your records although data can be sent from hubspot to cliniko, it requires a trigger since it is not automatic by default manual sync trigger locate the record navigate to the specific record in hubspot that you wish to sync with cliniko modify the property update the properties "update cliniko patient" and "update cliniko contact" to control the data sync to cliniko set the property value change these properties to 'yes' to initiate an instant sync this triggers the update or creation of records in cliniko update cliniko patient syncs patient information update cliniko contact updates contact details list of properties that are updated patient id, first name, last name, home phone, mobile phone, address line 1, city, state, postal code, country code, email, gender identity, date of birth, and referral source automating the sync process to automate the syncing process, utilize hubspot workflows configure a workflow to automatically change the "update cliniko patient" or "update cliniko contact" properties to 'yes' based on specific actions like form submissions or record updates this setup ensures continuous synchronization without manual intervention post sync property reset after the sync is complete, the integration automatically resets the "update cliniko patient" and "update cliniko contact" properties to 'no' this reset prevents repeated syncs unless a new update is made, maintaining efficient data management and preventing data duplication how to unlink cliniko and hubspot records when "patient 2" is linked to "patient 1" overview occasionally, a cliniko patient record (e g , patient 2 ) may incorrectly sync with an existing hubspot contact record (e g , patient 1 ) instead of creating a separate entry this guide explains how to unlink these records and ensure proper synchronization between cliniko and hubspot steps to unlink cliniko and hubspot records 1\ unlink the cliniko record from the hubspot contact to break the incorrect link between patient 2 (cliniko) and patient 1 (hubspot) access the hubspot contact record for patient 1 locate the property labeled "unlink cliniko patient" set the "unlink cliniko patient" property to yes outcome this action clears the link in the database in your apiant crmconnect account , removing the cliniko patient id and cliniko url associated with patient 1's hubspot record 2\ force an update from cliniko go to the patient 2 record in cliniko and trigger an update (e g , modify and save the record) the integration will now attempt to sync the updated information, creating a new contact for patient 2 in hubspot outcome a new contact record for patient 2 will appear in hubspot, separate from patient 1's record 3\ verify the new contact in hubspot, confirm that a new contact record for patient 2 has been created check that the new record includes the correct cliniko information 4\ clean up the original hubspot record (patient 1) open the original hubspot contact record for patient 1 review and remove any incorrect or outdated properties related to cliniko here are examples of properties that might need to be cleared, as they could contain data mistakenly associated with patient 2 5\ reassign deals or other associations (if applicable) if patient 1 has any deals or associations that should now belong to patient 2 , manually move these to the new contact record example if a deal was mistakenly linked to patient 1 , reassign it to patient 2 additional notes this process ensures that records are correctly split between patient 1 and patient 2 in both cliniko and hubspot regularly review hubspot and cliniko records for accuracy to prevent future sync issues support for cliniko patient cases with cliniko appointments hubspot deals in the cliniko appointments pipeline now include case information from cliniko