bricolage-spreadsheet

gem 'bricolage-spreadsheet'

% bundle exec bricolage spreadsheet-import -h
Usage: bricolage spreadsheet-import [job_class_options]
        --src-ds=NAME                [optional] Main data source. [default: spreadsheet]
        --sheet-id=ID                Spreadsheet ID
        --range=RANGE_EXPR           Spreadsheet Range
        --format=VALUE               [optional] Data file format. (csv, json)
        --value-render-option=VALUE  [optional] For values with format on sheets (FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA)
        --s3-ds=NAME                 [optional] Main data source. [default: s3]
        --s3-file=PATH               Target file name.
        --dest-ds=NAME               [optional] Main data source. [default: psql]
        --dest-table=[SCHEMA.]TABLE  [optional] Target table name.
        --options=OPTIONS            [optional] Loader options.
        --table-def=PATH             Create table file.
        --no-backup                  [optional] Drop dest table with suffix "_old".
        --analyze                    [optional] ANALYZE table after SQL is executed.
        --grant=KEY:VALUE            [optional] GRANT table after SQL is executed. (required keys: privilege, to)
        --gzip                       [optional] Compress Temporary files.
    -v, --variable=NAME=VALUE        Set variable.
        --help                       Shows this message and quit.
        --version                    Shows program version and quit.