# Binding GoogleSheet-data

**URL:** <https://community.weweb.io/t/binding-googlesheet-data/17863>\
**Category:** Ask us anything\
**Created:** [April 21, 2025, 8:19am UTC](https://community.weweb.io/t/binding-googlesheet-data/17863 "2025-04-21T08:19:49Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![WimDC](https://avatars.discourse-cdn.com/v4/letter/w/8e7dd6/32.png) [@WimDC](https://community.weweb.io/u/WimDC)\
**Post date:** [April 21, 2025, 8:19am UTC](https://community.weweb.io/t/binding-googlesheet-data/17863/1 "2025-04-21T08:19:49Z")

</div>

Hi,

I want (for my first - experimental - project) bind a simple GoogleSheet to my Weweb-project.  
No problem to bind, but it seems that the field-types are “converted” as string, even if they are formatted in the Google Sheet as dates or numbers.

 ![Afbeelding1](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/d/d1f3c69d2df6759a38145eb86b3a443a0625ebc9.png)

Also, when I tried to add a date-element to my Weweb-section, I can’t display it in the correct European format as Weweb thinks the first element is the month and the second the date (in my Google Sheet - record 2 has date 8-4-2025 which means 8th of April 2025, not 4th of August !!  
(I changed the format in Weweb (see at the right DD/MM/YYYY))

 ![Afbeelding2](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/f/fab411aff6c750e42c32afffe888bd1e5e179a09.png)

So my questions:

- how to change field types in Weweb to math Google Sheet-data
- how let Weweb ‘read’ dates as European dates, not as English dates
- how to set the language to Dutch, so I can get “maandag” in mstead of ‘Monday’ and “maart” instead of ‘March’

I’m still learning how to use Weweb, but can someone give me some little help if I want users give the possibility to change (edit) one of my fields. Like changing number value in one record from 77 to 99.

Thanks!

---

<div class="post-metadata">

**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\
**Post date:** [April 22, 2025, 1:09am UTC](https://community.weweb.io/t/binding-googlesheet-data/17863/2 "2025-04-22T01:09:23Z")

</div>

Hi @WimDC 👋

Here’s a short video covering your use case to format dates in Dutch 🙂[Date Formatting 📅](https://www.tella.tv/video/date-formatting-doh4)

I hope it helps!

Regarding giving users of you app the possibility to edit the values of a field, you won’t have that option in WeWeb if you’re using Google Sheets as a data source. Our GS plugin is read-only.

If you’d still like to give WeWeb a try but don’t want to look at more technical data sources like Xano or Supabase for now, I’d recommend testing with Airtable 🙂

---

<div class="post-metadata">

**Author:** ![WimDC](https://avatars.discourse-cdn.com/v4/letter/w/8e7dd6/32.png) [@WimDC](https://community.weweb.io/u/WimDC)\
**Post date:** [April 22, 2025, 4:58am UTC](https://community.weweb.io/t/binding-googlesheet-data/17863/3 "2025-04-22T04:58:51Z")

</div>

Hi Joyce,

Thanks for the video and mentioning the limits of the GS-plugin.

I want to switch from Glide to Weweb, so my current datasources are all GS with a lot of spreadsheet-formulas.

I saw Baserow as an Airtable alternative (also with spreadsheet-like formulas) because Airtable has a limit of 1000 records in their free plan.  
Or NocoDB.

(How) Can I use Baserow and NocoDB with Weweb (read/write/add)? Where can I find more help?

Wim

---

<div class="post-metadata">

**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\
**Post date:** [April 22, 2025, 5:50pm UTC](https://community.weweb.io/t/binding-googlesheet-data/17863/4 "2025-04-22T17:50:16Z")

</div>

Hi @WimDC 👋

Yes, you can.

We don’t have native integrations with Baserow and NocoDB yet but I can put you in touch with a WeWeb user who has a lot of experience building apps with WeWeb and Baserow. He’ll be able to point you in the right direction when it comes to setting things up securely 🙂

I’ll send you his email address in a DM.

---

<div class="post-metadata">

**Author:** ![WimDC](https://avatars.discourse-cdn.com/v4/letter/w/8e7dd6/32.png) [@WimDC](https://community.weweb.io/u/WimDC)\
**Post date:** [April 30, 2025, 8:39pm UTC](https://community.weweb.io/t/binding-googlesheet-data/17863/5 "2025-04-30T20:39:57Z")

</div>

Hi @Joyce ,

Is it possible to use more than one Airtable-database in one WeWeb-project and can multiple Airtable-databases “linked” together with lookup-function or queries in their free plan?

---

<div class="post-metadata">

**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\
**Post date:** [May 6, 2025, 3:41pm UTC](https://community.weweb.io/t/binding-googlesheet-data/17863/6 "2025-05-06T15:41:29Z")

</div>

Hi @WimDC 👋

I don’t know about Airtable’s pricing but it is possible to work with multiple airtable databases in a single weweb project. It is also possible to fetch data that is in a lookup in airtable or to use lookup formulas in weweb directly to lookup data that are in different Airtable tables.

I would recommend watching this mini-course to learn the basics of a weweb / airtable combo: [https://academy.weweb.io/build-with-airtable/](https://academy.weweb.io/build-with-airtable/)

---

<div class="post-metadata">

**Author:** ![WimDC](https://avatars.discourse-cdn.com/v4/letter/w/8e7dd6/32.png) [@WimDC](https://community.weweb.io/u/WimDC)\
**Post date:** [May 17, 2025, 6:51pm UTC](https://community.weweb.io/t/binding-googlesheet-data/17863/7 "2025-05-17T18:51:01Z")

</div>

Hi @Joyce ,  
I’m now using Airtable as datasource for my first Weweb-project where one of the fields is a date-field.  
But when fetching this field (and other fields) in Weweb, it is “converted” as a string.  
So it’s not possible to filter the records as I want only those records with a date \>= today.  
(Weweb only gives me conditions for strings, like “contains”, “starts with”, …)

 ![2025-05-17_205009](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/3/3dac0d0d390cf8e06c2c6276554c97eef28598c1.png)

What am I doing wrong?
