
The problem
Teams create and store their data across a range of disconnected tools, making it hard to connect that data or put it to work in automated workflows.

The vision
Spreadsheets are central to how teams work. They are a foundational part of office work culture. Lido’s early vision was to build off of this fact and operate as a low-code app builder that leverages spreadsheets, familiar scripts, and connected data to power DIY applications and automated workflows.
💡 Note: The product vision evolved during my time there and has changed since I left. The following work highlights our explorations; some launched, others were pushed off till later, and others were abandoned or de-prioritized cause of timing, constraints, or because they weren’t the right fit.

Connect & shape data
Connect data from other apps into Lido, join, and pivot data to help with analysis, and then leverage data in the dashboard, or use in automations.

Connect external data, then select columns to add
Select data columns to add to table. Preview to confirm structure and work with data load constraints before adding to document.

Quickly pull in meaningful API data
Explorations that never launched
We wanted to help people quickly ingest public data that could then be used to power specific analytical use cases. In this illustration, we explored the idea of creating an App Store for APIs within Lido. Each API would be labeled based on a core task it would perform and would include simple parameters to pull from either a spreadsheet or an input field.

Write scripts & trigger actions
We designed the experience to tap into the deep well of knowledge users bring to spreadsheet software like Sheets and Excel. We use that level of familiarity and comfort as a catalyst to inspire more advanced and new application and automation-building experiences.

Leverage familiar scripting languages from Excel and Sheets
Familiar methods to write scripts in-cell and in the script bar. Also, ways to bind input fields in the dashboards to ranges or cells in the spreadsheet.

Auto-generate scripts from plain language
Explorations that never launched.
The goal was to help users learn how to write Lido’s advanced scripts with the help of a no-code builder whizzy wig.

Dashboards used as applications
We focused a lot of energy and resources on the dashboard builder experience while I was there. The idea was that this would serve as the place where users would build shareable applications and where they triggered workflow automation. The team pivoted away from this emphasis after I left. There were significant eng hurdles involved, and it wasn’t the product differentiator we had imagined.


▲
2× team growth
during my tenure
▲
$5M funding
raised in refresh round
▲
Design system rolled out
enabled consistent UI and rapid iteration
