Hey @jupsy, well, if the node is not able to get the data, there must be something with these credentials, either the API is not enabled or the scopes are off…
Hey @jupsy, do you have Google console cloud API activated?
here is how its done:
1: Go to https://console.cloud.google.com
2: Create/select a project
3: Enable Google Forms API (and Google Sheets API if responses are stored there)
4: Go to APIs & Services > Credentials
5: Click Create Credentials > OAuth client ID
-Set up the consent screen (just basic info + test user)
-Choose “Web application”
-Add redirect URI: http://localhost:5678/rest/oauth2-credential/callback (or your n8n URL)
-Copy the Client ID and Client Secret
7: In n8n, create new credentials (e.g. Google Sheets OAuth2), paste in the values, and authorize