We are excited to introduce a powerful new feature to our G-Integrator for HubSpot addon: “Incremental Update”. This enhancement is designed to optimize your data synchronization process, making it more efficient and reducing the time it takes to update your records.
Why This Feature Matters
Many of our clients manage large volumes of data within HubSpot, such as calls, emails, and other records that rarely change once created. Previously, each synchronization would require re-querying the entire dataset, which could be time-consuming and resource-intensive. This often led to automatic updates being terminated prematurely due to the Google Script engine’s 6-minute execution limit.
With the new “Incremental Update” feature, you can now synchronize only the records that have been created since the last query execution. This targeted approach significantly reduces the amount of data being processed, thereby decreasing the overall download time and ensuring your updates complete within the allowed time frame.
Benefits of Incremental Updates
- Faster Synchronizations: By only downloading new records, the synchronization process is much quicker, saving you valuable time.
- Reduced Resource Usage: Minimizing the amount of data processed reduces the strain on your system, leading to more efficient operations.
- Increased Reliability: Preventing automatic updates from being terminated ensures your data is always up-to-date without the need for manual intervention.
- Improved Performance: Streamlined data handling means you can focus on your core business activities without worrying about lengthy data synchronization processes.
Important Warnings
While the incremental update feature offers significant advantages, it is important to be aware of the following:
- Order By Conditions: If you have one or more “order by” conditions, the entire data set will be re-ordered during synchronization. This can take significant time if there are hundreds of thousands of records. Plan accordingly to avoid potential delays.
- Data Integrity: The query does not update or validate any existing data. If the existing data is changed manually, the result can be unpredictable. Ensure that your data remains consistent and avoid manual changes during the synchronization process to maintain accuracy.
- Unchanged Source Data: This feature works only if the source data in the HubSpot account are not changed. The addon will never re-download any existing data, so if they are changed in HubSpot, the sync will be lost. If you need to update existing data, you can temporarily uncheck the “Add New Records Only (Incremental Update)” option, manually re-synchronize the data, and then check it on again.
How to Use the Incremental Update Feature
Using this new feature is straightforward. Follow these steps to enable incremental updates in your G-Integrator for HubSpot addon:
- Access the Settings: Navigate to the “2. Change Pull Settings (optional)” tab in your download template
- Enable Incremental Update: Look for the option labeled “New Records Only (Incremental Update)” and toggle it on.
- Save and Sync: Save your settings and initiate a synchronization. The addon will now only query and add new records created after the last execution.
Real-World Applications
Imagine you have thousands of call records in HubSpot that are never modified once logged. With incremental updates, you no longer need to re-download all these calls every time you sync your data. Instead, the addon will quickly fetch only the new calls since the last update, drastically reducing the synchronization time and ensuring your data set is always current.
Feedback and Support
We believe this feature will greatly enhance your experience with G-Integrator for HubSpot, and we are eager to hear your feedback. Should you have any questions or need assistance, our support team is always here to help. Please contact us by email: support@g-integrator.com
Thank you for choosing G-Integrator for HubSpot. We are committed to continuously improving our tools to better serve your needs.
Happy integrating!
The G-Integrator Team