# Help me to view all my data in googlesheets via Web Api

**URL:** https://community.thunkable.com/t/help-me-to-view-all-my-data-in-googlesheets-via-web-api/2423778
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [May 18, 2023, 4:22am UTC](https://community.thunkable.com/t/help-me-to-view-all-my-data-in-googlesheets-via-web-api/2423778 "2023-05-18T04:22:42Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![bargselyd2po0](https://avatars.discourse-cdn.com/v4/letter/b/96bed5/32.png) [@bargselyd2po0](https://community.thunkable.com/u/bargselyd2po0)
#### Post date: [May 18, 2023, 4:22am UTC](https://community.thunkable.com/t/help-me-to-view-all-my-data-in-googlesheets-via-web-api/2423778/1 "2023-05-18T04:22:42Z")

</div>

Can anyone help me to View all my data in googlesheets via Web Api with this portion only not with components, settings or anything just only the information and for view only no one can edit or replace the data in my sheets? and I’m a beginner only.

 ![2023-05-18 12_19_50-Sales Goal - Google Sheets](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/7/071f6e88f0ec1b153e133cfd1685bc0c9c6966e3.png)

---

<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: [May 18, 2023, 4:35am UTC](https://community.thunkable.com/t/help-me-to-view-all-my-data-in-googlesheets-via-web-api/2423778/2 "2023-05-18T04:35:02Z")

</div>

You might want to set your Google Sheet to “view only” for anyone who has the link and then add a Web Viewer to your project screen and set the url to the link to the Google Sheet.

But if it’s a wide (many columns) sheet, it may not display well.

---

<div class="post-metadata">

### Author: ![bargselyd2po0](https://avatars.discourse-cdn.com/v4/letter/b/96bed5/32.png) [@bargselyd2po0](https://community.thunkable.com/u/bargselyd2po0)
#### Post date: [May 18, 2023, 4:50am UTC](https://community.thunkable.com/t/help-me-to-view-all-my-data-in-googlesheets-via-web-api/2423778/3 "2023-05-18T04:50:49Z")

</div>

Your right, It not display well. Can you help me to view all my data in google sheets without using web viewer?

---

<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: [May 18, 2023, 7:16am UTC](https://community.thunkable.com/t/help-me-to-view-all-my-data-in-googlesheets-via-web-api/2423778/4 "2023-05-18T07:16:59Z")

</div>

There are two methods:

1. Use a Data Viewer List and optionally, create a custom layout to display your data

2. Use cloned components. This is an **advanced** technique in Thunkable.

---

<div class="post-metadata">

### Author: ![bargselyd2po0](https://avatars.discourse-cdn.com/v4/letter/b/96bed5/32.png) [@bargselyd2po0](https://community.thunkable.com/u/bargselyd2po0)
#### Post date: [May 18, 2023, 8:31am UTC](https://community.thunkable.com/t/help-me-to-view-all-my-data-in-googlesheets-via-web-api/2423778/5 "2023-05-18T08:31:41Z")

</div>

I’ll try this. Thank you so much 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: [August 16, 2023, 8:31am UTC](https://community.thunkable.com/t/help-me-to-view-all-my-data-in-googlesheets-via-web-api/2423778/6 "2023-08-16T08:31:53Z")

</div>

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