Mar 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
We're excited to announce a new way to set up your flows. Instead of connecting to "sources" or "targets," your users can now connect to any available "connector" in the dashboard and run jobs both ways for that tenant.
Bi-directional flows are enabled by default for new users. Let us know if you're already using hotglue and want to try out these new flows.
Also released this past month, you can now create multiple connections to the same connector using "subtenants." This can be used for customers with multiple shops, or parent companies with multiple business entities.
You can turn on subtenants in the widget settings.
In February, our integrations team added new taps for Salesloft and Salesforce Commerce. Additionally, we added new targets for Clickup, Jira, Google Cloud SQL (Postgres), Blackbaud, and QLS.
We also released support for new triggers for Salesforce and Quickbooks
We also released improvements to the following connectors:
Taps: Sage 50 UK, Amazon Seller, Outreach, Montapacking, Salesforce Sandbox, Shopify, Zoho Books, Woocommerce, BigCommerce, Hubspot, BigCommerce
Targets: Xero, Quickbooks Desktop, Quickbooks Online, netoHQ, Snowflake
Outside of our new connectors, the team made several improvements including:
default
tenant jobsHere are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Feb 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
With the new tenant drawer, you can now access metadata, schedules, job history, snapshots, and more straight from the dashboard. This gives you fine-grained visibility into tenant configurations without having to touch the API.
We will use this in the future to offer detailed filters, sorting, and analytics on your catalog of tenants. Let us know what sort of metadata you'd like to filter and sort your tenants with!
In January, our integrations team added new taps for QLS, GoHighLevel, and Shiphero. Additionally, we added new targets for Gong, Pipedrive, Wix, and Quickbooks Desktop.
We also released support for new triggers for Pipedrive, Salesforce, and GoHighLevel.
We also released improvements to the following connectors:
Taps: Hubspot, Dynamics, Netsuite, Chargebee, Wix, Stripe, Google Sheets, Amazon Seller, Quickbooks, Dynamics, and plentymarkets
Targets: Mailchimp and Moosend
Outside of our new connectors, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Jan 1st 2023
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
Have a new integration you need for your product? Instead of building it yourself, you can use our connector roadmap to request it. We'll add it to our roadmap, and once it's built we'll reach out to you.
If the connector is already on our roadmap, you can use this page to upvote it and get it built faster!
In December, our integrations team added new taps for Google Analytics UA, Capsule CRM, Keap, FollowUpBoss, PowerBI, Montapacking, Fortnox, and Kustomer. Additionally, we added new targets for Quickbooks Sandbox, Odoo, and Montapacking.
We also released support for triggers for Shopify, CapsuleCRM, Keap, FollowUpBoss, Zendesk, and Pipedrive.
We also released improvements to the following connectors:
Taps: Intacct, Asana, Hubspot, Woocommerce, Xero, Chargebee, Amazon Seller, Plentymarkets
Targets: Shopify, NetSuite, Woocommerce
Outside of our new connectors, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Dec 1st 2022
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
The docs for unified schemas have a new home! You can now comb through the standardized data models for our most popular CRM, Accounting, and E-Commerce integrations.
Each table has a single schema, which you can use with the jobs endpoint to send data to any supported target via the hotglue unified API.
We are continuously expanding the connectors that support unified schemas – let us know what connectors you want to see on this page!
In November, our integrations team added new taps for Zoho Books, Clockify, MYOB, Quickbooks Desktop, and Close.io. Additionally, we added new targets for Magento, Bexio, Mailerlite, Zoho Books, and Microsoft SQL.
We also released support for triggers for Zoho CRM, Mailchimp, ActiveCampaign, and Close.io
We also released improvements to the following connectors:
Taps: Intacct, Hubspot, Amazon Seller, Shopify, Google Analytics, Open Exchange Rates, Quickbooks, Woocommerce, Google Cloud Storage, Chargebee, Salesforce, and ActiveCampaign
Targets: WooCommerce, BigQuery, and MySQL
Outside of our new connectors, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Nov 1st 2022
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
We have added the ability to enable and use our Unified Schemas for CRM, Accounting, and E-Commerce integrations directly inside the hotglue admin panel.
Simply enable the Unified Schema toggle in your source settings, and choose the relevant tables. All data will come through in our unified schema rather than the raw source schema.
We are working on expanding the connectors that support unified schemas and what tables we support – let us know if you are interested in using this feature!
In November, our integrations team added new taps for Copper, AgileCRM, Sellsy, PlentyMarkets. Additionally, we added a new unified schema target for Zoho.
We also released support for triggers for QuickBooks, Shopify, and WooCommerce
We also released improvements to the following connectors:
Taps: Salesforce, QuickBooks, Chargebee, HubSpot, Amazon Seller, CIN7, Google Analytics, SFTP
Targets: BigQuery, Snowflake, WooCommerce
Outside of our awesome redesign, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Oct 17th 2022
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
We have officially launched support for real-time triggers for several integrations, including: Salesforce, HubSpot, and Shopify. Triggers allow you to automatically run sync jobs when something happens in a source system. For example, as soon as a new contact is created in HubSpot or Salesforce, hotglue will receive a webhook on your behalf, and trigger a job.
We are rapidly expanding support based on demand – let us know if there are any you are interested in!
We have added support for allowing tenants to do simple mappings of their data in the widget. This works for both source flows, where you want tenants to map to your own data schema (for example, a tenant could map a custom Salesforce object to your Contact schema), and for target flows, where you want tenants to map their data in your product to a target.
To learn more or try this beta feature, reach out to us at hello@hotglue.xyz. Public documentation is coming soon!
While sync jobs run, hotglue will automatically track the number of records collected for every stream in real time. This allows you to have more visibility into a particular sync and its progress! This data is also made available via the API. See a sample below:
In September, our integrations team added new taps for FTP, MooSend, PostHog, MySQL, Jotform, and Sellsy. Additionally, we added new unified schema targets for MooSend, WooCommerce, ActiveCampaign, Sage Intacct, and Dynamics 365 Business Central.
We also released improvements to the following connectors:
Taps: HubSpot, NetSuite, Dynamics 365 Business Central, QuickBooks
Targets: BigQuery, NetSuite
Outside of our awesome redesign, the team made several improvements including:
Updated job metric graphs in environment dashboard. New graphs show failing jobs, record counts, and more!
Added new setup guide for new users, which includes videos and guides explaining hotglue concepts. You can always launch the setup guide via the Environment Settings.
Launched new landing pages describing our unified schema features!
Added ability to Clone Flows to other environments
Added ability to store a "snapshot" of reference data required for targets to optimize their runtime. Currently available for target NetSuite, and will be coming to other targets soon!
Updated notification emails for improved look & feel
Added option to allow tenants to trigger full sync jobs in the widget
Updated JupyterLab connections to use SSL
Made source catalog available during ETL runtime
General bug fixes and stability improvements
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Sep 1st 2022
Hi hotgluers!
Welcome to our monthly hotglue melt - we have got some awesome updates to share!
We have updated our scheduler for triggering jobs to handle the higher volume of scheduled jobs we are seeing.
Note: As a part of this change, we have moved away from AWS EventBridge cron expressions to standard UNIX cron expressions. You will receive email alerts if any of the cron expressions you are using cannot be automatically converted to the new format.
In August, our integrations team added new taps for Sage 50 UK, Dynamics 365 Finance & Operations, Mailstep, and Notion. Additionally, we added new unified schema targets for Dynamics 365 Sales and Shopify.
We also released improvements to the following connectors:
Taps: HubSpot, Google Analytics, WooCommerce, Magento, Chargebee, QuickBooks, and Prestashop
Targets: Salesforce, NetSuite
Outside of our awesome redesign, the team made several improvements including:
Updated billing functionality
Download Job service has been updated to allow you to download cached data from larger jobs (up to 20GB)
hotglue widget updates
HotGlue.link
functionAdded ability to retrigger failed jobs without rerunning the SYNC phase. This is mainly used for testing/updating ETL scripts.
The UI for refreshing field maps for taps has been updated:
General bug fixes and stability improvements
us-east-1
), but were able to avoid an extended outage by switching to the us-west-1
region. To stay updated on outages like this, subscribe to our status page updates.Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Aug 1st 2022
Hi hotgluers!
Welcome to our sixth hotglue melt - we have got some awesome updates to share!
We have updated our landing pages to more closely match our brand and explain the possible use-cases for hotglue. This includes an interactive preview of the new hotglue widget, more emphasis on the developer experience, updated graphics, and more. See a preview below:
In July, our integrations team focused on expanding our unified schemas and library of targets (integrations that push data to other platforms). Notably we have released new versions of targets that use the unified schemas: Salesforce, HubSpot, Xero, and NetSuite.
Additionally, we have released new Magento v1, Wix, GitHub, and Stripe taps that feature better performance and data models. We also released improvements to the Facebook Ads, Amazon Seller, Prestashop, Chargebee, HubSpot, Magento, and Zendesk taps.
Outside of our awesome redesign, the team made several improvements including:
Added support for the gluestick to_singer function to enhance support for typing and setting primary keys when pushing data to targets
Added support for using both etl.py
and etl.ipynb
formats for ETL scripts
@hotglue/widget package updates
Added command to delete deployed ETL scripts to hotglue CLI
Fixed timeout issues when downloading long job logs
Added optional upsert option to toggle sync schedule endpoint to apply default schedule to all tenants
General bug fixes and stability improvements
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Jul 1st 2022
Hi hotgluers!
Welcome to our fifth hotglue melt - we have got some awesome updates to share!
In June we welcomed Davi, an awesome full stack engineer, to our team! We are super pumped to have him join us and help the product reach the next level.
We have released the new hotglue widget as an npm package to make the setup process more streamlined. Part of this change includes a totally overhauled Connections
React component, an inline version of the hotglue widget. The goal of the Connections
component is to allow for a more native user experience for tenants. See an example below:
You can learn more about the widget, React component, and the new installation process in the docs: https://docs.hotglue.com/docs/embed-hotglue
Note: The old Connections
component was previously available in the now deprecated hotglue-elements package.
As mentioned in our last update, one of our goals this month was to revamp the Google Sheets integration. We have vastly simplified the user experience for tenants that are connecting their Google Sheets. Beyond that, the new version of the integration also reduces the amount of setup required.
The new Google Sheets integration is already available for use, and we would love any feedback or suggestions you have! Feel free to reach out at hello@hotglue.xyz
As usual, our integrations team added more integrations – notable ones include Google Workspace, Fishbowl Inventory, Gong, Delighted, Google Play Store, Front, Metronome, and iTunes Connect. We also released improvements to the HubSpot, WooCommerce, Salesforce, Iterable, Chargebee, Snowflake, and more.
Outside of our awesome redesign, the team made several improvements including:
Resolved issues with downloading large jobs directly from the hotglue admin panel!
Improvements to job logging:
error
field to the job details returned from the API including the summary log of why the job failedAdded the option to enable a Job History tab in the widget, so tenants have visibility into the sync jobs that have run. See below:
Added PATCH endpoint to allow updating the tenant config. Read more in the docs
Added revoke
parameter to DELETE tenant endpoint which deauthorizes any active OAuth connections before deleting the tenant. Read more in the docs
You can now choose a color to easily identify your hotglue environments in the admin panel, and update their names.
Enabled ability to override the default scopes for the HubSpot connectors in the admin panel
General bug fixes and stability improvements
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Jun 1st 2022
Hi hotgluers!
Welcome to our fourth hotglue melt - we have got some awesome updates to share!
As some of you may know, the hotglue team is fully remote with members from the United States, Brazil, Pakistan, and the Philippines. We recently had our first company meetup in São Paulo, Brazil – home to our amazing frontend engineer, Breno!
We wanted to share our first team picture (with everyone wearing their new hotglue swag 😎) from the trip with all of you. None of this would be possible without your support, and we are excited to continue our mission to make building native integrations simpler.
As mentioned in our last update, our product team has been hard at work on a new version of the hotglue widget. Our goals were to radically enhance the UI to give a more intuitive experience for users and deliver a polished interface. Beyond that, we are focusing on increasing the customizability of the widget so you have more control over your users integration experience.
The new widget is already available for use! You can learn how to upgrade on our docs.
We would love any feedback and suggestions you have! Feel free to reach out at at hello@hotglue.xyz
As usual, our integrations team added more integrations – notable ones include SKUVault, SFTP Files, and Zendesk. We also released improvements to the Amazon Seller, Chargebee, Magento, Unleashed, Bexio, Pipedrive, HubSpot Beta, and Fulfil integrations.
Note: We are advising all users of our HubSpot integration to upgrade to our new connector (labeled HubSpot (B) in the hotglue UI). The new connector features performance improvements and a data model that is much easier to work with. If you have any questions, please reach out to us!
Outside of our awesome redesign, the team made several improvements including:
hotglue now integrates with Datadog! You can configure hotglue to push job events (success or failures) directly to your Datadog events to maintain observability in one platform. Learn more in the docs.
We have developed an improved SFTP integration (called SFTP Files), allows users to browse their SFTP server and select the files/directories they want to clone! See a preview below:
You can now use your own S3 buckets to cache job data and snapshots! If you're interested in trying this feature, contact us to help you get it setup :)
Here are some things to look forward to in the next updates:
Improvements to our embeddable UI
Improved Google Sheets integration
Unified schemas
Audit trail for sub-users
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
May 1st 2022
Hi hotgluers!
Welcome to our third hotglue melt - we have got some awesome updates for you all.
Our product team is extremely excited to launch a redesign of the hotglue admin panel! The goal of the redesign was to create a more polished UI with a more intuitive UX. We would love feedback from users as they try it out!
In April, our integrations team added a whopping 27 new integrations! The most notable are:
Outside of our awesome redesign, the team made several improvements including:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Apr 25th 2022
Hi hotgluers!
Welcome to our second hotglue melt - we have got some awesome updates for you all.
In March, we received our official SOC 2 Type II certification! Data security and privacy is an essential component of our dedication to upholding our promise to protect sensitive user data. As we continue to grow as a company, our commitment to security remains steadfast.
Last month, we added 7 new integrations! The most notable are our new Bexio, Amazon Seller, and Freshsales integrations. We've also released updates for our NetSuite, Chargebee, Zoho, and Prestashop integrations, among others.
The product team did some amazing work during March. Here is what they did:
Here are some things to look forward to in the next updates:
If you have anything you would like hotglue to focus on in the near future, you can send us suggestions at hello@hotglue.xyz.
See you next month! 👋
Mar 1st 2022
Hey hotgluers! Here are the updates:
We have a lot of new fantastic features and improvements that we rolled out this month. Here they are:
We also have 22 new integrations 🎉
Integration updates and bug fixes
Stay tuned for more updates next time 🍻
Jan 14th 2022
Happy Friday hotgluers! Here are the updates:
You can now secure your account by enabling Multi-Factor Authentication in your Account Settings 🚀
Added filter to query exclusively for scheduled
jobs
HubSpot target now supports calling discover to get available objects/fields (similar to sources)
New endpoint for creating/updating a tenant config, which is available during runtime of transformation scripts
Bug fixes
GET /tenants
endpoint timeout issue resolved and performance improvedonTargetLinked
correctly – was causing issues in hotglue-elementsNew integrations have arrived 🎉
Integration updates and bug fixes
start_date
formatting for querying users
dataexchange_rate
from credit notescustomer
in journal entriesinventory_level
contacts
dataStay tuned for more updates next time 🍻
Dec 31st 2021
Happy Friday and Happy New Year hotgluers! Here are the updates:
You can now modify your notification preferences! Toggle updates on environment creation and scheduled job failures under Account Settings 🚀
Added count
query param to get jobs endpoint to allow retrieving full job history
Bug fixes
state.json
files from being used by future jobs (discovered with tap-klaviyo)New integrations have arrived
engagements
and contacts
to HubSpotIntegration updates and bug fixes
tap-netsuite
bug fixes:
Item
rate schema fixedtap-sftpnow supports delete_after_sync
option which automatically purges files from remote server after sync is completed
tap-shopifynow supports pulling shop
data and orders in transit
target-netsuite
updates:
subsidiary
fieldtarget-intacctissues with case sensitive posting type and rounding errors fixed
target-shopifynow supports updating inventory_level
Stay tuned for more updates next time 🍻
Dec 17th 2021
Happy Friday hotgluers! Here are the updates:
You can now invite your team members to join your hotglue organization! Find this option under Account Settings 🚀
Secret API Key is now available under your environment settings. Note: any requests from your backend should now be done using the secret API key, not the public API key.
Bug fixes
JOB_CREATED
) are automatically handledNew integrations have arrived
Integration updates and bug fixes
campaign_budget
and invoices
TooManyFilesError
org
parameter rather than full domain
ListView
data in memory during executioninvoices
department
and location
fieldsdepartment
and location
fieldsinventory_level
Stay tuned for more updates next time 🍻
Dec 3rd 2021
Happy Friday hotgluers! Here are the updates:
Added ability to run multiple target jobs for one user concurrently! 🚀
New integrations have arrived
tasks
directly to Salesforce!products
directly to WooCommerce!Integration updates and bug fixes
Stay tuned for more updates next time 🍻
Nov 19th 2021
Happy Friday hotgluers! Here are the updates:
Added automatic validation of tokens for API-based sources in the widget. Beta support is now available for Mailshake and ActiveCampaign 🚀
New version of hotglue-elements (0.0.15
) with support for target flows
Added new widget options:
HotGlue.link
Updated the demo on our landing page!
New integrations have arrived
Integration updates and bug fixes
Added new listeners to the widget
onTargetUnlinked
onWidgetOpen
Stay tuned for more updates next time 🍻
Nov 5th 2021
Happy Friday hotgluers! Here are the updates:
Revamped job logs view, designed to handle longer job logs 🎉
Added setting to automatically enable default sync schedule when tenants link a source
Fixed bug with OAuth target settings not working
Added support for tap Statflo – currently supports pulling Customer Activity
Added support for target Shopify – currently supports pushing products
Updated tap-intacct to dynamically pull and use available fields
Fixed bug in tap-mixpanel causing errors when pulling cohort_members
Fixed bug in tap-blackbaud causing errors due to a dependency mismatch
Stay tuned for more updates next time 🍻
Oct 22nd 2021
Happy Friday hotgluers! Here are the updates:
state.json
of sources via APIARINVOICE
, ARADJUSTMENT
, CUSTOMER
, and ITEM
education
, lifetime giving
, and fundraiser assignment
Stay tuned for more updates next time 🍻
Oct 1st 2021
Happy Friday hotgluers! Here are the updates:
Added support for tap Mixpaneland SFTP 🎉 – docs coming soon 📖
Added support for targetMySQL
Restructured the Flow details page to be more intuitive
Improved tenant search functionality
Enabled passing state
data directly from hotglue API to a job
Fixed issue with clearing webhook settings in environment settings page
Fixed bugs with modifying sync schedules in job sync schedule page
Fixed error when starting multiple Jupyter workspaces for the same flow
hotglue-elements
version
0.0.14
released 🚀
Connections
componentStay tuned for more updates next time 🍻
Sep 15th 2021
Happy Wednesday hotgluers! Here are this week's updates:
currency_code
Stay tuned for more updates next week 🍻
Aug 6th 2021
Happy Friday hotgluers! Here are this week's updates:
Added support for tap Mailchimp and PagerDuty 🎉 – docs coming soon 📖
Fixed issues when loading JupyterLab workspace from hotglue panel
hotglue widget now validates that required fields for API sources are filled (such as tap NetSuite and Chargebe)
Fixed bug on target Intacct that caused issues when a Currency
was passed to a Journal entry
Fixed bug that allowed users to open errored environments
Updated field map interface to use the catalog for the selected tenant
hotglue-elements
version
0.0.13
released 🚀
styleOverrides
directly to the Connections
componentStay tuned for more updates next week 🍻
Jul 28th 2021
Hey hotgluers! We've been super busy over the last few weeks, and we're excited to share our updates!
Recipes 👩🍳
Many users have benefited from having a starting point when creating a new integration. To that end, we're excited to announce a brand new recipes feature!
When you head into the settings page for certain sources, you'll find a new recipes section which allows you to use one of our prebuilt configurations. Currently, recipes include pulling contacts and contact lists from CRMs like Salesforce, and pulling tickets/issues from systems like Asana and GitHub.
You can check out a short demo of this feature below!
Outside of that, here are all the updates:
HackerNews launch with open sign up
Recipes for CRMs (Salesforce, HubSpot) and Issue Systems (GitHub, GitLab), with more coming! 👩🍳
Major UX overhaul including:
Updated field map interface with performance improvements and emphasis on search
Sources page is now segmented into specific categories, and has many performance improvements
Added support for tap GitHub and ActiveCampaign 🎉 – with many more integrations on the way
Bug fixes on target Xero
Updated onboarding process for new users
Stay tuned for more updates next week! 🍻
Jul 9th 2021
Happy Friday hotgluers! Here are this week's updates:
Added support for target Airtable 🎉 – you can now push data directly to an Airtable base/table. Check out the open source Singer target on GitHub
Added support for tap Google Sheets – you can now sync data from a Google Sheet! Docs coming soon 📖
Added support for variables in the dataset IDfor target BigQuery – similar to path prefixes in target S3/Cloud Storage/Blob Storage (ex. {tenant_id}
, {flow_id}
)
hotglue-elements
version
0.0.11
released 🚀
onPopupClose
and onWidgetClose
Fixed bug where failing to link a testing OAuth source in the admin panel showed the error as [Object] object
instead of displaying the real error
Fixed wrong API error code being sent (500
instead of 400
) on BadRequest
Stay tuned for more updates next week 🍻
Jul 2nd 2021
Happy Friday hotgluers! 🚀
This week we've got a few updates to share:
preload
option in hotglue widgetStay tuned for more updates coming in the next few weeks! 🍻
Jun 25th 2021
Happy Friday hotgluers!
I'd love to share some improvements made over the last week:
client_secret
configuration for a source)hotglue-elements
on some browsers where the React element didn't wait for the hotglue widget to be present in the DOM before mountingproject_id
metadata in each substreamJun 15th 2021
Happy Tuesday hotgluers!
We're making an effort to be more transparent with our users regarding changes to the product and how things are going at hotglue!
To that end, I'd love to share some improvements made over the last week:
API
sourcescompanies_properties
catalog.json
, fieldMap.json
)Stay tuned for more updates soon! 🚀