# Google sheets data source

**URL:** <https://community.weweb.io/t/google-sheets-data-source/12788>\
**Category:** Ask us anything\
**Created:** [September 25, 2024, 1:53am UTC](https://community.weweb.io/t/google-sheets-data-source/12788 "2024-09-25T01:53:11Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Diginovix](https://avatars.discourse-cdn.com/v4/letter/d/6de8d8/32.png) [@Diginovix](https://community.weweb.io/u/Diginovix)\
**Post date:** [September 25, 2024, 1:53am UTC](https://community.weweb.io/t/google-sheets-data-source/12788/1 "2024-09-25T01:53:11Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Micah](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/micah/32/9102_2.png) [@Micah](https://community.weweb.io/u/Micah)\
**Post date:** [September 25, 2024, 3:05am UTC](https://community.weweb.io/t/google-sheets-data-source/12788/2 "2024-09-25T03:05:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Diginovix](https://avatars.discourse-cdn.com/v4/letter/d/6de8d8/32.png) [@Diginovix](https://community.weweb.io/u/Diginovix)\
**Post date:** [September 25, 2024, 3:22am UTC](https://community.weweb.io/t/google-sheets-data-source/12788/3 "2024-09-25T03:22:25Z")

</div>

Thank you.  
Why choose Supabase free tier over Google Sheets though?

---

<div class="post-metadata">

**Author:** ![Micah](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/micah/32/9102_2.png) [@Micah](https://community.weweb.io/u/Micah)\
**Post date:** [September 25, 2024, 3:32am UTC](https://community.weweb.io/t/google-sheets-data-source/12788/4 "2024-09-25T03:32:03Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![DanielL](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/daniell/32/13398_2.png) [@DanielL](https://community.weweb.io/u/DanielL)\
**Post date:** [September 25, 2024, 5:11am UTC](https://community.weweb.io/t/google-sheets-data-source/12788/5 "2024-09-25T05:11:50Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Diginovix](https://avatars.discourse-cdn.com/v4/letter/d/6de8d8/32.png) [@Diginovix](https://community.weweb.io/u/Diginovix)\
**Post date:** [September 25, 2024, 1:05pm UTC](https://community.weweb.io/t/google-sheets-data-source/12788/6 "2024-09-25T13:05:17Z")

</div>

Thats the most important reason. Thank you

---

<div class="post-metadata">

**Author:** ![Slavo](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/slavo/32/13253_2.png) [@Slavo](https://community.weweb.io/u/Slavo)\
**Post date:** [September 25, 2024, 1:27pm UTC](https://community.weweb.io/t/google-sheets-data-source/12788/7 "2024-09-25T13:27:50Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Micah](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/micah/32/9102_2.png) [@Micah](https://community.weweb.io/u/Micah)\
**Post date:** [September 25, 2024, 2:19pm UTC](https://community.weweb.io/t/google-sheets-data-source/12788/8 "2024-09-25T14:19:26Z")

</div>

As someone who sleeps on the couch, your comparison may have sold me on a California King bed 😉 @Slavo
