Install Client Libraries

Stay organized with collections Save and categorize content based on your preferences.

The Google Sheets API is built on HTTP and JSON, so any standard HTTP client can send requests to it and parse the responses.

However, the Google API client libraries provide better language integration, improved security, and support for making calls that require user authorization. The client libraries are available in a number of programming languages; by using them you can avoid the need to manually set up HTTP requests and parse the responses.

To get started, select the programming language that you are using for development.

Go

Get the latest Google Sheets API client library for Go (alpha). Read the client library's developer's guide.

Java

This page contains information about getting started with the Google Sheets API by using the Google API Client Library for Java. For more information, see the following documentation:

Add the client library to your project

Select your build environment (Maven or Gradle) from the following tabs:

JavaScript

Read the client library's developer's guide.

.NET

This page contains information about getting started with the Google Sheets API by using the Google API Client Library for .NET. For more information, see the following documentation:

Downloading the library

Install the NuGet package: Google.Apis.

Node.js

Get the latest Google Sheets API client library for Node.js. Read the client library's developer's guide.

Obj-C

Get the latest Google Sheets API client library for Objective-C. Read the client library's developer's guide.

PHP

Get the latest Google Sheets API client library for PHP (beta). Read the client library's developer's guide.

Python

This page contains information about getting started with the Google Sheets API by using the Google API Client Library for Python. For more information, see the following documentation:

System requirements

Install the client library

You can either use a package manager or manually download and install the Python client library:

Managed install

Use pip or setuptools to manage your installation. You might need to run sudo first.

  • pip (preferred):
    pip install --upgrade google-api-python-client
  • Setuptools:
    easy_install --upgrade google-api-python-client

Manual install

  1. Download the latest client library for Python.
  2. Unpack the code.
  3. Install:
    python setup.py install

App Engine

Because the Python client libraries aren't installed in the App Engine Python runtime environment, you must copy them into your application just like third-party libraries.

Ruby

This page contains information about getting started with the Google Sheets API by using the Google API Client Library for Ruby. For more information, see the following documentation:

Install the google-api-client gem

Depending on your system, you might need to prepend these commands with sudo.

If you haven't installed the Google API Client Library for Ruby before, install by using RubyGems:

gem install google-api-client

If you already have the gem installed, update to the latest version:

gem update -y google-api-client

Get started with the Google API Client Library for Ruby

To learn how to make your first request, see the Get started guide.

Other ways to access the Google Sheets API

The following table lists other ways to access the Google Sheets API:

Access method Description
APIs Explorer An interactive tool that lets you try out Google APIs right from your browser.