# Retreive Specific Data from Google Sheets **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [June 23, 2021, 11:00am UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900 "2021-06-23T11:00:04Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![aikansh.dua044gefzj](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@aikansh.dua044gefzj](https://community.thunkable.com/u/aikansh.dua044gefzj)\ **Post date:** [June 23, 2021, 11:00am UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/1 "2021-06-23T11:00:04Z")
Hi everyone, I would like to know how can I retrieve the specific data from Google Sheets. Lets say I want to retrieve the leave from and to dates for user ‘x’ in the screenshot. Can anyone help me with this. (This Sheet is connected to a google form so It will update regulary) Thanks Or pls tell how I can implement this in airtable ![Screenshot 2021-06-23 162921](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/0/60d6770a2f5abb9ae7071835ba3bf22a7c85bd1c.png) ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 23, 2021, 11:16am UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/2 "2021-06-23T11:16:25Z")
Just Use this block: ![get_value](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/d/9dfe6979f134fa870e4dc2bab83ed137a3b7f336.png) ---
**Author:** ![aikansh.dua044gefzj](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@aikansh.dua044gefzj](https://community.thunkable.com/u/aikansh.dua044gefzj)\ **Post date:** [June 23, 2021, 11:26am UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/3 "2021-06-23T11:26:11Z")
Hi so this block has the column block I dont know which column the value will be since its a google form it could be any integer ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 23, 2021, 12:10pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/4 "2021-06-23T12:10:07Z")
Its standard 1 unless you change it manualy. ---
**Author:** ![aikansh.dua044gefzj](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@aikansh.dua044gefzj](https://community.thunkable.com/u/aikansh.dua044gefzj)\ **Post date:** [June 23, 2021, 1:43pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/5 "2021-06-23T13:43:00Z")
Hi, So I don’t know the column number in which the value will be as it’s a google form and it also can have more than 1 row for a particular user as shown in image. My idea is to get filtered data for user “x” I don’t know if there’s an api for it if it is pls share the same ---
**Author:** ![aikansh.dua044gefzj](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@aikansh.dua044gefzj](https://community.thunkable.com/u/aikansh.dua044gefzj)\ **Post date:** [June 23, 2021, 2:44pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/6 "2021-06-23T14:44:18Z")
Hi, So I found an api for the same it shows the filtered value in json so I want to retrieve these values from json [ { “Name:”: “X”, “Leave Start Date”: “6/23/2021 11:42:31”, “Leave End Date:”: “6/25/2021” }, { “Name:”: “X”, “Leave Start Date”: “6/23/2021 11:42:31”, “Leave End Date:”: “6/25/2021” }, { “Name:”: “X”, “Leave Start Date”: “6/23/2021 11:42:31”, “Leave End Date:”: “6/27/2021” } ] as a list here is a sample on how it should look ![Screenshot 2021-06-23 195350](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/3/43f047f415b4f539608ae9eeb6888a8723dbf48b.png) The blocks I am using are these( I am first trying to retrieve the usernames ‘X’ ) but it just gives a blank screen since it didn’t get any values from the API ![Screenshot 2021-06-23 201247](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/f/bf88e8915aab7e6370c12a310c3350cb5e760695.png) ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [June 23, 2021, 4:01pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/7 "2021-06-23T16:01:36Z")
Sorry i can’t help there. Haven’t yet learned to work with API’s ---
**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:** [June 23, 2021, 4:13pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/8 "2021-06-23T16:13:24Z")
Try something like this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/0/80e615332f617351779c6967362f8a0888dc7bcb.png) This is my output ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/0/9011d76996f0fc980fda3eaa7c17098b18057ff3.png) ---
**Author:** ![aikansh.dua044gefzj](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@aikansh.dua044gefzj](https://community.thunkable.com/u/aikansh.dua044gefzj)\ **Post date:** [June 23, 2021, 4:27pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/9 "2021-06-23T16:27:58Z")
Hey @muneer could you share the project link for the same.I wasn’t able to find the list of values blocks and get value blocks. Thanks. ---
**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:** [June 23, 2021, 4:55pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/10 "2021-06-23T16:55:40Z")
I deleted it already sorry. You will find these blocks in the `Data Sources` drawer in the blocks screen. If `Data Sources` is not showing in the block screen then you need to add a data source which you can do here (for Snap to Place UI) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/f/ff6076727511c0449dac11f10e682fd66453bc24.png) Or here (for DnD UI) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/4/748ccc59a0599014268942c53fe18b97f73ecb93.png) ---
**Author:** ![aikansh.dua044gefzj](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@aikansh.dua044gefzj](https://community.thunkable.com/u/aikansh.dua044gefzj)\ **Post date:** [June 23, 2021, 5:58pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/11 "2021-06-23T17:58:46Z")
Hi, You haven’t used the json blocks or the api get blocks so how would we get the value from api. If you want I can share the project link with you in Personal Message ---
**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:** [June 23, 2021, 6:23pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/12 "2021-06-23T18:23:53Z")
This has nothing to do with API. Use only `Data Source` connection. ---
**Author:** ![aikansh.dua044gefzj](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@aikansh.dua044gefzj](https://community.thunkable.com/u/aikansh.dua044gefzj)\ **Post date:** [June 23, 2021, 7:34pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/13 "2021-06-23T19:34:12Z")
My data source keeps getting updates being a form spreadsheet so I don’t think that data source connection would update each time a new response comes. ---
**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:** [June 23, 2021, 7:36pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/14 "2021-06-23T19:36:52Z")
The same is true for the API. The `Data Source` connection or `API Get` will retrieve the information upon request. ---
**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:20pm UTC](https://community.thunkable.com/t/retreive-specific-data-from-google-sheets/1359900/15 "2024-11-08T13:20:08Z")