> For the complete documentation index, see [llms.txt](https://docs.gaiodataos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gaiodataos.com/tools/tasks/etl/google-spreadsheet.md). # 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