I am considering using Google Sheets as my data source, because Xeno and Supabase is an overkill and a bit pricey. I also saw a note that SQL connection is not recommended for public apps. My questions, are there any concerns with using sheets?
The app i am building will be an inventory management accesible both by internal employees and external clients.
If you’re thinking of using Google Sheets as a backend, you most certainly can stick to Supabase’s free tier just fine. As long as you’re okay [using google sheets] with potential API bottlenecks and no user authentication (from what it sounds like), you should be fine.
Thank you.
Why choose Supabase free tier over Google Sheets though?
It’s kind of like saying, why use a bed when I can just sleep on the floor?
I mean, yeah Google Sheets will work. but if you’re ever looking to scale your application, have automations, make good api requests joining data, you’ll need a proper database.
Hi @Diginovix 
If you use Google Sheets, you will only be able to pull data from WeWeb but not to post to the sheet natively. We don’t have any plugin workflow actions now that allow users to update sheets yet, we could add this later though. If you would like to post to the sheet, you would need to know the Google Sheets API and write some custom JS code or you could use Google Forms inside an iframe.
1 Like
Thats the most important reason. Thank you
1 Like
I agree with everything above, I would just add one more thing - if Supabase is not your thing, you can use Airtable. They have a generous free tier and our Airtable plugin is fantastic - it allows you do do backend filtering as well.
Where Supabase + WeWeb is a California King Size bed, WeWeb + Airtable is definitely at least a Queen. Much better than sleeping on the floor for the same price.
2 Likes
As someone who sleeps on the couch, your comparison may have sold me on a California King bed 
@Slavo
1 Like