Contents x
    Data Source - Google Spreadsheets
    • 03 Mar 2022
    • Print
    • Dark
      Light
    • PDF
    Contents

    Data Source - Google Spreadsheets

    • Updated on 03 Mar 2022
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    Overview

    Help page for setting up a data transfer from Google Spreadsheets.

    Supported Protocol

    Data Loader: Embulk
    Using the embulk-input-google_spreadsheets plugin.

    Limitations

    None.

    Settings

    STEP 1: General Settings

    Field Name
    Required
    Default Value
    Description
    Google Spreadsheets Connection ConfigurationYes-From the Google Spreadsheets Connection Configurations created in advance, select the one with the necessary permissions for this transfer.
    If you have not previously created any Connection Configurations, click the Add Connection Configuration button to set up a new one.
    Spreadsheets URLYes-Enter the URL for the spreadsheets you wish to extract.
    For example: https://docs.google.com/spreadsheets/d/XXX-XXX/edit#gid=0
    Sheet NameYes-Enter the sheet name you wish to extract.
    Starting Row NumberYes-Enter the starting row number of the data you wish to extract.
    Default Time ZoneYesAsia/TokyoSpecify the time zone for the timestamps within the sheets.
    Note: timestamps within the sheets don’t contain time zone information.
    Null StringNo-Enter a specific string value that you wish to set as null.
    Column SettingsYes-Specify the column name, and data type, for the data you wish to extract.
    You can choose from the following data types:
  • string
  • long
  • double
  • timestamp
  • boolean
  • json
    • Was this article helpful?
    What's Next