# Google sheets data source stopped working

**URL:** <https://community.thunkable.com/t/google-sheets-data-source-stopped-working/2503078>\
**Category:** Issues / Bugs\
**Created:** [July 11, 2023, 8:15pm UTC](https://community.thunkable.com/t/google-sheets-data-source-stopped-working/2503078 "2023-07-11T20:15:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![2003alnawasrahmohamm](https://avatars.discourse-cdn.com/v4/letter/2/85e7bf/32.png) [@2003alnawasrahmohamm](https://community.thunkable.com/u/2003alnawasrahmohamm)\
**Post date:** [July 11, 2023, 8:15pm UTC](https://community.thunkable.com/t/google-sheets-data-source-stopped-working/2503078/1 "2023-07-11T20:15:40Z")

</div>

I connected my google sheet file as a data source and it worked for a while, I kept making changes to that file but I faced no problems  
today when I tried to sync the table after I had added tow new columns it gave me the error: GraphQL error: DataSource validation failed: collections.1.fields.6.type: `TEXT` is not a valid enum value for path `type`.  
so I deleted the columns that I added and tried to sync it again but it gave me the same error, I made a copy of the file and tried to connect it but it didn’t load, it gave me no error, just nothing showed up

side note: I did make some apps script functions for that file and used them in it but I did that before and the data source was working just fine, so I doubt that could be the issue

so how do I fix this?

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 1:33pm UTC](https://community.thunkable.com/t/google-sheets-data-source-stopped-working/2503078/2 "2024-11-08T13:33:43Z")

</div>