# Cannot create data source from Google Sheets **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [November 13, 2023, 2:11pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666 "2023-11-13T14:11:47Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![maciej2001plr](https://avatars.discourse-cdn.com/v4/letter/m/e47c2d/32.png) [@maciej2001plr](https://community.thunkable.com/u/maciej2001plr)\ **Post date:** [November 13, 2023, 2:11pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666/1 "2023-11-13T14:11:47Z")
Hello, I’m trying to add Google Sheets as a data source to my project but after I select a sheet and press create after waiting a while an error page pops up (see attachment 1). ![error1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/5/c5c2ba458dd3142f28d0ba02a9505ac5794701c5.png)Previously it worked but I expanded the sheet with more data and I have this problem now. Is there a file size limit for google sheets ? My google sheets file has 4 sheets and around 15 000 rows so I would think it takes some time to load but it never works. After a while it shows up in My data sources but it is empty (see attachment 2) ![error2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/e/4e9ffa4631750f9c4792d5472eb3bc80d46065a7.png) and I cannot reference any columns in my app. I have already tried deleting my connection between thunkable and google sheets by removing google drive permission for thunkable and granting it again. Thanks in advance. ---
**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\ **Post date:** [November 13, 2023, 4:55pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666/2 "2023-11-13T16:55:47Z")
Hi @maciej2001plr, I took a look at your logs and the specific error we are seeing is in relation to the size of the strings in the proejct-- “Cannot create a string longer than 0x1fffffe8 characters” What is the specific data size/type you are entering into each cell in the google sheet? ---
**Author:** ![maciej2001plr](https://avatars.discourse-cdn.com/v4/letter/m/e47c2d/32.png) [@maciej2001plr](https://community.thunkable.com/u/maciej2001plr)\ **Post date:** [November 13, 2023, 6:19pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666/3 "2023-11-13T18:19:22Z")
Thanks for your reply. Mostly there are strings and some numbers. The largest cell that I found is 289 characters. Also I have a few charts in that sheet but I think they should not be a problem since they are not sent when passing a data source as I would think. I’m sending the data file in the attachment if you want to check, but the charts are not there because it is downloaded as excel from google sheets. [data.zip](https://community.thunkable.com/uploads/short-url/AaGfusocjaDwhvSdViwG9ceHmd.zip) (4.1 MB) ---
**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\ **Post date:** [November 13, 2023, 6:45pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666/4 "2023-11-13T18:45:23Z")
Hi @maciej2001plr, the issue here is that connecting to .xlsx files that are hosted on Google Sheets is not supported, but you can convert your .xlsx file to a Google Sheet before connecting it to your Thunkable app project. Please see our docs link below on how to convert this. > **[Google Sheets Data Source](https://docs.thunkable.com/getting-started/data-sources/data-sources#.xlsx-files)** > > Connecting your project to a data source allows you to work with the information that you have stored in Airtable, Google Sheets, Webflow or a local table. ---
**Author:** ![maciej2001plr](https://avatars.discourse-cdn.com/v4/letter/m/e47c2d/32.png) [@maciej2001plr](https://community.thunkable.com/u/maciej2001plr)\ **Post date:** [November 13, 2023, 7:07pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666/5 "2023-11-13T19:07:28Z")
My file is actually a Google Sheet. I downloaded it as .xlsx because that is how I can share it with you so you could open it and check but I can also send a .csv if you prefer. Sorry if I was not clear enough. ---
**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\ **Post date:** [November 13, 2023, 7:49pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666/6 "2023-11-13T19:49:38Z")
No worries. I am glad it is not a file format issue. The next thing to check would be the data itself. The first row in your sheet must be a header row, and every column must have a header–can you try adjusting that and making sure all of your tabs follow this procedure? ---
**Author:** ![maciej2001plr](https://avatars.discourse-cdn.com/v4/letter/m/e47c2d/32.png) [@maciej2001plr](https://community.thunkable.com/u/maciej2001plr)\ **Post date:** [November 13, 2023, 8:50pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666/7 "2023-11-13T20:50:47Z")
So I have made the changes: deleted empty columns and made sure that a column has a unique name in the first row and am still having the same issue. Now I am using a copy of my original google sheets file with these changes so I can still look into my original file. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [February 11, 2024, 8:51pm UTC](https://community.thunkable.com/t/cannot-create-data-source-from-google-sheets/2698666/8 "2024-02-11T20:51:28Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.