Exporting Company Information from HubSpot to Google Sheets
Andrea Alfaro
|
35 steps
|
2 minutes
HubSpot
Google Drive
Google Docs
1
Navigate to <https://app.hubspot.com/>
2
Click "Contacts"
3
Click "Companies"
4
Click "Advanced filters (0)"
5
Click "Add filter"
6
Type "Partner Success Owner"
7
Click "Partner Success Owner"
8
Click here.
9
Type in your name
10
Select yourself
11
Click "Apply filter"
12
Click "Close"
13
Click "Edit columns"
14
Click the "Search columns..." field.
15
Type "Street Address"
16
Click "Street Address"
17
Click the "Search columns..." field.
18
Type "City"
19
Select "City"
20
Click the "Search columns..." field.
21
Type "State"
22
Select "State"
23
Click the "Search columns..." field.
24
Type "Postal Code"
25
Select "Postal Code". Click the "Search columns..." field.
26
Type "Country"
27
Select "Country"
28
Click "Apply"
29
Click "Export"
30
Click "Export"
31
Navigate to [Google Drive](https://drive.google.com/drive/u/0/my-drive). Click "New"
32
Click "Google Sheets"
33
Navigate back to [HubSpot](https://app.hubspot.com/). Click in your notifications.
34
Click "Your export "All companies" has been delivered" and open the CSV file. Copy the data from the CSV file.
35
Navigate back to Google Sheets and paste the data into your new spreadsheet.
