Get the value of the first cell of a named range from Google Sheets.

named_range.py

import pygsheets

def get_value_of_named_range_from_google_sheet(sheet_name: str, worksheet_title: str, range_name: str) -> str:
    """return the value of the first cell from a named range
       great for treating Google Sheets NamedRanges as variables in Python scripts"""
    
    # https://pygsheets.readthedocs.io/en/latest/authorizing.html
    gc = pygsheets.authorize(outh_file='client_secret.json', outh_nonlocal=True)
    
    sh = gc.open(sheet_name)
    wks = sh.worksheet_by_title(worksheet_title)
    named_range = wks.get_named_ranges(range_name)
    if named_range:
        return named_range[0][0].value