Last active
January 3, 2022 21:59
-
-
Save mantrax314/f923b6fce4c5906a681e18fa9ade9f7e to your computer and use it in GitHub Desktop.
Insert empty row in google spreadsheet using Golang
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package main | |
import ( | |
"context" | |
"encoding/json" | |
"fmt" | |
"golang.org/x/oauth2" | |
"golang.org/x/oauth2/google" | |
"google.golang.org/api/option" | |
"google.golang.org/api/sheets/v4" | |
"io/ioutil" | |
"log" | |
"net/http" | |
"net/url" | |
"os" | |
) | |
// 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 string | |
if _, err := fmt.Scan(&authCode); err != nil { | |
log.Fatalf("Unable to read authorization code: %v", err) | |
} | |
decodedValue, err := url.QueryUnescape(authCode) | |
if err != nil { | |
log.Fatalf("Unable to decode: %s", authCode) | |
} | |
tok, err := config.Exchange(context.TODO(), decodedValue) | |
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) { | |
log.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 := ioutil.ReadFile("client.json") | |
if err != nil { | |
log.Fatalf("Unable to read client secret file: %v", err) | |
} | |
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(config) | |
srv, err := sheets.NewService(ctx, option.WithHTTPClient(client)) | |
if err != nil { | |
log.Fatalf("Unable to retrieve Sheets client: %v", err) | |
} | |
spreadsheetId := "{sheed_id}" | |
req := sheets.Request{ | |
InsertDimension: &sheets.InsertDimensionRequest{ | |
InheritFromBefore: false, | |
Range: &sheets.DimensionRange{ | |
Dimension: "ROWS", | |
StartIndex: 1, | |
EndIndex: 2, | |
SheetId: 0, | |
}, | |
}, | |
} | |
requests := &sheets.BatchUpdateSpreadsheetRequest{ | |
Requests: []*sheets.Request{&req}, | |
} | |
_, err = srv.Spreadsheets.BatchUpdate(spreadsheetId, requests).Context(ctx).Do() | |
if err != nil { | |
log.Fatalf("Unable to handle data from sheet: %v", err) | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Please check the GO Quick Start Tutorial from Google in order to make run the whole script