One of the easiest, most universally understood, and convenient ways to manage data is a spreadsheet. Whether it's Excel, Google Sheets, or Airtable, most of us know how to use and update a sheet, and some of us push the limits with formulas, charts, and integrations.
What if instead of "designing spreadsheets," we could abstract their data into usable public websites and apps... without coding?
In fact, there are several no-code tools that use third-party spreadsheets to power an app or website, and they're some of the easiest, yet most powerful ways to build products without code.
The cool thing about using spreadsheets is that data can be displayed, filtered, interacted with, and manipulated through the site or app itself, or using the original spreadsheet.
Here are a few popular no-code tools that use spreadsheets for their data, including links to real-world projects built with each.
If you're new to no-code, these are great tools to start out with, but if you're especially fond of spreadsheets, these may open a whole new world for you!
"Create an app from a Google Sheet in five minutes, for free."
$0, $19, or $199 per month
"Create a website from Google Sheets without writing code"
$0, $9.99, $19.99, or $99.99 per month
"Build websites with Airtable"
$0, $10, or $19 per month
"Build feature-rich applications from existing data sources"
$5, $10, or "contact them" per month
Built-in Spreadsheet APIs
Both Airtable and Google Sheets offer their data via API for custom-built websites and apps. Using these may require code, but not necessarily. For example, we can use Bubble or Thunkable to pull in data from the Airtable API, just by following some documentation.
No Code List (uses built-in Airtable API)
If the Google Sheets documentation is too much, you can look into Sheetsu, which creates a custom API from any Google Sheet.
Bonus: Pull any API into Google Sheets without code
API Connector from Mixed Analytics is a no-code Google Sheets add-on that lets you pull in data from any third-party API.
This means you can make a full no-code application that pulls in outside data, organizes it, and displays it on a website for people to interact with.
What did I miss? Let me know on Twitter!