# Create local datasource or DB from Google sheet

**URL:** <https://community.thunkable.com/t/create-local-datasource-or-db-from-google-sheet/1952733>\
**Category:** Questions about Thunkable X\
**Tags:** database, spreadsheets, spreadsheet, data-source, google-sheets\
**Created:** [July 5, 2022, 2:34pm UTC](https://community.thunkable.com/t/create-local-datasource-or-db-from-google-sheet/1952733 "2022-07-05T14:34:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![samharradine1994dvlm](https://avatars.discourse-cdn.com/v4/letter/s/65b543/32.png) [@samharradine1994dvlm](https://community.thunkable.com/u/samharradine1994dvlm)\
**Post date:** [July 5, 2022, 2:34pm UTC](https://community.thunkable.com/t/create-local-datasource-or-db-from-google-sheet/1952733/1 "2022-07-05T14:34:46Z")

</div>

I have searched through a lot of posts but couldn’t find, or didn’t know if I’d found something that would help me.

I have my app connected to google sheets which is working, however it is slow when creating and displaying a list once an object has been selected. The app deletes rows in a specific sheet, then reads data from elsewhere and updates that sheet.

I would create local data sources but that would be time consuming as i would have to rename each column header, I would also have to push out an app update each time the local data changed.

How can I best sync the data from the google sheet and create local data in the app please? I feel like it would be better for my app to have the data stored locally, but open to cloud options if i can get the sync speed faster.

I want to try and keep the amount of screens i use to a minimum also.

[https://x.thunkable.com/copy/eaee5feaaf987d7a057604984a6b26f2](https://x.thunkable.com/copy/eaee5feaaf987d7a057604984a6b26f2)

---

<div class="post-metadata">

**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:** [July 5, 2022, 3:25pm UTC](https://community.thunkable.com/t/create-local-datasource-or-db-from-google-sheet/1952733/2 "2022-07-05T15:25:30Z")

</div>

By sharing your app, you actually make a local copy of your Google sheet files.

See your app from my side and notice that all tables are now **local**

[https://x.thunkable.com/projectPage/62c456ae8019a00011b68f29](https://x.thunkable.com/projectPage/62c456ae8019a00011b68f29)

Use this project now to get the local and sync with your Google sheet.

If you ask me, I would use Firebase **Firestore** to accomplish this. Currently Thunkable does not support Firestore but you can easily manage it using APIs which would be less cumbersome from sync-ing between Google sheets and local tables.

---

<div class="post-metadata">

**Author:** ![samharradine1994dvlm](https://avatars.discourse-cdn.com/v4/letter/s/65b543/32.png) [@samharradine1994dvlm](https://community.thunkable.com/u/samharradine1994dvlm)\
**Post date:** [July 6, 2022, 9:33am UTC](https://community.thunkable.com/t/create-local-datasource-or-db-from-google-sheet/1952733/3 "2022-07-06T09:33:55Z")

</div>

I didnt know that. That save a lot of manually editing the column titles and i can just copy and paste the data into the local spreadsheet.

I did keep seeing a lot of firebase threads so I’ll try that out and see how it goes. If I can’t figure it out I’ll do the sharing trick to make a local sheets.

Thanks for your help

---

<div class="post-metadata">

**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:** [October 4, 2022, 9:34am UTC](https://community.thunkable.com/t/create-local-datasource-or-db-from-google-sheet/1952733/4 "2022-10-04T09:34:23Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.