Google Sheets Ruby output plugin for Embulk

Dumps records to Google Sheets.

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

• if auth_method is service_account, set the service account credential json file path.
• if auth_method is authorized_user, this plugin supposes the format is the below. https://github.com/medjed/embulk-input-google_spreadsheets#prepare-json-file-for-auth_method-authorized_user

{
  "client_id": "xxxxxxxxxxx.apps.googleusercontent.com",
  "client_secret": "xxxxxxxxxxx",
  "refresh_token": "xxxxxxxxxxx"
}

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

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

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 can be overwritten or added. Please check the official API reference.

• update : https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update
• append : https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append

$ rake