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

how to place output data-frame in D2 instead of A1 in google sheets with gspread python

# accessing workbook wb = gc.open_by_url('https://docs.google.com/spreadsheets/d/1LcFa9PDSjaL-Po47okWzLaUC4QUdtRSXzrgslTo6V7E/edit#gid=0') # creating new worksheet worksheet = wb.add_worksheet(title="A_worksheet", rows="100", cols="20") # print df…
akhil kn
  • 3
  • 4
-1
votes
1 answer

How can I append the results from python script into google sheet

import subprocess import ipaddress import pygsheets from subprocess import Popen, PIPE from pprint import pprint from googleapiclient import discovery #def append_table(start='A1', end=None, values=None, dimension='ROWS', overwrite=False) gc =…
-1
votes
1 answer

How to access a cell value from gspread

i would like to retrieve a cell value from gspread python API, however, the cell method "sheet.acell(A)" returns a value like this sheet.acell(A) i have proposed a forced solution in a way. is there a more efficient way to handle this def…
nvrthles
  • 99
  • 1
  • 1
  • 6
-1
votes
1 answer

Update CSV to Google Sheet's

I am trying to import about a 15,000 row csv file to a google sheet that we use. I thought the import csv would work but i can figure out how to write it to make it work. any help would be great. to clarify i am trying to get a raspberry pi to…
-1
votes
2 answers

gspread TypeError: login() takes no arguments (2 given)

I have installed gspread and gdata in my virtual environment using pip. And when I try to login with email and password following the documentation, as shown: import gspread gc = gspread.login('533ghimiresantosh@gmail.com','password') It throws…
Santosh Ghimire
  • 3,087
  • 8
  • 35
  • 63
-2
votes
1 answer

is it possible to use named functions with gspread?

I want to use a function on a cell with gspread, how does it work? tried this: cell_b2 = worksheet.COUNT(D3,E7).value the function I want to execute using gspread does not work
-2
votes
1 answer

Google Sheet updating error due to rate limit exceeded and Python code

I am trying to play with google Sheets using python but it is giving me the error. It may be due to not having optimizing code logic. Error gspread.exceptions.APIError: {'code': 429, 'message': "Quota exceeded for quota metric 'Write requests' and…
-2
votes
1 answer

Trying to pull names and countries out of a string with regex, but getting overlapping matches

I realize this is an odd use case. The non-profit I work for has a google sheet that has webinar info in it. I am trying to pull this info out and then format it in HTML so they can just copy-paste paste onto the website. Reach row is one…
-2
votes
1 answer

Highlight cells in a column in google spreadsheet when the value above a threshold with python

Here is a simplified example of my codes and the screenshot of the results I want to get in google spreadsheet. I hope to either save the dataframe style to google spreadsheet as applying table style to excel using python. Or use the…
-2
votes
1 answer

save style to google spreadsheet

I'm writting dataframes to google spreadsheets with gspread_dataframe, gspread. I'm trying to assign a yellow background to cells depends on the values with pandas style. https://pandas.pydata.org/pandas-docs/stable/user_guide/style.html Is there a…
-2
votes
2 answers

Python: how to pass an object/variable trhough a function and change it directly inside of the function?

In C language I was used to doing this by passing address of variables (pass by reference), but in Python, despite having already read about some alternatives, I have no ideia how can I do to pass a Google Sheet (worksheet) to a function that must…
-2
votes
1 answer

Why does python say there are 4 arguments when there are only 3?

I'm writing a Tkinter with gspread app. I believe the connections to the spreadsheets are made properly because i can read data off it. I'm using python 2.7.15 and gspread 0.6.2. I get the error. If i leave out the 'RAW' argument at the end of the…
-2
votes
1 answer

How to complete OAuth2 authentication on web servers?

Actually I'm working on a Discord Bot which uses Google Sheets as Database using GSpread API, it is hosted on Heroku. So, how to complete authentication ? My Bot is not working.
user8269563
  • 29
  • 2
  • 5
-2
votes
1 answer

EOL while scanning string liberal

I am relatively new to Python so please pardon my stupidity. I want to examine google sheet data and keep running into the EOL while scanning error. I have looked at other posts and tried various tactics but none seems to be fruition. I think Client…
Jake Wagner
  • 786
  • 2
  • 12
  • 29
-3
votes
1 answer

How to get data from a google spreadsheet that I only have view access to into google colaboratory

I have a link to a google spreadsheet that I do not own, but have view access to. Is there a way to get the data in that spreadsheet into the google colab notebook that I am using?
1 2 3
63
64