# Google Sheets creating new + offline

**URL:** <https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279>\
**Category:** Questions about Thunkable X\
**Tags:** beginner, offline, google-sheets\
**Created:** [September 13, 2024, 3:08pm UTC](https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279 "2024-09-13T15:08:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pavelcxyz](https://avatars.discourse-cdn.com/v4/letter/p/5fc32e/32.png) [@pavelcxyz](https://community.thunkable.com/u/pavelcxyz)\
**Post date:** [September 13, 2024, 3:08pm UTC](https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279/1 "2024-09-13T15:08:01Z")

</div>

Hello Everybody

I have Q. questions regarding working with Google Sheets in Thunkable

I would like to ask whether the following scenario is possible in Thunkable. I assume some parts are possible, but I would like confirmation, and for others, I need specific advice:

1. 

**Downloading selected demo data** from Google Sheets: I assume Thunkable allows downloading data stored in Google Sheets after the app is installed. Is there a standard and straightforward process for this in Thunkable?

1. 

**Automatically creating a new Google Sheet** (or adding a list) during registration for each user: Upon registration, I would like to automatically create a new Google Sheet for each user, where both registration data and data recorded by the app will be stored. Is this feasible in Thunkable?

1. 

**Saving** data online and **offline:** From what I have found, Thunkable supports saving data to Google Sheets online, but I am unsure whether it is possible to store **data offline** and sync it later when the device is connected to the internet. Is there native support in Thunkable for this functionality, or can it be handled or solve?

1. 

**Synchronizing** data via mobile data or Wi-Fi: I assume Thunkable automatically syncs data when the device is **connected** to the internet, but is it possible to set specific conditions for synchronization, such as syncing only over Wi-Fi or mobile data?  
Is there a way to configure this in the app?

Thank you in advance for your answers and advice on how to achieve this scenario in Thunkable

---

<div class="post-metadata">

**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:** [September 13, 2024, 7:27pm UTC](https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279/2 "2024-09-13T19:27:07Z")

</div>

> [@pavelcxyz](#):
>
> **Downloading selected demo data** from Google Sheets

I’m not sure what you mean. Published Thunkable apps can access Google Sheets data. What do you mean by “demo” data? And do you mean downloading to the device so the user can access the data offline without the need for the app?

> [@pavelcxyz](#):
>
> Automatically creating a new Google Sheet

You would need to use the Google Apps API / Google Scripting for this.

> [@pavelcxyz](#):
>
> **Saving** data online and **offline**

I don’t think there’s a way to sync offline data but you could figure out a way to do that using the API or Scripting.

> [@pavelcxyz](#):
>
> **Synchronizing** data via mobile data or Wi-Fi

Don’t assume that automatic syncing is happening. You are in control of the code so you decide what your app does or doesn’t do. You can create timers and other triggers for updating or retrieving online data.

There’s a `Device is Online` block that will help with this. See [Device Blocks | Thunkable Docs](https://docs.thunkable.com/blocks/blocks/device#device-is-online).

---

<div class="post-metadata">

**Author:** ![pavelcxyz](https://avatars.discourse-cdn.com/v4/letter/p/5fc32e/32.png) [@pavelcxyz](https://community.thunkable.com/u/pavelcxyz)\
**Post date:** [September 16, 2024, 3:47pm UTC](https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279/3 "2024-09-16T15:47:26Z")

</div>

Thank you for your reply!

> [@tatiang](#):
>
> I’m not sure what you mean. Published Thunkable apps can access Google Sheets data. What do you mean by “demo” data? And do you mean downloading to the device so the user can access the data offline without the need for the app?

I mean  
after downloading the app, to display offline demo data in the app.

---

<div class="post-metadata">

**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:** [September 16, 2024, 10:58pm UTC](https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279/4 "2024-09-16T22:58:19Z")

</div>

> [@pavelcxyz](#):
>
> I mean  
> after downloading the app, to display offline demo data in the app.

Well, when they download the app they have to be online but if you only want the demo data to be offline data then put it in the local data source for the app and you can display it offline that way.

---

<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:** [December 15, 2024, 10:58pm UTC](https://community.thunkable.com/t/google-sheets-creating-new-offline/3200279/5 "2024-12-15T22:58:51Z")

</div>

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