# Google Spreadsheet
The **Google Spreadsheet** task in **Gaio DataOS** allows you to import data directly from a **public Google Sheets document** into your data flow.\
This is ideal for real-time collaboration when data is managed externally by other teams, clients, or shared systems.
***
## How to Use
### **1. Open the Task**
Navigate to:\
**Tasks > ETL > Google Spreadsheet**
***
### **2. Fill in the Task Details**
* **Task label**: (Optional) A name to identify this task in the flow (e.g., `Import Client Sheet`).
* **Result table**: Name of the table that will be created or updated with the imported data.
* **Full URL or DOC output ID:** Provide the full public link to the spreadsheet or just the document ID (e.g., `1aB2C3D4E5FgHiJ`)
{% hint style="danger" %}
**Important Requirements:**
* The spreadsheet must be **publicly web** (Anyone with the link can view) and comma separed value.
* The **first row** must contain the **column headers**
* Avoid **whitespace** or **special characters** in column names for best compatibility
{% endhint %}
***
### **3. Configure Insert Mode (Optional)**
* **Insert mode: append records to table**\
If enabled, new data will be **appended** to the existing table.\
If disabled, the table will be **overwritten** with the spreadsheet’s current contents.
***
### **4. Save and Execute**
* Click **Save** to add the task to your flow.
* When executed, the spreadsheet data will be fetched and loaded into the specified table.
***
#### Use Cases
* Import lists or forms shared by external teams or clients
* Connect spreadsheets maintained by business units (e.g., marketing, sales, finance)
* Automate reports based on manually updated Google Sheets
* Integrate legacy system data shared via Google Sheets
---
# 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.gaiodataos.com/tools/tasks/etl/google-spreadsheet.md?ask=
```
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.