A database that you can query with a spreadsheet!
Start new thread
Chris Switalski

SheetDB 3.0 - Turn a Google Spreadsheet into a JSON API

by
•
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.

Add a comment

Replies

Best
Chris Switalski
Maker
Hi Product Hunters! For those unfamiliar, SheetDB is the tool that will turn your sheets into a JSON API, easy to integrate with other tools and all programming languages. We have prepared many libraries working with common tools, other APIs and programming languages. It's been 3.5 years since SheetDB has been on the market. During this time, we have changed a lot for you, added plenty of new features and helped you with custom integrations. We are proud to process millions of your requests every day. Thanks to your valuable feedback we have learned a lot. Here is a list of the biggest changes in version 3.0: - brand new design - handlebars snippet to use your spreadsheet data in plain HTML - improved cache for faster responses - changed the server infrastructure so that they never let you down - brand new attributes for filtering and data searching - and many more… I can’t wait to see what you think about the new version of SheetDB. As always, I’d love your feedback! Cheers, Chris Switalski
Jacob Mhun
@chris_switalski congrats on the submission! By the way, how is it different/better than https://www.sheet2site.com ?
Chris Switalski
Maker
@swissdevjobs Thanks for showing it, I didn't know sheet2site.com before, it looks like this app is for creating pages in specific templates. SheetDB also allows this using for example our JavaScript plugin (https://docs.sheetdb.io/#our-han...) or WordPress plugin (https://wordpress.org/plugins/sh...), giving more control to the author. But the real power of SheetDB is the REST API where you can read the sheet data in JSON format (which can be processed by any programming language and most tools on the market), you can also modify the data with simple requests. Check out our documentation here: https://docs.sheetdb.io/
Jacob Mhun
@swissdevjobs @chris_switalski thank you for the explanation!
Agnieszka Wnuk
Well done, simple and works great! The documentation is really clear. Cheers!
Chris Switalski
Maker
@agnieszka_wnuk Thanks a lot!
Mary Samovol
This is great! Congrats :)
Chris Switalski
Maker
@marsamovol Thank you, let me know if we can help you somehow?
Joe Rice
Hi, Chris asked me if I could review SheetDB so here I am. I have been working with them for over 2 years. SheetDB helps us show the data on our page, whenever I had a problem, the SheetDB team helped me very quickly and effectively, even a few of my ideas turned into official functionality of the application. I recommend this API and the support they offer to everyone!
Chris Switalski
Maker
@joe_rice Thank you Joe, it is a great pleasure working with you :)
Guido Arata
Using SheetDb minimum twice a week for a long time now. Simply amazing, stable, reliable. It just work, as simple as that :)
Chris Switalski
Maker
@guidoarata Thank you :)
Kristin Ides
Oh very cool! As a marketer I can think of a lot of uses for this!
Chris Switalski
Maker
@kristinides Thank you, let me know if we can help you somehow.
Harrison from VC Guide
Omg
Chris Switalski
Maker
@vcg_official What do you mean? :)
Ayman Gaber
great idea 🌹
Chris Switalski
Maker
Gilbert Mizrahi
I see that it simplifies the creation of the JSON from the spreadsheets. But what would be the advantage vs using Apps Scripts to do the same? Besides with Apps Script, you can do many additional things, such as geolocation, inverse location, run functions, etc
Chris Switalski
Maker
@gilbert_mizrahi1 It is easier to use for simple projects and you can easily implement it on your site. We have many libraries working with common tools, other APIs and programming languages. Check out our docs here: https://docs.sheetdb.io/#introdu...
Fred Kio
Makes Sense
Chris Switalski
Maker
@phred_kten Cheers!
12
Next
Last