Connect to a Google Sheet

Learn how to connect your Google Sheets data to Lido.

Suggest Edits

Lido makes it easy to build apps with Google Sheets data.

Step 1: Enter a Google Sheets URL

Step 2: Choose a worksheet

Step 3: Choose an import range

By default, Lido starts from cell A1 in your selected sheet, searches for data, and pulls in the first contiguous range of data that it sees. However, you can also specify a custom start and end point to import.

📘

Column headers

If your selected data range has column headers that you want to import, make sure you include the column header row in your selected range.

Formatting your Google Sheet

If your data isn't appearing as expected, chances are that you just need to reformat your Google Sheet to work with Lido's integration:

  1. The first row of your data range should be your column headers
    1. Column headers cannot be blank, contain special characters or line breaks
  2. Remove empty rows and columns
    1. Individual cells inside of the selected range can be blank, but a completely empty row or column will "stop" the range of data that's fetched
  3. Un-merge any merged cells that you want to connect
    1. Merged rows and columns are unsupported

🚧

Changing column or worksheet names in your Google Sheet will break their connection with Lido

If you're missing columns or data, click edit data in your dataset then re-add the missing columns in the data browser.

Troubleshooting

Common errors when connecting a Google Sheet and how to solve them.

Unsupported file format (XLSX, CSV, ODS, TSV)

This error occurs when you upload a .XLSX, .CSV, .ODS, or .TSV file to your Google Drive, open it directly from Google Drive, and then try to paste that link into Lido.

To fix this error, simply save your file as a Google Sheet first, and then use that new URL for your connection.

Updated 5 months ago