Go quickstart  |  Google Sheets  |  Google for Developers (2024)

• Home
• Google Workspace
• Google Sheets
• Guides

Quickstarts explain how to set up and run an app that calls aGoogle Workspace API.

Google Workspace quickstarts use the API client libraries to handle somedetails of the authentication and authorization flow. We recommend thatyou use the client libraries for your own apps. This quickstart uses asimplified authentication approach that is appropriate for a testingenvironment. For a production environment, we recommend learning aboutauthentication and authorizationbeforechoosing the access credentialsthat are appropriate for your app.

Create a Go command-line application that makes requests to theGoogle Sheets API.

Objectives

• Set up your environment.
• Set up the sample.
• Run the sample.

Prerequisites

• Latest version of Go.
• Latest version of Git.
• A Google Cloud project.

• A Google Account.

Set up your environment

To complete this quickstart, set up your environment.

Enable the API

Before using Google APIs, you need to turn them on in a Google Cloud project.You can turn on one or more APIs in a single Google Cloud project.

• In the Google Cloud console, enable the Google Sheets API.

  Enable the API

Configure the OAuth consent screen

If you're using a new Google Cloud project to complete this quickstart, configurethe OAuth consent screen and add yourself as a test user. If you've alreadycompleted this step for your Cloud project, skip to the next section.

1. In the Google Cloud console, go to Menu menu > APIs & Services > OAuth consent screen.

   Go to OAuth consent screen

2. For User type select Internal, then click Create.
3. Complete the app registration form, then click Save and Continue.

4. For now, you can skip adding scopes and click Save and Continue. In the future, when you create an app for use outside of your Google Workspace organization, you must change the User type to External, and then, add the authorization scopes that your app requires.

5. Review your app registration summary. To make changes, click Edit. If the app registration looks OK, click Back to Dashboard.

Authorize credentials for a desktop application

To authenticate end users and access user data in your app, you need tocreate one or more OAuth 2.0 Client IDs. A client ID is used to identify asingle app to Google's OAuth servers. If your app runs on multiple platforms,you must create a separate client ID for each platform.

1. In the Google Cloud console, go to Menu menu > APIs & Services > Credentials.

   Go to Credentials

2. Click Create Credentials > OAuth client ID.
3. Click Application type > Desktop app.
4. In the Name field, type a name for the credential. This name is only shown in the Google Cloud console.
5. Click Create. The OAuth client created screen appears, showing your new Client ID and Client secret.
6. Click OK. The newly created credential appears under OAuth 2.0 Client IDs.
7. Save the downloaded JSON file as credentials.json, and move the file to your working directory.

Prepare the workspace

1. Create a working directory:

   mkdir quickstart

2. Change to the working directory:

   cd quickstart

3. Initialize the new module:

   go mod init quickstart

4. Get the Google Sheets API Go client library and OAuth2.0 package:

   go get google.golang.org/api/sheets/v4go get golang.org/x/oauth2/google

Set up the sample

1. In your working directory, create a file named quickstart.go.

2. In the file, paste the following code:

   sheets/quickstart/quickstart.go

   View on GitHub

   package mainimport ("context""encoding/json""fmt""log""net/http""os""golang.org/x/oauth2""golang.org/x/oauth2/google""google.golang.org/api/option""google.golang.org/api/sheets/v4")// Retrieve a token, saves the token, then returns the generated client.func getClient(config *oauth2.Config) *http.Client {// The file token.json stores the user's access and refresh tokens, and is// created automatically when the authorization flow completes for the first// time.tokFile := "token.json"tok, err := tokenFromFile(tokFile)if err != nil {tok = getTokenFromWeb(config)saveToken(tokFile, tok)}return config.Client(context.Background(), tok)}// Request a token from the web, then returns the retrieved token.func getTokenFromWeb(config *oauth2.Config) *oauth2.Token {authURL := config.AuthCodeURL("state-token", oauth2.AccessTypeOffline)fmt.Printf("Go to the following link in your browser then type the "+"authorization code: \n%v\n", authURL)var authCode stringif _, err := fmt.Scan(&authCode); err != nil {log.Fatalf("Unable to read authorization code: %v", err)}tok, err := config.Exchange(context.TODO(), authCode)if err != nil {log.Fatalf("Unable to retrieve token from web: %v", err)}return tok}// Retrieves a token from a local file.func tokenFromFile(file string) (*oauth2.Token, error) {f, err := os.Open(file)if err != nil {return nil, err}defer f.Close()tok := &oauth2.Token{}err = json.NewDecoder(f).Decode(tok)return tok, err}// Saves a token to a file path.func saveToken(path string, token *oauth2.Token) {fmt.Printf("Saving credential file to: %s\n", path)f, err := os.OpenFile(path, os.O_RDWR|os.O_CREATE|os.O_TRUNC, 0600)if err != nil {log.Fatalf("Unable to cache oauth token: %v", err)}defer f.Close()json.NewEncoder(f).Encode(token)}func main() {ctx := context.Background()b, err := os.ReadFile("credentials.json")if err != nil {log.Fatalf("Unable to read client secret file: %v", err)}// If modifying these scopes, delete your previously saved token.json.config, err := google.ConfigFromJSON(b, "https://www.googleapis.com/auth/spreadsheets.readonly")if err != nil {log.Fatalf("Unable to parse client secret file to config: %v", err)}client := getClient(config)srv, err := sheets.NewService(ctx, option.WithHTTPClient(client))if err != nil {log.Fatalf("Unable to retrieve Sheets client: %v", err)}// Prints the names and majors of students in a sample spreadsheet:// https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/editspreadsheetId := "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"readRange := "Class Data!A2:E"resp, err := srv.Spreadsheets.Values.Get(spreadsheetId, readRange).Do()if err != nil {log.Fatalf("Unable to retrieve data from sheet: %v", err)}if len(resp.Values) == 0 {fmt.Println("No data found.")} else {fmt.Println("Name, Major:")for _, row := range resp.Values {// Print columns A and E, which correspond to indices 0 and 4.fmt.Printf("%s, %s\n", row[0], row[4])}}}

Run the sample

1. In your working directory, build and run the sample:

   go run quickstart.go

2. The first time you run the sample, it prompts you to authorize access:
   1. If you're not already signed in to your Google Account, sign in when prompted. If you're signed in to multiple accounts, select one account to use for authorization.
   2. Click Accept.

   Your Go application runs and calls the Google Sheets API.

   Authorization information is stored in the file system, so the next time you run the sample code, you aren't prompted for authorization.

Next steps

• Troubleshoot authentication and authorization issues
• Sheets API reference documentation
• google-api-go-client section of GitHub