Cooperation with Google Workspace is not working
T
Toshiaki Akane
Specify GoogleSpreadSheet as the data source and link spreadsheets with actions
When called from the view, there are users who do not get an error or have an unstable connection if they don't have permission due to people or access timing, making it difficult to guide them as a common dashboard for the project
I also tried reconnecting to Google, etc., but it didn't work.
ベースマキナサポート担当
I'm sorry to keep you waiting.
We have just fixed this bug.
What happened is that when an hour or more has passed since the previous execution at the time of execution and a user who does not have administrative authority to manage the data source executed it,
I accidentally got a 401 error.
Also, if an authorized user executed it after the error occurred, even an unauthorized user could execute it for 1 hour thereafter, so the behavior was such that it failed irregularly.
Now, I think the following parts have been fixed so that it can be executed without errors, so I would appreciate it if you could check it when it is convenient for you.
> When executed by a user who does not have administrative rights to manage data sources, a 401 error occurred by mistake.
ベースマキナサポート担当
Toshiaki Akane
I'm indebted to you.
First of all, I'm sorry for any inconvenience this may have caused.
There is a problem with updating the access token when linking with Google spreadsheets, and we have also received cases from other customers where the connection becomes unstable.
We are investigating the cause in-house, so we will contact you again as soon as it is addressed.
Also, if the project progresses, collaboration with something other than a spreadsheet is an option, and if data migration etc. are necessary, we will consider alternatives together within our company, so I would appreciate it if you could speak out on a shared Slack channel etc.
I'm sorry for sharing this as a matter of urgency, but I would appreciate it if you could check it out.