Michael mick-d

## import gsheet to dataframe.py
from Google import Create_Service
import pandas as pd

CLIENT_SECRET_FILE = 'client_secret.json'
API_SERVICE_NAME = 'sheets'
API_VERSION = 'v4'
SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']
gsheetId = '<Google Sheet Id>'

s = Create_Service(CLIENT_SECRET_FILE, API_SERVICE_NAME, API_VERSION, SCOPES)

## Generate_GitSHA1_forAfile.sh
(echo -en "blob $(cat $file|wc -c)\00";cat $file)|sha1sum -b | cut -d " " -f 1

            or of course

git hash-object $file
	from Google import Create_Service
	import pandas as pd

	CLIENT_SECRET_FILE = 'client_secret.json'
	API_SERVICE_NAME = 'sheets'
	API_VERSION = 'v4'
	SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']
	gsheetId = '<Google Sheet Id>'

	s = Create_Service(CLIENT_SECRET_FILE, API_SERVICE_NAME, API_VERSION, SCOPES)
	(echo -en "blob $(cat $file\|wc -c)\00";cat $file)\|sha1sum -b \| cut -d " " -f 1

	or of course

	git hash-object $file