Transform google spreadsheet into a JSON API and use it as a data store in a matter of seconds. Create google spreadsheet, fill first row with column names, and the rest of data.
Grist might be a bit more popular than SheetDB. We know about 9 links to it since March 2021 and only 9 links to SheetDB. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Can you tell me how an app like https://sheetdb.io/? An app like that must send thousands of requests every minute. Source: over 2 years ago
What I would do is to use 'no code' methods here and some services like this https://sheetdb.io/ that connects me to google sheet. Source: almost 3 years ago
Good for you! I've actually read :) And for the future, you may get rid of the OAuth problems by using a third-party API. I recommend sheetdb.io. Here's a piece I wrote on this, you might find interesting: https://blog.sheetdb.io/google-spreadsheet-api-without-oauth-2-0-ffd572a06757. Source: about 3 years ago
Try using sheetdb.io - this app will handle your credentials in the background whereas you'll only need to disclose an endpoint in your script with an API key, but it's only to the particular spreadsheet to which you can set permission READ only, if you don't want to let others make any changes there. Source: about 3 years ago
There are many ways to do this these days. One way being uploading said file into google sheet, then use a service like https://sheetdb.io/ or https://sheety.co/ to turn it into an API. Boom, consumable REST API in seconds. Source: about 3 years ago
Grist Labs | Systems Engineer | Full-time | NYC OR REMOTE +/- 3hrs | https://getgrist.com We're looking for someone to make our modern spreadsheet software run everywhere. To apply, there's a puzzle. Just do:. - Source: Hacker News / 2 months ago
[Baserow], [APITable], [Grist], and [Rowy] are all open source Airtable alternatives which offer hosted SaaS versions that include API access, though it's a bit difficult to compare the API rate limits across all these products. Self-hosting an app like this would allow you to bypass API rate limits altogether, if you're open to it. All the above products can be self-hosted โ and you might want to look at [NocoDB]... - Source: Hacker News / 12 months ago
There's also Grist (https://getgrist.com) - SQLite based with Excel-like formulae in Python. - Source: Hacker News / about 1 year ago
The only things I have found are Baserow which is basically the best one I've found so far, but it doesn't allow search between columns, importing columns from other tables and I can't restrict users from editing and perhaps corrupting the data. NocoDB doesn't import CSVs and seems to be buggy for some reason. Grist allows restriction for people but it does not have as good filters as Baserow and I can't save my... Source: about 2 years ago
Phenomenal capabilities exceed Excel, Google Sheets, Airtable. Allows app-like views on spreadsheet data, with drag-n-drop configuration. Supports Python-based formulas with familiar Excel functions. Access rules allow sharing a single row or any subset of data. Open-source, and can be self-hosted. https://getgrist.com. Source: about 2 years ago
Sheety - Turn any Google sheet into an API instantly, for free. Power websites, apps, or whatever you like, all from a spreadsheet. Changes to your spreadsheet update your API in realtime. Neat
Airtable - Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
Sheetsu - Turn Google Spreadsheet into API
Rows - The spreadsheet where teams work faster
SheetBest - Turn a Google SpreadSheet into a JSON Database API
Coefficient.io - Automatically Sync Google Sheets with your Business Systems. No-code reporting and analysis tool.