# Data Source Confusion between Google Sheets and Airtable **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** design\ **Created:** [May 10, 2022, 1:59pm UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015 "2022-05-10T13:59:48Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![r0han](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/r0han/32/130614_2.png) [@r0han](https://community.thunkable.com/u/r0han)\ **Post date:** [May 10, 2022, 1:59pm UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/1 "2022-05-10T13:59:48Z")
Hi all, I am confused what is the best approach for self project and project made for clients using data. For self project having google sheets makes sense but for clients ( clients may not want me to access their user data , due to privacy issues ). I though to ask clients to have their own google drive and app will connect to it. but my thunkable account will have access to only mine google sheet/drive. If i create new thunkable account for client how can i copy my project to client account, if i wish to use some screens ?? If i switch to Airtable, it has limitations of 1200, to 5000 rows only. Please guide. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [May 10, 2022, 2:02pm UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/2 "2022-05-10T14:02:17Z")
If you are storing sensitive data, use Firebase and have users sign up and sign in. Set the Firebase rules to only allow access to each user’s data for the signed in user. This is a related discussion: > [@Ensuring user privacy](https://community.thunkable.com/t/ensuring-user-privacy/1867522): > > Hi Thunkers, I am making an App which lets users complete a health assessment or ‘functional rating scale’ and store their data to see changes over time. I am wondering if anyone has info about how to make sure I’m ensuring best practice is being followed for storing user data? Is it okay to save user’s medical data to a Google Sheet for example? Is it okay if I would (theoretically) have access to this data? I have started trying to figure out Firebase. Perhaps this is a more secure way? Wo… ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [May 10, 2022, 3:01pm UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/3 "2022-05-10T15:01:05Z")
For Google sheet connection you can use a different account to connect to the sheet. It does not have to be your developer’s account. However, for security/privacy issues, your best bet is Firebase. ---
**Author:** ![r0han](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/r0han/32/130614_2.png) [@r0han](https://community.thunkable.com/u/r0han)\ **Post date:** [May 10, 2022, 7:47pm UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/4 "2022-05-10T19:47:29Z")
Thanks Muneer, but then i cannot copy my existing screen if i want to used them. I have re-develop them, isn’t it. I thought about Firebase, but then JSON, i have to migrate my entire code which is in Google Sheets to Firebase, which is a little tricky , when we have nested arrays. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [May 10, 2022, 8:01pm UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/5 "2022-05-10T20:01:07Z")
> [@r0han](#): > > but then i cannot copy my existing screen if i want to used them You can copy the project to your other account or the account of your client. ---
**Author:** ![carlinmclellan](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/carlinmclellan/32/77831_2.png) [@carlinmclellan](https://community.thunkable.com/u/carlinmclellan)\ **Post date:** [May 10, 2022, 10:32pm UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/6 "2022-05-10T22:32:37Z")
Aha, perfect, thank you! ---
**Author:** ![barnwalvivaang](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@barnwalvivaang](https://community.thunkable.com/u/barnwalvivaang)\ **Post date:** [May 16, 2022, 7:52am UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/7 "2022-05-16T07:52:54Z")
Or, try storing your tables in firebase using lists with objects stored in them. ![Screenshot 2022-05-16 132041](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/b/8bdcc11d6f5c367df0b1438bea02e28e3dc06a50.png) You can do a system like this. ---
**Author:** ![r0han](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/r0han/32/130614_2.png) [@r0han](https://community.thunkable.com/u/r0han)\ **Post date:** [May 16, 2022, 8:17am UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/8 "2022-05-16T08:17:57Z")
I have realized, when data is been created in app itself it is better to store that table in Firebase ( Example, Users, Profile, Payments) , this way when your app has been built for other clients you don’t have to manually create these base tables. However, if you app takes inputs from table, which you need to dynamically change, example : Products, Price list, it it would be better to keep in Google Sheets or Airtable, because we can ask clients to update price list, products. There is no way these clients would be able to work on JSON table to update tables. Hybrid is good approach in my opinion. ---
**Author:** ![barnwalvivaang](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@barnwalvivaang](https://community.thunkable.com/u/barnwalvivaang)\ **Post date:** [May 16, 2022, 8:22am UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/9 "2022-05-16T08:22:41Z")
You can build the code by nesting a realtime db save block in a realtine db get block. Additionally, You can use DataChanged to alert the users for any changes to their table and refresh it. ---
**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:** [August 14, 2022, 8:22am UTC](https://community.thunkable.com/t/data-source-confusion-between-google-sheets-and-airtable/1870015/10 "2022-08-14T08:22:46Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.