# Can you only reference a single sheet in Google Sheets? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** google-sheets\ **Created:** [October 30, 2021, 3:51am UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629 "2021-10-30T03:51:54Z")\ **Posts on this page:** 8\ **Page:** 1
**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:** [October 30, 2021, 3:51am UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629/1 "2021-10-30T03:51:54Z")
Is it possible to reference more than one sheet within a single Google Sheet file? For example, I have this Google Sheet set up with 3 named sheets: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/9/d955ce220640e25949f1c455d02af16198288451.png) The first sheet uses formulas to sort the data from the second sheet. So I want to be able to get/set the values on the second sheet while syncing the values on the first sheet with a Data Viewer List (DVL) in Thunkable. That way, I can update the second sheet and still display sorted values in Thunkable. Is that possible? From the looks of it, there is not a way to select which sheet is connected to a DVL. In this screenshot, I selected a Google Sheet called Menu Survey but there’s no option to select a sheet within Menu Survey. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/b/0bb7449f0ed181e97c481085e96107d99d57f225.png) Is it just me or is it confusing to call something a “Google Sheet” and then have tabs called “sheets” within it? 🤪 ---
**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:** [October 30, 2021, 3:56am UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629/2 "2021-10-30T03:56:15Z")
I created a feature request for this: [Ability to select a sheet (tab) within a Google Sheet when syncing to a Data Viewer List · Issue #1048 · thunkable/thunkable-issues · GitHub](https://github.com/thunkable/thunkable-issues/issues/1048) ---
**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:** [October 30, 2021, 3:58am UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629/3 "2021-10-30T03:58:55Z")
The `Data Source` connection takes the Google sheet name but the blocks in the project gives the option to select different sheets. The DVL also has a sheet option drop-down menu. I’m not sure if this is the correct answer but this is how I understand your post ---
**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:** [October 30, 2021, 4:30am UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629/4 "2021-10-30T04:30:36Z")
That makes sense but the “Table” property is not updating. I’ve renamed the first sheet from “Sheet1” and added two more. So I can’t figure out a way to select or add a different sheet name associated with the DVL. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/4/e43a3b72213c97335a429c8d1b2810447edc3483.png) ---
**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:** [October 30, 2021, 4:33am UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629/5 "2021-10-30T04:33:13Z")
Okay, I had to delete and re-add the data source. Then it sees all of the sheets. It’s a shame it can’t refresh on its own. ---
**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:** [October 30, 2021, 6:48am UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629/6 "2021-10-30T06:48:22Z")
> [@tatiang](#): > > It’s a shame it can’t refresh on its own. Go to `My Data Sources` tab in the main page and refresh the connection to reflect new structure changes in the Google sheet file. You do not need to delete then add. ---
**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:** [October 30, 2021, 6:49am UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629/7 "2021-10-30T06:49:31Z")
Ah, I always forget that’s there. Thank you. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:14pm UTC](https://community.thunkable.com/t/can-you-only-reference-a-single-sheet-in-google-sheets/1588629/8 "2024-11-08T13:14:34Z")