> For the complete documentation index, see [llms.txt](https://docs.langstack.com/welcome/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.langstack.com/welcome/in-depth-learning/connectors/google-drive-connector/using-google-drive-connector-in-etl-pipeline.md).

# Using Google Drive connector in ETL pipeline

The Google drive connector supports the following: 

* CSV files including google sheets.
* Fixed width files including google docs.
* Text files including google docs.

The following examples show how to use the Google Drive connector:

* In example 1, the Google Drive connector is the source, and an entity is a destination.
* In example 2, the Google Drive connector is the destination, and an entity is the source.

#### Prerequisites for the examples <a href="#prerequisites-for-the-examples" id="prerequisites-for-the-examples"></a>

For both the examples below, the following are created:

1. An Entity with the name TEST\_Customers\_Entity with the following fields: (Data has already been added to the entity.)
   1. 1.Customer\_ID as GUID
   2. 2.First\_Name as string
   3. 3.Last\_Name as string
   4. 4.Country as string
2. CSV file on Google Drive with columns to be mapped to the entity:
   1. 1.Customer\_ID
   2. 2.First\_Name
   3. 3.Last\_Name
   4. 4.Country
3. Connection is established through the Google Drive connector.

<br>