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
-1
votes
1 answer
Connect Google Sheet API in Python
I am trying to upload data to google sheet by python.
But i found that I have to use administrator to run the script.
My computer OS is Window10.
The followings are my python script.
import gspread
from google.oauth2.service_account import…
kachi lau
- 1
- 2
-1
votes
1 answer
How catch update google sheets and send to python?
I can insert date from python to google sheets.
How can I make reverse, catch update google sheets data and send to python ?
Maybe it can be done in google scripts or using ApiHooks?
Nevermore
- 3
- 1
-1
votes
1 answer
How to append a new worksheet and upload a local CSV in gspread
I checked the docs of gspread but couldn't find out a way to APPEND a new local csv into a worksheet into a preexisting sheet.
As far as I see the import function just cleans and uploads into the first page. But I want to create a new work sheet in…
avakado0
- 101
- 1
- 9
-1
votes
1 answer
Can't create file into specific folder using gspread google colab
Yesterday I was still able to create a google sheet files using gspread into a specific folder using this code:
ss = gc.create(fileName,"my folder destination")
But today, this code yields an error.
Here is my full code:
from google.colab import…
Muhamad Ardika
- 1
- 1
-1
votes
1 answer
How to update multiple google sheets at once using gspread
I'm trying to update multiple google sheets using python and nothing I try seems to work. I want to be able to input data once and have it automatically fill in the same data in another spreadsheet. Here's my code I have so…
Halcyon_B
- 1
- 1
-1
votes
1 answer
How can I make a batch request for an entire Google Sheet's formatting in Python?
Using Python, I'm trying to check each cell in a Google Sheet for a strikethrough and return the rows without a strikethrough. The problem I run into is reaching my quota limit for the current minute since I'm checking 150+ rows. Plus I need to…
Chris
- 45
- 7
-1
votes
1 answer
Spreadsheet not found error - Umlaut in file name
I am trying to open several files using open from gspread. However, I get a spreadsheet not found error when the files have characters in their names that have umlauts (i.e. Sprüngli). I haven't been able to find anything related to this in the…
Makif Nayman
- 1
- 1
-1
votes
1 answer
Google Sheets Api, python. How to access specific cell data
I am currently doing project for college where I need to create a basic banking system using google sheets & python. I have successfully been able to add customer data & check data is correct. However I am looking to see how i could check a specific…
Charles Ballantyne
- 13
- 7
-1
votes
1 answer
How to update a google spreadsheet with data received from a Binance API
I am trying to extract btcusdt price from binance to a google spreadsheet on my gdrive in vain.
I tried the following:
import websocket, json, numpy as np
cc = 'btcusdt'
interval = '1m'
socket =…
Nano
- 1
- 1
-1
votes
1 answer
Get combined/merged cells value
I'm coding a new python script that need to extract data from google sheets, but there are many cells which are merged/combined, and only the top-left cell from this merge has the value. It's important to have that value on all the merged cells.
How…
João Casarin
- 674
- 2
- 9
- 27
-1
votes
1 answer
How to search thru Google Spread Sheet
I'm trying to find a value exist in the GSheet. Connection to Google sheet works. I can fetch all the worksheets within the files, but I can't some reason iterable the list of worksheets.
Here is the file looks likes:
I'm trying to find cell value…
miu
- 189
- 2
- 13
-1
votes
1 answer
How i can specifiy the datatype when import google sheet with gspread_pandas?
I have a google sheet with a fixed number of columns and variabile numer of rows that are the value of environment sensors.
the sheet format is
im able to import it in a data frame with…
Rosario Iameo
- 61
- 5
-1
votes
2 answers
How can I store my google sheet cred file inside my python code, I dont want to store file in my PC, i want to write cred inside my code?
import gspread
from oauth2client.service_account import ServiceAccountCredentials
scope =…
vpnkumar
- 11
- 6
-1
votes
1 answer
Unable to Delete the rows after deleting the data in a Python Dataframe
**Index date colum1 column2**
0 20200705 a 1.1%
1 20200706 b 78%
2 20200707 f 10%
3 20200707 g 59%
…
Nikhil
- 19
- 3
-1
votes
1 answer
changing the typset of strings read into a google sheet
I'm relatively new to python, but is there a way to make the values one reads into their spreadsheet bold? I want to create headers that have a bold typeset, but I'm not sure how to do this.
Thank you!
Here is the statement I am trying to do this…
Katiya Fosdick
- 1
- 1