All Questions
Tagged with google-api-python-client google-sheets-api
91 questions
1
vote
1
answer
90
views
Google Sheets API - Create empty sheet - Slow performance
Using the Python example taken directly from the "Google Sheets API documentation > Create a spreadsheet" and changing only the credentials, I am experiencing poor performance. It's ...
- 11.1k
0
votes
2
answers
166
views
Troubleshooting Google Drive API Issue: Google cloud python function Fails to Detect PDF Files in Shared Folder
I developed a Python script that operates on the Google Cloud Platform. The script utilizes the Google Drive API and Google Sheet API to access a folder in Google Drive belong to a company , extract ...
- 21
1
vote
0
answers
85
views
Using Google Sheets API to upload a converted CSV with Python3 - Having trouble
I'm having a lot of trouble figuring out what's going on here. I'm not getting any error messages from Google's end, and when I check the API it says that the requests are going through, but the ...
- 85
1
vote
0
answers
63
views
Access denied from google api to my python application
I programmed a small app to send data to google spreadsheets. It worked perfectly fine. I changed nothing on the code and suddenly I got authorisation error from google. I check online and found out ...
- 69
0
votes
1
answer
39
views
Google Authentication API not refreshing after a couple d
I followed the google API authentication steps, it worked initially but after a couple days following the same steps and redownloading "secrets" give me the above error, I thought this flow ...
2
votes
1
answer
576
views
Google sheets python API - module 'google.auth.credentials' has no attribute 'CredentialsWithTokenUri'
I'm trying to set up the Google Sheets API for python. When I run the quickstart.py file (exactly as specified in the google documentation), I receive the following error:
AttributeError: module '...
- 41
1
vote
1
answer
2k
views
Google SheetsAPI: ValueError: Client secrets must be for a web or installed app
Very similar to this question: ValueError: Client secrets must be for a web or installed app but with a twist: I'm trying to do this through a Google Cloud Virtual Machine.
Recently, the Out-Of-Band (...
- 410
5
votes
2
answers
7k
views
ACCESS_TOKEN_SCOPE_INSUFFICIENT error with updating sheet using google sheets api (python)
I've been making a program in python that is intended to have each user be able to use it to access a single google sheet and read and update data on it only in the allowed ways, so ive used google ...
- 85
0
votes
0
answers
740
views
Google Sheets API (Python Client) is inserting data uncontrollably with update and append methods after execution
I'm facing an issue with the google sheets API using Python and I can't seem to find any other similar question online about it. I will insert data using the update and append methods, the execution ...
- 11
1
vote
0
answers
319
views
Change color of pie chart with google sheets API
I'm using Python google sheet API v4 to produce a pie chart using the following code:
body = {
"requests": [
{
"addChart": {
"chart": {...
- 11
0
votes
1
answer
68
views
getting authorisation for google spreadsheet app
I am trying this quickstart.py example given on the page: https://developers.google.com/sheets/api/quickstart/python
I have created these credantials:
I have credentials.json in the same location as ...
- 631
1
vote
2
answers
2k
views
How to get the "first sheet" in Python Google Sheets API
I'm using the Python googleapiclient to get the contents of a Sheet. The API currently requires specifying the sheet name. That's fine, but sometimes the name of my sheet changes, and then I get an ...
- 2,548
3
votes
2
answers
3k
views
Access Google API using python: Refresh Error 'invalid grant' appears suddenly after a few days of first-time setup
Within last 10days, with python 3 and by using the google_auth_oauthlib and googleapiclient packages, I have been able to create Google Sheet (using python code) and do basic write/read values to any ...
- 456
0
votes
1
answer
1k
views
Using Python to run GOOGLEFINANCE() in GoogleSheets: not able to input stock symbol as a string
Using the following python code, I am succesfully able to write and execute the GOOGLEFINANCE() in Google Sheets:
cell_range_insert= 'B2'
values = [['=GOOGLEFINANCE("MSFT", "open", ...
- 456
0
votes
0
answers
768
views
ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:1131)
For the code
....
SCOPES = ['https://www.googleapis.com/auth/spreadsheets',]
# The ID and range of a sample spreadsheet.
SAMPLE_SPREADSHEET_ID = <My SpreadSheet>
creds = Credentials....
- 1