gspread is an asynchronous Python library for interacting with Google Spreadsheets.
gspread is a Python library for interacting with Google Spreadsheets.
Questions tagged [gspread]
949 questions
3
votes
1 answer
invalid_scope: https://spreadsheets.google.com/feeds is not a valid audience string
I'm trying to use OAuth2 and gspread to use Python to manipulate Google Sheets. However, I keep running into this error:
invalid_scope: https://spreadsheets.google.com/feeds is not a valid audience string.
Initially, I had the scope as a list,…
Rattleznake
- 31
- 1
- 3
3
votes
0 answers
Using gspread AttributeError: 'Worksheet' object has no attribute 'get_addr_int'
I'm using gspread to modify a Google Sheets, but I keep getting this error when I run it:
AttributeError: 'Worksheet' object has no attribute 'get_addr_int'
Here is my code:
import json
import gspread
from oauth2client.client import…
user9486913
- 31
- 3
3
votes
4 answers
Python 3 and Gspread ImportError
When I run Gspread with Python3, I get this error:
ImportError: No module named 'gspread'
When I run with just Python, I get no errors. I installed gspread with pip install gspread --user. I really need to use Python 3, and I expect I should be…
Jake 1986
- 582
- 1
- 6
- 25
3
votes
1 answer
Cant import gspread when using python 3.4.3
I downloaded gspread the other day using pip. I manage to import it into a python file and run the file when using python 2.7.6 but when using python 3.4.3 it returns error no module named gspread. I did see that when I go to where gspread is…
Martin Björn
- 51
- 1
- 3
3
votes
3 answers
Getting all column values from google sheet using Gspread and Python
So i have a problem with the Gspread for python 3
when i do something like:
x = worksheet.cell(1,1).value
print(x)
Then i get the value of cell 1,1 which in my case is:
Nice
But when i do:
x = worksheet.col_values(1)
print(x)
Then i get all the…
Goriss
- 147
- 2
- 3
- 9
3
votes
1 answer
How to get Google Spreadsheet cell link with gspread
There is a single Google spreadsheet document.
After selecting the very first A1 cell from a right-click pull-down menu I choose: Get Link to this Cell command.
The URL link is now stored in a memory and it can be pasted into any text editor. The…
alphanumeric
- 17,967
- 64
- 244
- 392
3
votes
1 answer
gspread - does .cell(1,1) perform HTTP request?
Once I have performed sheet = client.open_by_key('GoogleSheetKey').get_worksheet(0) does sheet.cell(1,1) perform another HTTP request to Google API? or is it working off a local object at that point? Thanks!
William B
- 33
- 3
3
votes
1 answer
List google spreadsheets created with gspread
I used gspread to create some spreadsheet.
As they are created with a google services key account, I don't know how can I access them.
How can I see all the spreadsheets created with a specific service key?
https://github.com/burnash/gspread
GermainGum
- 1,349
- 3
- 15
- 40
3
votes
2 answers
Gspread - Change Listener?
I currently run a daemon thread that grabs all cell values, calculates if there's a change, and then writes out dependent cells in a loop, ie:
def f():
while not event.is_set():
update()
…
PattimusPrime
- 867
- 8
- 21
3
votes
1 answer
Gspread to access google spreadsheet: HttpAccessTokenRefreshError, invalid JWT
I'm struggling to get access to a google spreadsheet with python 2.7 using gspread.
Here's what I have so far:
import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope =…
Nick
- 41
- 7
3
votes
1 answer
Retrieve value of links from Google Sheet?
I have some values in a Google Sheet, some of which are hyperlinked, like the third one here:
I want to retrieve the text value of each cell, and the hyperlink if present.
I am able to access the sheet easily enough with gspread:
import…
Richard
- 62,943
- 126
- 334
- 542
3
votes
1 answer
How to debug persistent 'SpreadsheetNotFound' errors using python gspread
After 2 days of reading gspread docs, gspread blog posts, and following the most recent docs for using gspread I'm still not able to open even one Google Spreadsheet. I set up a GDrive API service account. It appears that my OAuth2 credentials are…
BigDoug
- 31
- 4
3
votes
1 answer
python gspread oauth2client.client.HttpAccessTokenRefreshError: invalid_grant
According to the following post #244 to authenticate the credential we can define GOOGLE_APPLICATION_CREDENTIALS environment variable to directly authenticate.
Here is what I did in my code.
import gspread
from oauth2client.client import…
Lin
- 1,547
- 2
- 12
- 26
3
votes
3 answers
How to write a table (list of lists) to Google Spreadsheet using gspread
I have a table which is presented as Python's list of lists and I'd like to write it down to some Google Spreadsheet using gspread library. However, it seems that gspread does not have such function out of the box. Of course I can use loop and…
Ilya V. Schurov
- 7,687
- 2
- 40
- 78
3
votes
1 answer
Gspread export spreadsheet to filesystem with formatting
I need to download the Google spreadsheets on filesystem, I am using Gspread to read the files from Google Drive which works fine.
I tried exporting to CSV but this ofcourse discards the formatting.
json_key =…
mahaDev
- 125
- 3
- 10