Googly Sheets Python API in usable format

gsheet.py

from __future__ import print_function
import httplib2
import os

from apiclient import discovery
from oauth2client import client
from oauth2client import tools
from oauth2client.file import Storage

SCOPES = 'https://www.googleapis.com/auth/spreadsheets'
CLIENT_SECRET_FILE = '/home/googly/client_secret.json'
APPLICATION_NAME = 'Google Sheets API Python Quickstart'
try:
    import argparse
    flags = argparse.ArgumentParser(parents=[tools.argparser]).parse_args()
except ImportError:
    flags = None


def get_credentials(allowask=1):
    """Gets valid user credentials from storage.

    If nothing has been stored, or if the stored credentials are invalid,
    the OAuth2 flow is completed to obtain the new credentials.

    Returns:
        Credentials, the obtained credential.
    """

    home_dir = os.path.expanduser('~')
    credential_dir = os.path.join(home_dir, '.credentials')
    if not os.path.exists(credential_dir):
        os.makedirs(credential_dir)
    credential_path = os.path.join(credential_dir,'sheets.googleapis.com-python-quickstart.json')
    store = Storage(credential_path)
    credentials = store.get()
    if not allowask:return credentials
    if not credentials or credentials.invalid:
        flow = client.flow_from_clientsecrets(CLIENT_SECRET_FILE, SCOPES)
        flow.user_agent = APPLICATION_NAME
        if flags:
            credentials = tools.run_flow(flow, store, flags)
        else: # Needed only for compatibility with Python 2.6
            credentials = tools.run(flow, store)
        print('Storing credentials to ' + credential_path)
    return credentials

def _getservice():
    credentials = get_credentials()
    http = credentials.authorize(httplib2.Http())
    discoveryUrl = ('https://sheets.googleapis.com/$discovery/rest?'+'version=v4')
    service = discovery.build('sheets', 'v4', http=http,discoveryServiceUrl=discoveryUrl,cache_discovery=False) #NOcacheError logs ke liye false

    #remove bekaar import error gapi logs
    import logging
    logging.getLogger('googleapicliet.discovery_cache').setLevel(logging.ERROR)

    return service

def create(name):
    shid=""
    service=_getservice()
    spreadsheet_body = {"properties": {"title": name}}
    request = service.spreadsheets().create(body=spreadsheet_body)
    response = request.execute()
    shid=response['spreadsheetId']
    return shid

def read(shid,Crange):
    service=_getservice()
    spreadsheetId = shid
    rangeName = Crange
    result = service.spreadsheets().values().get(spreadsheetId=spreadsheetId, range=rangeName).execute()
    values = result.get('values', [])
    return values

def write(shid,Crange,Values):
    service=_getservice()
    spreadsheetId = shid
    rangeName = Crange
    body = {'values': Values}
    result = service.spreadsheets().values().update(spreadsheetId=shid, range=Crange,valueInputOption="RAW", body=body).execute()
    return result

def clear(shid):
    service=_getservice()
    spreadsheetId = shid
    rangeName = "Sheet1"
    result = service.spreadsheets().values().clear(spreadsheetId=spreadsheetId, range=rangeName,body={}).execute()
    return result

def revoke():
    credentials = get_credentials(0)
    if credentials:credentials.revoke(httplib2.Http())