There was a bug with Google Sheets integration that when you don't select the drive access, the integration would fail silently.
Now if it doesn't has the required permissions, we will ask you to authenticate with Google again.