-
Notifications
You must be signed in to change notification settings - Fork 0
/
example.py
48 lines (38 loc) · 1.86 KB
/
example.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
from __future__ import print_function
from google.oauth2 import service_account
from googleapiclient.discovery import build
from googleapiclient.errors import HttpError
###############################################################################
# This file currently exists as an example of how to properly make a 'GET' #
# call to the Google Sheets API. It will be deprecated once these calls have #
# have actually been implemented in the application. For now, it just reads #
# a specified range of the data. #
###############################################################################
# We want to use the sheets API, and we have our credentials that basically say
# "Hey you can read/write from/to this spreadhseet"
SCOPES = ['https://www.googleapis.com/auth/spreadsheets']
SERVICE_ACCOUNT_FILE = 'credentials.json'
# Credentials
creds = None
creds = service_account.Credentials.from_service_account_file(SERVICE_ACCOUNT_FILE, scopes=SCOPES)
# Spreadsheet ID
SPREADSHEET_ID = '1-YyaXWPFTFYzaIdT1Ot3WL1uG2k1xQykmCSItOy5zag'
# this block of code is wrapped in a try/except block so that if the call fails,
# it will print the error.
try:
# construct our service that is going to make the API call for us
service = build('sheets', 'v4', credentials=creds)
# get the sheets service
sheet = service.spreadsheets()
# this makes the actual call that 'gets' the data from our sheets. It
# knows what to get because we give it our unique sheet ID and the range
# we want to retrieve.
result = sheet.values().get(spreadsheetId=SPREADSHEET_ID,
range="Data!A2:M39").execute()
# get the values returned from our call
values = result.get('values', [])
# print these results
print(values)
except HttpError as err:
# if there's an error, print it
print(err)