Gaio DataOS
Gaio DataOS
Gaio DataOS
  • 👋 Welcome to Gaio DataOS
  • GETTING STARTED
    • Gaio DataOS Console
    • Quickstart
  • FUNDAMENTALS
    • Data Projects
    • Studio
    • Database
    • Workflow
  • Data Sources
  • TASKS
    • ETL
      • Builder
      • SQL
      • Source SQL
      • Insert Table
      • Insert Row
      • Update
      • Delete
      • Create Table
      • Quick Table
      • Quick Upload
      • Pivot Table
      • Unpivot Table
      • REST
      • Parameters to Table
      • Table to Parameters
      • Define parameter value
      • Users
      • CSV Web
      • CSV Local
      • Google Spreadsheet
    • Analytics
      • Sample
      • Cluster
      • Principal Components
      • Association Rules
      • Forecast
      • Python
    • Delivery
      • Content
      • Form Card
      • Export CSV
    • Map Editor
Powered by GitBook
On this page
  • How to Use
  • 1. Open the Task
  • 2. Fill in the Task Details
  • 3. Configure Insert Mode (Optional)
  • 4. Save and Execute
  1. TASKS
  2. ETL

Google Spreadsheet

PreviousCSV LocalNextAnalytics

Last updated 9 days ago

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)

Important Requirements:

  • The spreadsheet must be publicly accessible (Anyone with the link can view)

  • The first row must contain the column headers

  • Avoid whitespace or special characters in column names for best compatibility

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