Unable to activate Google Sheets "On Row Updated" or "On Row Created Or Updated" trigger

Questions
1

Describe the problem/error/question

I’m unable to activate the workflow when the Google Sheets trigger is set to “Row Updated” or “Row Added Or Updated”.

I’ve also looked at the solution presented here, but it didn’t help me, I double-checked the permissions.

What is the error message (if any)?

Workflow could not be activated:

There was a problem activating the workflow: “Cannot read properties of undefined (reading ‘application/vnd.openxmlformats-officedocument.spreadsheetml.sheet’)”

Please share your workflow

Share the output returned by the last node

The problem is with this specific sheet, other triggers like this work fine

Information on your n8n setup

  • n8nVersion: 1.88.0
  • platform: docker (cloud)
  • nodeJsVersion: 20.19.0
  • database: sqlite
  • executionMode: regular
  • concurrency: 20
  • license: community
2

You need to activate the Google Sheets and Google Drive API from your Google Cloud Platform

More information here

3

Thanks, I did activate Google Sheets API, Drive API was already enabled.

I also updated my Oauth clients just in case.

But I still get the same error, by the way - I can run the workflow in test mode, I get this error only during activation.

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.