GoSpread - Google Spreadsheets utility

GoSpread wraps google.golang.org/api/sheets/v4.

Features

• manage sheets
  • create, sort, move

Installing

Use go get to install the library.

go get -u github.com/duhshu/gospread

Install gospraed command.

go get github.com/duhshu/gospread/cmd/gospread

Usage

1. Enable sheets api to https://console.developers.google.com/.
2. Create service account, and create key and download to creadential.json
3. Share a sheets for service account email.

gospread sheets create sheet-name <spread-sheet-id>

your application.

import "github.com/duhshu/gospread"

func main() {
	g, err := gospread.NewGoSpreadWithCredentialFile("credential.json")
	if err != nil {
		fmt.Fatal(err)
	}
	if err := g.CreateSheet("spread-sheet-id", "new-sheet-name"); err != nil {
		fmt.Printf("createTestSheet error=%s", err)
	}
}

Author

duhshu

Licence

MIT