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
2
votes
1 answer

gspread get_all_records not returning values for some columns

I'm reading a spreadsheet populated from a form. When I retrieve the data using get_all_records, one of the columns doesn't return values. However, when I use get_all_values, the values are there. wks = gc.open_by_key('blahblahblah') worksheet =…
sophia
  • 131
  • 4
2
votes
0 answers

gspread/ httplib2 SSLHandshakeError

I had gspread for python working, but after about a month I started getting the following error: gc = gspread.authorize(credentials) File…
Mark B
  • 205
  • 2
  • 7
2
votes
0 answers

gspread: 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
2
votes
1 answer

Can I write whole lines in Google Spreadsheets using gspread in python?

I am trying to write a simple script that will take csv as an input and write it in a single spreadsheet document. Now I have it working however the script is slow. It takes around 10 minutes to write cca 350 lines in two worksheets. Here is the…
goranpejovic
  • 129
  • 10
2
votes
1 answer

How to make gspread work in a private google domain?

I looked in many websites but couldn't find an answer. I followed all the steps of gspread tutorial but when I reached the step 7 asking to share my spreadsheet, I received an error message saying: "Sorry, an item cannot be shared outside of [my…
Arthur Accioly
  • 801
  • 9
  • 26
2
votes
1 answer

CryptoUnavailableError: No crypto library available and from oauth2client import crypt failure.

The error is in gspread authentication. Got oauth2client.client.CryptoUnavailableError: No crypto library available I have installed both pyOpenSSL and pycrypto. With the Crypto folder obtained after installation of pycrypto in my app directory. I…
Prajapathy3165
  • 518
  • 1
  • 6
  • 13
2
votes
0 answers

Gspread httperror when updating cell

For some reason I get: gspread.httpsession.HTTPError when trying to update a cell. spreadsheet_name = raw_input("Please enter a spreadsheet url: ") json_keys = json.load(open('keys.json')) scopes =…
Test Dev
  • 97
  • 1
  • 10
2
votes
2 answers

Multiprocessing - returning unpickleable objects?

I've actually asked a question about multiprocessing before, but now I'm running in to a weird shortcoming with the type of data that gets returned. I'm using Gspread to interface with Google's Sheets API and get a "worksheet" object back. This…
Locane
  • 2,886
  • 2
  • 24
  • 35
2
votes
2 answers

Using gspread to read from a Google Drive Spreadsheet without logging in

I'm using the module gspread to (attempt) to parse a specific spreadsheet on my Google Drive. However, I eventually want to turn this project into a web application, so naturally I don't want to give away my login information. However, since I only…
sawyermclane
  • 896
  • 11
  • 28
2
votes
2 answers

Get_all_values from Google Spreadsheet

I am having an issue with Gspread's get_all_values() import json import gspread from oauth2client.client import SignedJwtAssertionCredentials from gmail_variables import * json_key = json.load(open('key7367.json')) scope =…
jaysig
  • 71
  • 1
  • 2
  • 7
2
votes
2 answers

oauth2client.client.CryptoUnavailableError: No crypto library available

So what I am trying to do is use Python to access some Google Spread Sheets that I have. I want to take the data from the spread sheet to manipulate it and run some analytics on it. I have used gspread in the past successfully, but now when I try to…
Thomas
  • 21
  • 1
  • 4
2
votes
0 answers

Python gspread and Oauth2 for server-side applications returns no spreadsheets

I'm trying to read a bunch of spreadsheets within my organization that have been shared with my account and import the records into a database. I'd like to use OAuth2.0 instead of just using raw text passwords, but I'm having trouble getting this to…
jpavs
  • 648
  • 5
  • 17
2
votes
2 answers

Populating google spreadsheet by row, not by cell

I have a spreadsheet whose values I want to populate with values from dictionaries within a list. I wrote a for loop that updates cell by cell, but it is too slow and I get the gspread.httpsession.HTTPError often. I am trying to write a loop to…
Koba
  • 1,514
  • 4
  • 27
  • 48
2
votes
1 answer

Is there a way to use gspread to select all the cells that have content?

I have a google worksheet that is constantly being added to via a google form. I am trying to use gspread to take the content provided by the form and transfer it to a separate spreadsheet. The problem I have run into is selecting all the cells that…
Michael
  • 679
  • 7
  • 24
1
vote
1 answer

Object of type Timestamp is not JSON serializable when saving pandas dataframe to google sheets

Inexperienced in python here. I have a pandas DataFrame where one of the columns is of type datetime64[ns]. When attempting to save data to Google Sheets using gspread, I get an "Object of type Timestamp is not JSON serializable" error (last line…
isswf
  • 115
  • 1
  • 10
1 2 3
…
63 64