How to Write Data to Google Sheets Using the Go API V4?

Writing Data in Google Sheets API V4 for Go

While the Quickstart guide for reading data from Google Sheets is comprehensive, writing data to sheets can be daunting, especially for beginners. Despite searching, there seems to be a lack of examples showcasing this process.

To address this, let's examine an updated main function that demonstrates data writing:

<code class="go">func write() {
    ctx := context.Background()
    b, err := ioutil.ReadFile("./Google_Sheets_API_Quickstart/client_secret.json")
    if err != nil {
        log.Fatalf("Unable to read client secret file: %v", err)
    }

    // If modifying these scopes, delete your previously saved credentials
    // at ~/.credentials/sheets.googleapis.com-go-quickstart.json
    config, err := google.ConfigFromJSON(b, "https://www.googleapis.com/auth/spreadsheets")
    if err != nil {
        log.Fatalf("Unable to parse client secret file to config: %v", err)
    }

    client := getClient(ctx, config)
    srv, err := sheets.New(client)
    if err != nil {
        log.Fatalf("Unable to retrieve Sheets Client %v", err)
    }

    spreadsheetId := "YOUR SPREADSHEET ID"

    writeRange := "A1"

    var vr sheets.ValueRange

    myval := []interface{}{"One", "Two", "Three"}
    vr.Values = append(vr.Values, myval)

    _, err = srv.Spreadsheets.Values.Update(spreadsheetId, writeRange, &vr).ValueInputOption("RAW").Do()
    if err != nil {
        log.Fatalf("Unable to write data to sheet. %v", err)
    }
}</code>

In this example:

1. A client secret file is read to configure the Google Sheets API client.
2. The Spreadsheets.Values.Update method is used to update the values in the spreadsheet.
3. A value range is created to specify which cells to update (A1 in this case).
4. A list of values is set as the range's values ("One", "Two", "Three").
5. The ValueInputOption parameter is set to RAW to specify that the values should be inserted without formatting.
6. The method is executed, and any errors are reported.

By following this example, you can easily write data to your Google Sheets and gain full control over your spreadsheet.

The above is the detailed content of How to Write Data to Google Sheets Using the Go API V4?. For more information, please follow other related articles on the PHP Chinese website!