Stack Overflow
Stack Overflow

Questions tagged [gspread]

gspread is an asynchronous Python library for interacting with Google Spreadsheets.

gspread is a Python library for interacting with Google Spreadsheets.

949 questions
0
votes
1 answer

gspread w/ OAuth2Client Service Account Key

I am using gspread and a Service Account Key, Other, json file. to continually update a google spreadsheet with python 2.7. I have this running off a Raspberry Pi running the latest Raspian Jessie. my oauth and gspread should all be the latest…
Jacob Simeroth
  • 13
  • 4
0
votes
0 answers

Error during authentication using oauth2client

I have a Python program that attempts to use oauth2client for Google authentication so that I can use gspread. This is my code: import sys, os, requests, gspread, ast from oauth2client.client import SignedJwtAssertionCredentials f =…
jmcampbell
  • 378
  • 4
  • 17
0
votes
1 answer

gspread and oauth2client usage

I was trying to use oauth2client and gspread to operate on googlesheet but the problem i have is that when using oauth2client, it requires a field of scope. I have no idea what the scope is. The following is the code of the use of…
Edccccch
  • 19
  • 1
  • 3
  • 8
0
votes
1 answer

atomic append to google spreadsheet by gspread

The append in the sense of not trivially using append_row in which it will write at the end of the spreadsheet itself but at the end of contents that potentially could be appended by other users (from google drive for example). Is it possible? Does…
Xinwei Liu
  • 333
  • 6
  • 15
0
votes
4 answers

How to clear a column in gspread?

I am using gspread in a python script and I have been trying to find a quick way of clearing a column in a given sheet. Q: How can I clear the columns with gspread?
3kstc
  • 1,871
  • 3
  • 29
  • 53
0
votes
1 answer

unable to import gspread module despite being installed

I am unable to run gspread on my fabric script despite I have installed gspread via pip. what did i miss out? Gangzhengs-MacBook-Pro:Fabric mosesliao$ pip install gspread Collecting gspread Requirement already satisfied (use --upgrade to upgrade):…
Moses Liao GZ
  • 1,556
  • 5
  • 20
  • 45
0
votes
1 answer

Change Spreadsheet Settings from gspread

Is there any way to change Spreadsheet Settings from the api?? Is there any other way I can do this from python?? Im using gspread to pull the results of a google form into python. I want to change the time zone of the results to fit to my needs,…
Raghuram Krishnaswami
  • 129
  • 1
  • 3
  • 11
0
votes
1 answer

Public/Private keys for Google developers service account

I've been going over this for a while and can't manage to understand how to obtain my public/private keys for my automatically created service account in the google developers console. I am making a python script that imports data using gspread from…
johan855
  • 1,578
  • 4
  • 26
  • 51
0
votes
1 answer

Problems using PyInstaller, gspread and oauth2client

I'm currently working on a project that heavily relies on gpsread (python 2.7). I'm in charge of creating a .exe but I've been running into some problems... I have PyOpenSSL installed and the program works fine from the .py I'm doing some testing on…
Alex
  • 1
  • 1
0
votes
1 answer

Nuitka/Pyinstaller, unable to load oauth2client libraries and others

I'm relatively new to Python. For a school project, I'm coding a relatively complex program. I need to make an executable file. I started testing with a fraction of the actual program, and I was unable to create a .exe file using PyInstaller,…
Alex
  • 1
  • 1
0
votes
1 answer

Using gspread in GAE

I am unable to get a Python package, gspread, to work in GAE. My project is in D:\Documents\Google Cloud\myapp. I installed gspread using: c:\python27\python.exe setup.py install --home="D:\Documents\Google Cloud\myapp" All the files appear to be…
Old Geezer
  • 14,854
  • 31
  • 111
  • 198
0
votes
1 answer

gspread error: SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] in python

I have a few line of codes that used to work very well until today (using gspread). I get an certificate verification error whenever I run this code: json_key = json.load(open('Sheetmodification_abc.json')) scope =…
vandernath
  • 3,665
  • 3
  • 15
  • 24
0
votes
1 answer

"ValueError: Invalid control character" using Python OAuth client

I am trying to load data from a google spreadsheet into a postgres database. The problem is when I am trying to authenticate my credentials, I get the following error: File "/usr/local/lib/python2.7/dist-packages/oauth2client/_openssl_crypt.py",…
johan855
  • 1,578
  • 4
  • 26
  • 51
0
votes
0 answers

Include gspread module using py2exe, pyinstaller

I have created a python application which fetches data from a google spreadsheet and performs the required operation and outputs files with the data accordingly. The application works fine through my ide and the console. I'm using gspread and…
user3542154
  • 91
  • 1
  • 2
  • 8
0
votes
1 answer

gspread output and sting manipulation with Python

I used gspread to get some data from a Google docs spreadsheet. Here is a snippet of the code: worksheet_2 = sp1.get_worksheet(1) worksheet_1 = sp1.get_worksheet(0) val = worksheet_2.acell('F2') print val when I print val the output is:
3kstc
  • 1,871
  • 3
  • 29
  • 53
1 2 3
…
63 64