# Getting row ID of google sheet data source
**URL:** https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130
**Category:** Questions about Thunkable X
**Created:** [June 4, 2020, 8:31am UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130 "2020-06-04T08:31:55Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@aliencaocao](https://community.thunkable.com/u/aliencaocao)
#### Post date: [June 4, 2020, 8:31am UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/1 "2020-06-04T08:31:55Z")
I am trying to add a Google Sheet as data source. I need to locate a specific cell and get its value, how do I get the '24 character row ID" to specify which row to locate the cell in? I know one way is to use a data viewer to list out all data then use left/right swipe function, however I do not want to list out anything, I just want the app to filter silently according to a predefined condition.
Or, is there a way for me to get every single row and save it as a localDB?
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 4, 2020, 11:25am UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/2 "2020-06-04T11:25:09Z")
If you look carefully at all the blocks for Data Source, you will find a block that can be used to get rows from Google Table
---
### Author:  [@aliencaocao](https://community.thunkable.com/u/aliencaocao)
#### Post date: [June 4, 2020, 11:31am UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/3 "2020-06-04T11:31:06Z")
there are only 4 functions under data sources block, none of which are able to get all rows from the data source.
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 4, 2020, 12:00pm UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/4 "2020-06-04T12:00:05Z")
For these blocks to appear you need to attach Data Source to Data View and install columns
---
### Author:  [@aliencaocao](https://community.thunkable.com/u/aliencaocao)
#### Post date: [June 8, 2020, 12:42pm UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/5 "2020-06-08T12:42:35Z")
Yes I do have a data view list that is displaying my google sheet data source, and its working fine. However I still dont see the two blocks you screenshotted.
My final target is to perform a search for a specific text string in the whole google sheet and know the row ID for the row that contain that text string. Do you know any work arounds I could use, since Thunkable does not seem to provide this natively?
---
### Author:  [@aliencaocao](https://community.thunkable.com/u/aliencaocao)
#### Post date: [June 8, 2020, 12:53pm UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/6 "2020-06-08T12:53:52Z")
I can see these blocks in the docs too but the doc didnt state any condition for these blocks to appear.
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 8, 2020, 12:54pm UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/7 "2020-06-08T12:54:56Z")
I also see this problem right now
---
### Author:  [@skulamester](https://community.thunkable.com/u/skulamester)
#### Post date: [April 6, 2021, 2:11pm UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/8 "2021-04-06T14:11:58Z")
Do you have any solution?
---
### Author:  [@manyone](https://community.thunkable.com/u/manyone)
#### Post date: [May 2, 2021, 6:02am UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/9 "2021-05-02T06:02:13Z")
first create Col1list as list of values in mylocaltable in table1 in column1
then create rowidList as list of values in mylocaltable in table1 in ID (aka rowid)
find the first occurnce of your search string in Col1List and you get an index
use that index in rowidList to obtain the corresponding rowid
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:27am UTC](https://community.thunkable.com/t/getting-row-id-of-google-sheet-data-source/592130/10 "2024-11-08T11:27:45Z")