Skip to content

Instantly share code, notes, and snippets.

@mantrax314
Last active January 3, 2022 21:59
Show Gist options
  • Save mantrax314/f923b6fce4c5906a681e18fa9ade9f7e to your computer and use it in GitHub Desktop.
Save mantrax314/f923b6fce4c5906a681e18fa9ade9f7e to your computer and use it in GitHub Desktop.
Insert empty row in google spreadsheet using Golang
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)
}
}
@mantrax314
Copy link
Author

Please check the GO Quick Start Tutorial from Google in order to make run the whole script

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment