import gspread
from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint

scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/spreadsheets",
         "https://www.googleapis.com/auth/drive.file", "https://www.googleapis.com/auth/drive"]

creds = ServiceAccountCredentials.from_json_keyfile_name(
    "renamed_file_name.json", scope)

client = gspread.authorize(creds)
sheet = client.open("file_name").sheet1

data = sheet.get_all_values()

pprint(data)

6c51a6dd27258c57cc30d0aab3212628ad58c051
<mask token>

<mask token>
pprint(data)

<mask token>
scope = ['https://spreadsheets.google.com/feeds',
    'https://www.googleapis.com/auth/spreadsheets',
    'https://www.googleapis.com/auth/drive.file',
    'https://www.googleapis.com/auth/drive']
creds = ServiceAccountCredentials.from_json_keyfile_name(
    'renamed_file_name.json', scope)
client = gspread.authorize(creds)
sheet = client.open('file_name').sheet1
data = sheet.get_all_values()
pprint(data)

import gspread
from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint
scope = ['https://spreadsheets.google.com/feeds',
    'https://www.googleapis.com/auth/spreadsheets',
    'https://www.googleapis.com/auth/drive.file',
    'https://www.googleapis.com/auth/drive']
creds = ServiceAccountCredentials.from_json_keyfile_name(
    'renamed_file_name.json', scope)
client = gspread.authorize(creds)
sheet = client.open('file_name').sheet1
data = sheet.get_all_values()
pprint(data)

import gspread
from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint

scope = ["https://spreadsheets.google.com/feeds", "https://www.googleapis.com/auth/spreadsheets",
         "https://www.googleapis.com/auth/drive.file", "https://www.googleapis.com/auth/drive"]

creds = ServiceAccountCredentials.from_json_keyfile_name(
    "renamed_file_name.json", scope)

client = gspread.authorize(creds)
sheet = client.open("file_name").sheet1

data = sheet.get_all_values()

pprint(data)
