Documentation
  • The Fundamental
  • ACTIVE SYNC
    • Data Ingestion
      • Data Tracking
        • API Key Management
        • Generate Tracking ID
        • Install tracking with Tag Manager
        • Install Tracking from the Console
        • Tracking Method on Website
      • Datasource
        • MySQL
        • PostgreSQL
        • MongoDB
        • Microsoft SQL Server
        • Shopify
        • CSV
        • Google Sheets
    • Data Ingestion API
      • Data Lake
        • File upload
        • Tracking API
      • Data Warehouse
        • Batch upload
        • CSV upload
        • Tracking API
      • Data Schema Warehouse API
    • Data Integrations
      • Manage your API Key
      • Get Data using API
  • ROCKET.BI
    • Introduction
    • Data Warehouse
      • Data Management
      • Ad-hoc Query
        • Measure Schema
        • Calculated Field
      • Query Analysis
      • Relationship
    • Row-level Security
    • Dashboard
      • Dashboard Filter
      • Chart Control
        • Tab Control
        • Single Choice
        • Multiple Choice
        • Dropdown Control
        • Slicer Control
        • Date Control
        • Input Control
      • Manage Dashboard
        • Relationship
        • View and Share
        • Select Main Date Filter
        • Boost
        • Settings
        • Add Chart
        • Add Tab
        • Add Text
    • Chart Builder
      • Chart Types
        • Pie Chart
        • Column Chart
        • Bar Chart
        • Line Chart
        • Line Stock Chart
        • Pareto Chart
        • Bubble Chart
        • Scatter Chart
        • Map Chart
        • Area Chart
        • KPI Chart
        • Lollipop Chart
        • Parliament Chart
        • Funnel Chart
        • Pyramid Chart
        • Gauge Chart
        • Bullet Graph Chart
        • Heat Map Chart
        • Word Cloud Chart
        • Tree Map Chart
        • Stacked Column Chart
        • Stacked Bar Chart
        • Sankey Chart
        • Spider Web Chart
        • Wind Rose Chart
        • Histogram Chart
        • Bell Curve Chart
        • Table Chart
        • Pivot Table Chart
      • Chart Settings
        • Zoom
        • Inner chart filter
      • Chart Filters
        • Tab Filter
        • Single Choice
        • Multiple Choice
        • Dropdown Filter
        • Slicer Filter
        • Date Filter
        • Input Filter
      • Right-click Settings
        • Change date function
        • Drill down
        • Drill through
        • Use as a filter
    • SQL Query
      • Syntax
      • Functions
      • Aggregate Functions
      • Data Types
  • UNLOCK.CI
    • Unlock.CI
Powered by GitBook
On this page
  • 1. What is Google Sheets?
  • 2. Add Google Sheets Data Source
  • 3. Add Google Sheets job
  • 4. Demo
  1. ACTIVE SYNC
  2. Data Ingestion
  3. Datasource

Google Sheets

PreviousCSVNextData Ingestion API

Last updated 1 year ago

1. What is Google Sheets?

Google Sheets is Google's cloud-based spreadsheet application within the Google Drive service. It allows users to edit, organize, and analyze different kinds of data. It supports collaborations and enables simultaneous editing and formatting by multiple users in real-time. Every modification is automatically saved, and you can view changes as they are made.

2. Add Google Sheets Data Source

1. Click Add Data Source

2. In the menu, select Google Sheets

3. Click Access to Google Account in the pop-up window

4. Choose a Google account to continue and allow datainsider.co to access your data

5. Select one spreadsheet suggested on the list, then select one sheet contained in the selected spreadsheet

6. Click Next, your Google Sheets will preview some first rows

  • You can use the first row in the sheet as headers or let it generated.

  • You can change the data type of each header. It supports basic types to represent logical values, numbers, and strings.

7. Click Next to add Google Sheets job

3. Add Google Sheets job

1. Config information for Google Sheets

  • Job name: input the display name of the sheet

  • Select or create new database: select one database suggested in the data source, or you can create new database.

  • Select or create new table: select one table suggested in the list, or you can create new table.

  • Scheduler type: choose the type you want to sync

  • Run only once: only runs one time at a designated Date and Time

  • Recurring: set up the repeated sync using the time scheduler

  • Frequency: select the time interval between the data sync

2. Click Next

3. Check your synced job: Synced Jobs will be displayed in Jobs with the information of their mode, status, date synced, and action. You can click Force Sync to sync manually to ensure you access the up-to-date data.

4. Click the Jobs History to see what jobs have been done in the system so far. You can track all the activities of the jobs, including the time, the number of occurrences, and how many columns each job has generated.

4. Demo

This is a demo of the entire process of adding Google Sheets Data Source.

We hope that the above instructions will be useful to you. Let's have a look at our other articles to learn more about adding other databases with Data Insider.