All Questions
70 questions
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
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
1
vote
1
answer
415
views
getting spreadsheet from google sheets only if that is not deleted
I want to get particular spreadsheet from it's sheet id with get method of Google sheets api. i am using below method to get a speadsheet.
sheets_file = service.spreadsheets().get(spreadsheetId=...
- 73
1
vote
1
answer
4k
views
getting files from google drive from particular folder with Google drive API (Python)
I want to get list all spreadsheets from Google drive by using Google drive API. I have wrote a script in python which is returning me all spreadsheets list from my Google drive but the issue is that ...
- 73
6
votes
1
answer
6k
views
How to use a service account to authorize google sheets?
I am trying to open a private google sheet using python. The end goal here is to read that private sheet data into a json object. I have made sure to create a google cloud project, enable the API's, ...
- 81
10
votes
1
answer
11k
views
How to fix: Google Sheets API has not been used in project
I want to built a questionnaire line chatbot and transmit the answer to google sheet.
Here is my code:
'''
import os
from flask import Flask, request, abort
from linebot import (
LineBotApi, ...
- 113