Dear friends, in a couple of recent weeks we’ve got feedback from you about Deals data download. In particular, you correctly complained that current limit for the downloaded records number (2,000) is too small and that there is no way to filter deals before download.
And we listen to you. Unfortunately, there are technical limitations in Google Sheets and Hubspot, which do not allow us to download more deals. However there is a workaround, and we are working on it right now – estimated time of delivery is 3-4 weeks. Filters also will be added, maybe slightly later.
In the meantime, we have added two new types of deals to download, as a partial solution to this problem. These types are:
Deals Recently Created
Deals Recently Modified
Both types will return deals for the last 30 days, up to 2,000 records. Later, we will add the possibility to return deals created after a particular timestamp (but it still should be less than 30 days ago – Hubspot limitation). Also, there are plans to combine all three data types: Deals, Deals Recently Created, and Deals Recently Modified into one (actually, it is one type, but there are three different ways to get it in Hubspot). Please stay tuned.
Please send us your feedback! We are good programmers, but it is YOU who knows the business, so, please, let us know what you need! We are a small startup with limited resources, so we need you to set up the priorities in our backlog: we cannot do everything simultaneously.
We are very excited to announce, that we have added new functionality to our Hubspot application: data upload.
Currently, it works for following tables:
More are on the way.
Please see video demonstration:
Or you can go through the steps below:
In the Google spreadsheet, create data to upload. You can download existing data from the Hubspot, import it from another application, or just create it manually. The first line should be the fields names. Better (but not mandatory), if it will be same, as field names in the Hubspot table. Select data you want to upload.
In G-Accon menu, click “Update / Insert Selected Row(s)”
Select table to upload to:
After selection, matched Hubspot fields will be mapped automatically. Non-matched will be left blank:
To match it, drug and drop the Hubspot field from the list of updatable fields. After this, check “Use” checkbox:
Click “Go” button.
You will receive the error message because the selected operation is “Update” and you do not have an ID field in your data.
Select “Insert” and click “Go” again.
This time data will be uploaded. You will see upload results in the columns to the right of your dataset. As you can see, one record has been uploaded, and another had received the Hubspot validation error because a wrong value in the “type” column.
Change the value in the “type” column to “PROSPECT”, select two first rows and upload again. This time it will be uploaded.
Over the past few weeks, we have added a lot of improvements to the Hubspot plugin. We hope, that these changes will make the plugin more usable:
Separate logins for free and premium Hubspot users.
Hubspot gives different access to its API to a different type of users. To utilize this, we have created two login screens, one for free user, and another for premium one. If you are not sure, what type is yours, try premium first. If you have received the error message: “This hub doesn’t have access to some HubSpot features that are required by this integration. Please contact the integrator“, this means you should go to the free user.
New tables added for download.
Currently, for free user, following tables available:
Premium users, on the top of it, will also have:
Increased number of the downloaded records.
We have increased the maximum of downloaded records to 2,500 from 200 in the previous version. At this time, we are investigating Spreadsheets and Hubspot API limitations to be able to download even more records.
We significantly improved performance for the record downloading. While there are no miracles and we are restricted by the both Google Spreadsheets and Hubspot API speed, we made all efforts to effectively deliver a big number of records.