Low commit activity in last 3 years
This Ruby library provides a convenient interface for reading and writing files and spreadsheets stored in Google Drive and Google Docs. It supports authentication, worksheet manipulation, and now includes background color styling and Cell object access.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
 Dependencies

Development

>= 3.4.0, < 4.0.0
>= 3.0.0, < 4.0.0
>= 0.8.0

Runtime

>= 1.5.3, < 2.0.0
>= 0.5.0
 Project Readme

google-drive-ruby

Gem GitHub Actions Workflow Status

This is a Ruby library to read/write files/spreadsheets in Google Drive/Docs.

NOTE: This is NOT a library to create Google Drive App.

NOTE: ⚠️This is an unofficial maintained fork of google-drive-ruby, originally created by Hiroshi Ichikawa. We focus on preserving compatibility and fixing bugs, with minimal disruptive changes. New features may be added carefully when justified, but the core behavior will remain stable.

✅ GitHub Actions Integration We've started testing this library with GitHub Actions: 👉 CI Workflow Link

This enables automated testing on every push and pull request, helping ensure long-term reliability. We welcome feedback and contributions to improve the CI process or test coverage. 🤗

There are some incompatible API changes. See MIGRATING.md.

Add this line to your application's Gemfile:

gem 'google_drive_maintained'

And then execute:

$ bundle

Or install it yourself as:

$ gem install google_drive_maintained

If you need system wide installation, execute below:

$ sudo gem install google_drive_maintained

Authorization

Follow one of the options in Authorization to construct a session object. The example code below assumes "On behalf of you" option.

Example to read/write files in Google Drive

require "google_drive"

# Creates a session. This will prompt the credential via command line for the
# first time and save it to config.json file for later usages.
# See this document to learn how to create config.json:
# https://github.com/gimite/google-drive-ruby/blob/master/doc/authorization.md
session = GoogleDrive::Session.from_config("config.json")

# Gets list of remote files.
session.files.each do |file|
  p file.title
end

# Uploads a local file.
session.upload_from_file("/path/to/hello.txt", "hello.txt", convert: false)

# Downloads to a local file.
file = session.file_by_title("hello.txt")
file.download_to_file("/path/to/hello.txt")

# Updates content of the remote file.
file.update_from_file("/path/to/hello.txt")

Example to read/write spreadsheets

require "google_drive"

# Creates a session. This will prompt the credential via command line for the
# first time and save it to config.json file for later usages.
# See this document to learn how to create config.json:
# https://github.com/gimite/google-drive-ruby/blob/master/doc/authorization.md
session = GoogleDrive::Session.from_config("config.json")

# First worksheet of
# https://docs.google.com/spreadsheet/ccc?key=pz7XtlQC-PYx-jrVMJErTcg
# Or https://docs.google.com/a/someone.com/spreadsheets/d/pz7XtlQC-PYx-jrVMJErTcg/edit?usp=drive_web
ws = session.spreadsheet_by_key("pz7XtlQC-PYx-jrVMJErTcg").worksheets[0]

# Gets content of A2 cell.
p ws[2, 1]  #==> "hoge"

# Changes content of cells.
# Changes are not sent to the server until you call ws.save().
ws[2, 1] = "foo"
ws[2, 2] = "bar"
ws.save

# Dumps all cells.
(1..ws.num_rows).each do |row|
  (1..ws.num_cols).each do |col|
    p ws[row, col]
  end
end

# Yet another way to do so.
p ws.rows  #==> [["fuga", ""], ["foo", "bar]]

# Reloads the worksheet to get changes by other clients.
ws.reload

New BSD Licence.

Ruby 3.0.0 or later. Checked with Ruby 3.3.0.

Hiroshi Ichikawa