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
Persistent SpreadsheetNotFound errors on specific Google Sheets spreadsheets in gspread for Python
I am using gspread to collect data from several hundred Google Sheets spreadsheets. I parse the files stored by Google Drive in a local directory and obtain the URLs for all the spreadsheets within a specified folder. Then I use a python wrapper to…
user1644030
- 251
- 3
- 10
3
votes
1 answer
Using gspread with OAuth2 SignedJwtAssertionCredentials
I am trying to access my google Spreadsheet using oauth2 using the gspread Python Library.I am new to Oauth2 and understand its benefits.But I am unable to use it.So far I have visited https://code.google.com/apis/console/ and generated CLIENT…
Dave Smith
- 103
- 7
3
votes
3 answers
gspread update cells in batch, 50k limit?
I have been using gspread with no problem for a while. I recently went over 50000 cells when updating to Google sheets. I'm getting a
File "build\bdist.win32\egg\gspread\httpsession.py", line 81, in request
raise…
jason
- 3,811
- 18
- 92
- 147
2
votes
1 answer
Transfer google sheets file ownership from service account to domain email address with gspread
In the example code below, I perform the following:
connect to my google service account
copy one of the google sheets files the service account has access to
share that copy with a user specified by EMAIL
transfer ownership of the copy to the user…
Braden Anderson
- 141
- 1
- 11
2
votes
1 answer
Inserting a python list in a column in google sheet using gspread and sheet api
I have a python list which contains a list of software names:
list = ['CodeBlocks', 'Foxit Software', 'GSettings', 'Wintertree', 'WordWeb']
I want to insert this list in a column in google sheet
how to insert it using gspread and api in python
ijahan
- 93
- 1
- 9
2
votes
1 answer
Is there a method of reading a Google Sheet via Python without having to share sheet to service account?
I am new to using Google Cloud Platform and its Developer Console. Here, I am working on a project wherein I have to automate data transfer from google sheets to SQL Server daily using Task Scheduler. Here, I came across an approach which requires…
Mohit Aswani
- 185
- 1
- 7
2
votes
1 answer
google service account not finding .xlsx files
I am trying to use a google drive folder to store data then read and manipulate it with python using gspread. The steps I followed in order to try and do this are:
create a folder with my spread sheets (.xlsx files) in a subfolder within this…
user4933
- 1,485
- 3
- 24
- 42
2
votes
1 answer
How do you change a specific row of a Google Sheet using Python?
The following code works to append the Google Sheet with a single row.
def send_to_sheet(link, prompt, output)
df2 = pd.DataFrame({'link': [link], 'prompt': [prompt], 'completion': [output]})
values = df2.values.tolist()
…
Jody
- 115
- 5
2
votes
1 answer
pyinstaller can't make correct exe file with gspread. ModuleNotFoundError: No module named 'gspread'
Pyinstaller doesn't see gspread.
import cv2 as cv
from time import time
import numpy as np
import dxcam
import gspread
import datetime
import wmi
from datetime import datetime, timedelta
All another lib of my project pyinstaller finding…
kokinas
- 21
- 2
2
votes
1 answer
Share to multiple users using Gspread in Python
I'm working on an automation script which automates the Google Spread Sheets using python and gspread library. Using this I'm able to share the created spread sheet using share() method to a single user. But how to share it with more than one users…
Vignesh G
- 53
- 6
2
votes
1 answer
Get access of google sheets of other account
Is it possible to access the google sheet of other account like that of my colleague based on my service account?
I am trying to automate google sheets with Python but most of my sheets are not in one account but on other accounts. I was wondering…
Kumar
- 55
- 3
2
votes
0 answers
How to remove invisible apostrophe while using Python gspread
The code below works. The problem I am encountering is an invisible ' appears in the google sheet before all values in the first column 'problem'.
I have attempted to change the formatting on the google sheet as described in other resources, but…
ah2Bwise
- 82
- 2
- 17
2
votes
1 answer
How to update a row using the Gspread python module
Hello basicaly i have this data, compose of name, project, reason and timestamps here's below is the structure
['John Doe', 'Hollywood', 'Good-time', '2022-05-17 15:25:45']
and on the documentation, it only shows how to update an individual cell,…
ubuntuMAN
- 118
- 2
- 8
2
votes
1 answer
Append value of variable to specific colum in google sheets
I'd like to write the value of a variable to the 2nd column in a spreadsheet. The below code works for the first iteration. Subsequent iterations are added as new rows in the first column:
for A in AURL:
print(A)
driver.get(A)
…
Ahira
- 47
- 4
2
votes
1 answer
How to solve gspread API ReadTimeout limit (Python)?
I am using gspread module to read data from a google sheet, however, some gsheets are somehow too large, and whenever i try to read(get) the values from the google sheet i get a timeout error as the following:
ReadTimeout:…
Wissam Rafidi
- 21
- 2