Hello all,
The Qlik Application Automation Google Sheets connector was modified to request a different set of scopes than it used to. This has an impact on new connections made in Qlik Application Automation to Google Sheets.
What does this mean?
Qlik Application Automation used to rely on the following scope in order to obtain a list of spreadsheet files: https://www.googleapis.com/auth/drive.
This scope has been replaced with a more limited scope: https://www.googleapis.com/auth/drive.file.
Why was the change done?
The change was motivated by Google’s modifications to which scopes are restricted. The new scope is limited to searching for files that have been created by the app itself, whereas the old scope was able to list all files available on a drive.
How does this affect me?
- If you have an existing Google Sheets connector connected which was created before August 8th 2024: There is no change to your connector and all existing automations will remain working. Tokens obtained through our refresh token call will contain the same scopes as before.
- Connections created after the 8th of August 2024: The connector will have the updated scope. This means not all spreadsheets on your drive will be shown in any of the spreadsheet ID block or on the list spreadsheets block. The spreadsheet ID for spreadsheets not shown in the lookup will have to be manually provided and can be obtained from the browser bar in Google Sheets.
We are looking to mitigate Google's change and are working on bringing the connector's user experience back to it’s previous levels.
Thank you for choosing Qlik,
Qlik Support
