QUICK SPREADSHEET MAC OSX
QUICK SPREADSHEET INSTALL
QUICK SPREADSHEET CODE

QUICK SPREADSHEET INSTALL

When running the pip install command you may receive the following error: To the latest version of httplib2 using this command: pip install -upgrade httplib2 TypeError: sequence item 0: expected str instance, bytes found Reload your ~/.bashrc file in any open terminal windows using the following with the value determined above: export PYTHONPATH=$PYTHONPATH: To fix the issue, add pip's install location to the PYTHONPATHĭetermine pip's install location with the following command: pip show six | grep 'Location:' | cut -d ' ' -f2Īdd the following line to your ~/.bashrc file, replacing Module (a dependency of the Python library) is loaded before the one that pip

QUICK SPREADSHEET MAC OSX

This error can occur in Mac OSX where the default installation of the six AttributeError: 'Module_six_moves_urllib_parse' object has no attribute 'urlparse' This section describes some common issues that you may encounter whileĪttempting to run this quickstart and suggests possible solutions. If you have problems, refer to the Troubleshoot the sample section. The app is authorized to access your data. Note: Authorization information is stored on the file system, so subsequentĮxecutions don't prompt for authorization. Select one account to use for the authorization. If you are signed in to multiple Google accounts, you are asked to

If you are not already signed in to your Google account, you are prompted.

If this is your first time running the sample, the sample opensĪ new window prompting you to authorize access to your data: # Print columns A and E, which correspond to indices 0 and 4.įrom the command-line, execute the following command: python quickstart.py Result = sheet.values().get(spreadsheetId=SAMPLE_SPREADSHEET_ID, Service = build('sheets', 'v4', credentials=creds) If creds and creds.expired and creds.refresh_token:įlow = om_client_secrets_file( # If there are no (valid) credentials available, let the user log in.

# created automatically when the authorization flow completes for the firstĬreds = om_authorized_user_file('token.json', SCOPES) # The file token.json stores the user's access and refresh tokens, and is SAMPLE_SPREADSHEET_ID = '1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms'

# The ID and range of a sample spreadsheet. # If modifying these scopes, delete the file token.json.

QUICK SPREADSHEET CODE

Include the following code in quickstart.py:įrom import Requestįrom import Credentialsįrom google_auth_oauthlib.flow import InstalledAppFlowįrom googleapiclient.discovery import buildįrom googleapiclient.errors import HttpError

In your working directory, create a file named quickstart.py.

To install the Google client library for Python, run the following command: pip install -upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlibįor alternate installation options, refer to the Python library's Step 1: Install the Google client library To learn how toĬreate credentials for a desktop application, refer to

Authorization credentials for a desktop application.

Note: For this quickstart, you are enabling the 'Google Sheets API'.

A Google Cloud Platform project with the API enabled.

To run this quickstart, you need the following prerequisites:

Complete the steps described in the rest of this page to create a simple PythonĬommand-line application that makes requests to the Google Sheets API.

Quick spreadsheet