You can connect a HubSpot database to pull in real-time data from your database to Lido. After a table is added to Lido, it will stay updated automatically (no more copy/paste!)

Credentials

You’ll likely need one or multiple of the following credentials to connect a database to Lido:

• Hostname
• Port
• Username
• Password
• Database

Steps to connect a database

1. Click on the data button in the spreadsheet toolbar to open the data browser

1. Select the HubSpot option in the data modal

1. Enter your credentials

1. Choose your database table

   1. You can switch between different tables in the same database using the dropdown in the upper left corner

   

2. Select the columns you want to import

   1. Click on columns in the left side of the panel to select / deselect columns to import

   

3. Click Add Data to add a new data table to the spreadsheet

Editing and refreshing data after it’s been added