Create a new file then click Connect Data. Select your database type in the Add data modal then enter in your credentials from Step 1.
3. Select Data
Now that your database is connected it’s time to select the exact data to import.
Lido has a visual data browser so you can point and click to select the exact data you want to connect. Use the dropdown menu in the upper left corner to change tables. Alternatively, you can write SQL directly by clicking the Custom tab.
Optional: Add filters to columns through these menus.
When you’re happy with your data in this view, click Add Data.
This creates a Table in Lido that is live one-way connected to your SQL database. Any changes in your database will be automatically reflected in Lido. However, you cannot edit this data in Lido and must do so in the original source.
Things you can do with your connected data
Once your SQL data has been imported into a Lido spreadsheet, you can work with it using normal spreadsheet formulas.
Clean and normalize data
For example, if your database only contains First Name and Last Name, but you need a column for Full Name, you can easily create one by adding a Computed Column.
Join multiple tables together
Your data is likely scattered across multiple tables in your database or even multiple sources (like Salesforce, Hubspot, or Google Analytics). Joining data
Send emails or Slack messages powered by your data
Want to import data from SQL databases to Google Sheets without needing to create a custom Google Apps script? Say no more! Lido offers a simple solution to seamlessly integrate data from multiple databases, including SQL, in just a few clicks. Click here to get started!