Find spreadsheetId from Google Sheet URL (https://go.dev/play/p/aMfoBAQU7cC)

README.md

Spreadsheet The primary object in Google Sheets that can contain multiple sheets, each with structured information contained in cells. A Spreadsheet resource represents every spreadsheet and has a unique spreadsheetId value, containing letters, numbers, hyphens, or underscores. You can find the spreadsheet ID in a Google Sheets URL:

https://docs.google.com/spreadsheets/d/spreadsheetId/edit#gid=0

find_spreadsheetId_from_google_sheet_url.go

// You can edit this code!
// Click here and start typing.
// Go Playground
// https://go.dev/play/p/aMfoBAQU7cC
package main

import (
	"fmt"
	"regexp"
)

func main() {
	fmt.Println("Hello, 世界")
	url := "https://docs.google.com/spreadsheets/d/1utmrKTMtNP7fJfWsEPtjymKJCOwcZYh3L3ItxBECMno/edit#gid=1688759439"
	fmt.Println("spreadsheetId: ", getSpreadSheetIdFromUrl(url))
}

func getSpreadSheetIdFromUrl(spreadSheetUrl string) string {
	var re = regexp.MustCompile(`(?m)spreadsheets\/d\/(?P<spreadsheetId>.+?)\/edit`)

	spreadsheetIdGroupIndex := re.SubexpIndex("spreadsheetId")
	matchs := re.FindStringSubmatch(spreadSheetUrl)
	if len(matchs) > spreadsheetIdGroupIndex {
		return matchs[spreadsheetIdGroupIndex]
	}
	return ""
}