GSheetsToUnicode

This Go package provides a simple way to extract a list of unique Unicode characters from a Google Sheets document

Installation

To use this package, you need to have Go installed on your machine. Then, you can install the package by running:

go get github.com/FuVy/GSheetsToUnicode

Usage

To use this package, you need to provide the following environment variables:

• API_KEY: Your Google API key.
• SPREADSHEET_ID: The ID of the Google Sheets document.
• INPUT_FILE: The path to the input file containing the ranges to read from the Google Sheets document.
• OUTPUT_FILE: The path to the output file where the Unicode characters will be written.

You can set these environment variables in your shell or in a .env file.

Here's an example of how to use this package:

package main

import (
	"github.com/FuVy/GSheetsToUnicode"
	"github.com/FuVy/GSheetsToUnicode/pkg/env"
	"github.com/joho/godotenv"
)

func main() {
	_ = godotenv.Load()

	// Your Google API key
	apiKey := env.GetOrPanicOnEmpty("API_KEY")

	// The ID of the spreadsheet to retrieve data from.
	spreadsheetId := env.GetOrPanicOnEmpty("SPREADSHEET_ID")
	inputPath := env.GetOrPanicOnEmpty("INPUT_FILE")
	outputPath := env.GetOrPanicOnEmpty("OUTPUT_FILE")

	GSheetsToUnicode.ParseAndWrite(apiKey, spreadsheetId, inputPath, outputPath)
}

Here's an example of a file that can be used as input for the program:

Sheet1!A1:B2
Sheet2!C2:C100

This file contains two lines, each representing a range of cells in a Google Sheets document. The first line represents the range A1:B2 in Sheet1, and the second line represents the range C2:C100 in Sheet2. The program will extract the Unicode characters from these ranges and write them to an output file.