Comments (2)
mpurnell1
commented on June 5, 2024
I also encountered this issue but was having to re-authorize my application every few days. I originally tried to use Google Workspaces as a workaround to the Testing status, because a workspace app can be marked as internal. This did not work as expected, and I didn't want to publish my app because it only needs access to a few documents owned by me.
My solution was to use a service account to authorize instead of OAuth. I followed the steps in this post and made sure to share the sheet I wanted to edit with the service account, then I was able to update my spreadsheets fully automatically, without having to follow the link or paste an authorization code.
from pygsheets.
francot
commented on June 5, 2024
Thanks for your workaround. Actually I have published my app to avoid re-authorize every 7 days.
Issue remains valid for published/production app
from pygsheets.
Related Issues (20)
- Error on adding a row to the table
- Naming unbounded ranges
- unlink simply doesn't work for shared drive sheets HOT 2
- How to set hyperlink? HOT 1
- Remove formatting of appended row in 'append_table'? HOT 3
- Error when appending 'This range already has a worksheet with different title set' HOT 4
- get_values ignores the start string if no end string is specified HOT 3
- DataRange.apply_format() does not work for Date Format HOT 1
- Is there a function to GET the last used row & column in the wks? HOT 2
- Feature request: different types of charts except "basicChart" HOT 1
- Excessive delay and 429 errors when using pygsheets HOT 3
- How to create multiple link in a single row
- `google.oauth2` both Deprecated and Decommissioned HOT 2
- AttributeError: 'Worksheet' object has no attribute 'get_all_values'
- `set_dataframe` function reached cell limit
- Expose orderBy as a parameter when listing documents
- apply_format range error
- Sample for custom_formula
- Link to Cotributing guide not working
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pygsheets.