Google sheet trigger returns Error 502 when readind spreadsheet associated with a Google form

[fxholl]

My client uses a Google Form to capture data. I need to send the data from new submissions to a CRM system via API. I created the very simple workflow below:

I get an error when I select the sheet where new submissions appear:

If I select another sheet it works fine:

Obviously I would need the workflow to run on the sheet where new submissions appear. What am i doing wrong?

Information on your n8n setup

• n8n version: 0.226.2

• **Database (default: SQLite):**cpostgres

• n8n EXECUTIONS_PROCESS setting (default: own, main): main

• Running n8n via (Docker, npm, n8n cloud, desktop app): docker

• Operating system: linux

[Jon]

Hey @fxholl,

I would need to have a play with it but it could be that the google api doesn’t support that type of sheet.

What happens if you make the sheet first then associate the form with it or is that not an option?

[fxholl]

I tried making first the sheet and then associate the form but it did not work.