No commit activity in last 3 years
No release in over 3 years
Dumps records to Google Sheets.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Dependencies

Development

>= 1.10.6
>= 0.8.39
>= 10.0

Runtime

~> 0.11.0
 Project Readme

Google Sheets Ruby output plugin for Embulk

Dumps records to Google Sheets.

Overview

  • Plugin type: output
  • Load all or nothing: yes
  • Resume supported: no
  • Cleanup supported: no

Configuration

name type requirement default description
spreadsheet_id string required
credentials_path string optional "credentials.json" keyfile path
range string optional "A1"
auth_method string optional service_account service_account or authorized_user
mode string optional update update or append
about credentials_path
{
  "client_id": "xxxxxxxxxxx.apps.googleusercontent.com",
  "client_secret": "xxxxxxxxxxx",
  "refresh_token": "xxxxxxxxxxx"
}

Prepare JSON file for auth_method: authorized_user

You may use example/setup_authorized_user_credentials.rb to prepare OAuth token.

Go to GCP console > API Manager > Credentials > Create 'OAuth Client ID'. Get the client id and client secret.

Run setup_authorized_user_credentials.rb to get refresh_token.

bundle --path vendor/bundle
bundle exec ruby example/setup_authorized_user_credentials.rb

Example

out:
  type: google_sheets_ruby
  spreadsheet_id: YOUR_SPREAD_SHEET_ID
  credentials_path: /path/to/credentials.json
  range: A1

Prepare JSON file for auth_method: authorized_user

You may use example/setup_authorized_user_credentials.rb to prepare OAuth token.

Go to GCP console > API Manager > Credentials > Create 'OAuth Client ID'. Get the client id and client secret.

Run setup_authorized_user_credentials.rb to get refresh_token.

bundle --path vendor/bundle
bundle exec ruby example/setup_authorized_user_credentials.rb

mode

mode can be overwritten or added. Please check the official API reference.

Build

$ rake