# Google Drive connector as a source

The ETL pipeline, to transfer customer data from a csv file on Google Drive to a Langstack entity, is created as follows.

{% hint style="info" %}
To see step-by-step instructions of how to create an ETL pipeline, [click here](/welcome/get-started/learn-langstack/introduction-to-etl-pipeline.md).
{% endhint %}

* An ETL pipeline named “TestGDrivetoEntity” is created.​​

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/testgdtoentityname.png" alt=""><figcaption></figcaption></figure>

* To connect to the data source, the necessary information is added as follows:
  * The “Connector” tab is selected.
  * For this example, “GDrive123” is selected from the drop-down menu. The connector can be added by selecting a connector from the drop-down menu or a new connector can be created by clicking the \[+] button.
  * To go to the settings, click the “Edit the settings” arrow.​​

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/dsgd1.png" alt=""><figcaption></figcaption></figure>

* To connect to the data destination, the necessary information is added in the Data destination section:
  * The “Entity” tab is selected.
  * The “Test\_Customers\_Entity” entity is selected from the drop-down menu.​​

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/ddcustdataentity.png" alt=""><figcaption></figcaption></figure>

* To disallow multiple simultaneous runs of the ETL pipeline, the toggle button is left enabled for “skip execution while in progress”. Enabling this toggle button defines that the execution of this ETL pipeline will be skipped when there is one already in progress.​​

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdskipexecution.png" alt=""><figcaption></figcaption></figure>

* The default selection for ETL pipeline execution is “Immediate”.​​

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdimmediate.png" alt=""><figcaption></figcaption></figure>

* To align the source fields with destination fields, the settings for the reader and writer format are defined in the “Data Format” tab. The “Reader” tab is selected by default.
* To update the settings for how the data should be read:
  1. The reader stream should be “CSV Stream".
  2. To add the reader details, click on the “Edit the settings” arrow.​​

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdreadcsvstream.png" alt=""><figcaption></figcaption></figure>

* To add details necessary to read the records, the settings in this section “Google drive CSV format details:” are defined as follows:
  1. In the field “File path or File URL or Folder path or Folder URL” the Google drive folder name is entered "GDriveTest".
  2. The “File name” is entered as “customersData”.
  3. The “CharacterSet” is selected as “Unicode(UTF-8)”.
  4. The “Language” is selected as “English”.
  5. The field “Start reading CSV from line” is defined as “1”.
  6. The “separator” is selected as “Comma”.​​

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdsrccsvformatdet1.png" alt=""><figcaption></figcaption></figure>

* In the “Sample data”, the column names of the source file are pasted: “Customer\_ID,First,Last,Country”.​​

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdsampledata.png" alt=""><figcaption></figcaption></figure>

* When the Sample data is saved, source fields are displayed.
  * The column names are copied to Source Fields by clicking “Copy to Source Fields”.
  * Click on "Accept & Collapse" to save the information.

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdsrccsvformatdet2accncol.png" alt=""><figcaption></figcaption></figure>

* ​​For this example, the source fields are added as per the image below.

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdsrcsrcfields.png" alt=""><figcaption></figcaption></figure>

* The “Writer” mode is “Append”.

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdwritmodeappend.png" alt=""><figcaption></figcaption></figure>

* In the Field Mapping section, all the “Mapped Fields” are added and aligned.

<figure><img src="https://media.langstack.com/documentation/media/images/connector/googledriveconnector/gdsrcfieldmapping.png" alt=""><figcaption></figcaption></figure>

* When the ETL pipeline is executed (after Save and Publish), the records will be added to the destination.<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.langstack.com/welcome/in-depth-learning/connectors/google-drive-connector/using-google-drive-connector-in-etl-pipeline/google-drive-connector-as-a-source.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.