# Data Sources Blocks ## Overview The data sources blocks allow you to perform a variety of CRUD (**C**reate, **R**ead, **U**pdate, **D**elete) operations on records you have stored in Airtable, Google Sheets, or a local table. ![](https://1223006790-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LAn5scXl2uqUJUOqkJo-84897653%2Fuploads%2FLv3rkpscNIBaD5P5suet%2FBlocks%20%3E%20App%20Features%20%3E%20Data%20Sources.png?alt=media\&token=4ae3c3d7-b8f3-4d03-b919-e779a4bad92c) ## Create Data ### Video Tutorial #### How to Create Data in a Thunkable Data Source In this tutorial, we’ll demonstrate how to create data in a connected data source such as Google Sheets, Airtable, or a local table. {% embed url="" %} **Template app:** 1. Click: 2. Click **Copy Project** in the upper right. **Copy of spreadsheet:** [Google Sheet - Thunkable Employee Directory](https://docs.google.com/spreadsheets/d/1hMdJ1O-uekCi1_aT4OpWInk_bS_pvU3zouqYYXE2sn4/copy) ### Create Row In Block Overview The **create row in** block allows you to append new rows to the end of your data tables. ![](https://1223006790-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LAn5scXl2uqUJUOqkJo%2F-M5aGJ1wOENtwwwS3swV%2F-M5aPpI5KxOgLLhjwyBr%2Fcreate_row.png?alt=media\&token=9f08bf0a-126a-421e-8826-ea5839c5fed5) The inputs are dynamic, so if you change the name of Column 1 or Column 2 in the data source, these changes will also be reflected in the block. You can only connect text and numbers to the **create row in** block. There is a second **create row in** block which allows you to add a row in your data source using an object. The field is the column name and the cell info is the value you would like to set.
## Read Data ### Video Tutorial #### **How to Read Data in a Thunkable Data Source** In this tutorial, we’ll demonstrate how to read data in a connected data source such as Google Sheets, Airtable, or a local table. {% embed url="" %} **Template app:** 1. Click: 2. Click **Copy Project** in the upper right. **Copy of spreadsheet:** [Google Sheet - Thunkable Employee Directory](https://docs.google.com/spreadsheets/d/1hMdJ1O-uekCi1_aT4OpWInk_bS_pvU3zouqYYXE2sn4/copy) ### Get Value From Block Overview The **get value from** block allows you to read a value from a specific cell in your data table. You can specify the column name and the view in the block itself and pass the unique row id as an input.
{% hint style="warning" %} The valid id types are index and unique id. The index refers to the row by its integer position (1 for the first row, 2 for the second row, etc.) and must be greater than zero. {% endhint %} ### Get Row Object From Block Overview The **get row object from** block returns the row object of the specified row ID. The row object can be used with [Objects Blocks.](https://docs.thunkable.com/blocks/blocks/objects)
### Get First Row Object From Block Overview The **get first row object from** block returns the row object of the first row that meets the specified condition. You can specify the column name and condition in the block itself and pass the value as an input. The row object can be used with [Objects Blocks.](https://docs.thunkable.com/blocks/blocks/objects)
### List of Value In Block Overview The **list of values in** block allows you to read an entire column of data from a table and returns it as a list you can then manipulate with the [List Blocks](https://docs.thunkable.com/blocks/blocks/lists).
### Number of Rows In Block Overview The **number of rows in** block returns an integer corresponding to how many rows are in a given data source.
### Columns In Block Overview The **columns in** block returns the column names of a data source
## Update Data ### Video Tutorial #### How to Update Data in a Thunkable Data Source In this tutorial, we’ll demonstrate how to update data in a connected data source such as Google Sheets, Airtable, or a local table. {% embed url="" %} **Template app:** 1. Click: 2. Click **Copy Project** in the upper right. **Copy of spreadsheet:** [Google Sheet - Thunkable Employee Directory](https://docs.google.com/spreadsheets/d/1hMdJ1O-uekCi1_aT4OpWInk_bS_pvU3zouqYYXE2sn4/copy) ### Update Value In Block Overview The **update value in** block allows you to modify or update an existing cell in your data source. The column name and view are specified in the block itself. The **row id** and new **value** are passed as inputs.
There is a second **update row in** block which allows you to update a row in your data source using an object. The field is the column name and the cell info is the value you would like to set.
## Delete Data ### Video Tutorial #### How to Delete Data in a Thunkable Data Source In this tutorial, we’ll demonstrate how to delete data in a connected data source such as Google Sheets, Airtable, or a local table. {% embed url="" %} **Template app:** 1. Click: 2. Click **Copy Project** in the upper right. **Copy of spreadsheet:** [Google Sheet - Thunkable Employee Directory](https://docs.google.com/spreadsheets/d/1hMdJ1O-uekCi1_aT4OpWInk_bS_pvU3zouqYYXE2sn4/copy) ### Delete Row In Block Overview The **delete row in** block allows you to delete a row of data from your data source. The row id is passed as an input. If there is an error, the error message is passed as an output.
### Delete All Rows In Block Overview The **delete all rows in** block allows you to delete all rows in your data source. If there is an error, the error message is passed as an output.
{% hint style="info" %} The **delete all rows in** block is not available when Airtable is the connected data source. {% endhint %} ## Filter ### Update Filter For Block Overview The **update filter for** block allows you to edit the value for each condition within a specific view of your data source.