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
0
votes
1 answer
Gspread and python on windows mobile or windows CE
I am working on an inventory project for work that will use a mobile computer and have run into a problem. I have written a program using Python and the Gspread library, but forgot to check if it will even work with either the windows mobile or…
AAGPP
- 3
- 2
0
votes
1 answer
Python gspread login error 10060
I am attempting to log in to my Google account with gspread. However, it just times out with a Socket Errno 10060. I have already activated POP and IMAP access on my email.
import gspread
print 1
gc = gspread.Client(auth=('***@gmail.com',…
Jmo
- 45
- 1
- 8
0
votes
1 answer
Error when using unicode function in the gspread wrapper. Potentially and bug
When using the unicode function with the following string it gives an error:
unicode('All but Buitoni are using Pinterest buffers and Pratt & Lamber haven’t used it for a month so I’ll check on this.')
Traceback (most recent call last):
File…
Koba
- 1,514
- 4
- 27
- 48
0
votes
0 answers
Have a simple program to manage my spreadsheets but pulling data taking too long
Ok so I am using gspread to pull data on google spreadsheets but for what I am doing I need to pull data from long columns. Anyway the data that is being pulled doesn't need to be there until half way through the program. Is there a way to pull that…
Kyle772
- 129
- 1
- 1
- 8
0
votes
1 answer
How to create a tabular data structure from a list of sublists with Gpread or XLWT?
How do you create a tabular data structure form this list of sublists using GSpread or XLWT in which every item at index 0 is in the first column, every item at index 1 is in the second column, etc.?
For example, I'd like to put all the a's in the…
Chris
- 5,444
- 16
- 63
- 119
0
votes
1 answer
How would one convert/wrap a HTTPLib2 instance as a Session?
I know the title is a big wonky and I apologize for that. The dilemma I have is that gspread uses Session and the Google APIs client library for Python uses HTTPLib2. I have a service account that I have working with the Google API client and want…
Neil C. Obremski
- 18,696
- 24
- 83
- 112
-1
votes
0 answers
in python, issues passing parameter names to gspread Worksheet.update() function
I am receiving this warning, and I want to prepare in advance for this version update
[*] Updating Google sheet.../home/myname/.local/lib/python3.11/site-packages/gspread/worksheet.py:1046:
UserWarning: [Deprecated][in version 6.0.0]: method…
Canovice
- 9,012
- 22
- 93
- 211
-1
votes
1 answer
How do I return a range of cells in Google Sheets based on a condition, using Python?
Below is an example of what I have in a Google Sheet:
1 | ID | Fav Color | Fav Book |
2 | 01 | color1 | book2 |
3 | 02 | color2 | book2 |
4 | 03 | color2 | book1 |
...
100 | 99 | color1 | book2 |
Using gspread, is it…
yes
- 3
- 2
-1
votes
1 answer
Create SpreadSheet without Google Drive Scope
Is there any way to create spreadsheet only using the scope https://www.googleapis.com/auth/spreadsheets in Gspread?
Based on the documentation, seems like that scope itself can handle "create":
Please suggest the example code or web related to…
-1
votes
1 answer
gspread: Retrieve dimensions (width/height) of columns and rows
I am trying to retrieve the dimensions of columns and rows in my spreadsheet via the gspread python library.
I am able to authenticate API access, and I can access/modify cell values. I am also able to resize rows and columns. However, I do not seem…
Adam Higgins
- 103
- 3
-1
votes
1 answer
How do I update a value in a cell without coordinates?
I find the required cell through the row number and column name (Column Search is necessary because columns can change their place in the table) and try to update its value using gspread. The code works without error, but for some reason it updates…
Eugene
- 43
- 5
-1
votes
1 answer
New dataframe carrying changes to original in pandas/gspread script
I am writing a code to read data from google sheets using gspread module.
First I read the spreadsheet and store values in a variable called df. Afterwards, I create a variable called df2 from df to make some transformations (string to numeric),…
Dico Gomes
- 5
- 1
-1
votes
1 answer
How to add data in next line of GoogleSheet using Python
I am fetching daily order book and profit/loss data using broker API and feeding them using python with the help of Gspread library.
Following code, I am using to feed fetched order book data from broker into google…
Sandeep Yadav
- 1
- 1
-1
votes
2 answers
Why am I seeing "no connection adapters found" when trying to use results as a variable, but not while trying to print?
Hope I am asking this the right way - just confused with what's going on: I have my working script (below). I'm trying to take the URLs from a spreadsheet, rather than copy and paste them in - basically, creating urlsA from column N on the sheet…
Anthony Madle
- 371
- 1
- 10
-1
votes
1 answer
How can i read specified rows in Google Spreadsheets
I have a question that is , how to read rows which have data ? Rows are empty i dont want to read them. Otherwise , i want to.
Here is my code:
from queue import Empty
import gspread
from oauth2client.service_account import…
