Trigger workflow when i import a csv on the google sheet tab

Describe the problem/error/question

i want it to trigger a workflow when i import a CSV on the google sheet tab .

To do this I have set up a google sheet trigger node that is suppose to trigger on “row added or updated” - however it doesnt seem to trigger.

My hypothesis is that the import of the CSV isn’t monitored as a “row update” and therfore the node doesn’t detect it and doesn’t trigger.

My question is:

  • is this hypothesis right?
  • how can i do to trigger a workflow by the importation of a CSV file ?

Thanks in advance!

Information on your n8n setup

  • n8n version: Running version [email protected]
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): cloud
  • Operating system:

Hi @oly-dev, I’m sorry you’re having trouble.

I just tested this on my end, but the new rows were detected. I was using this CSV file which I’ve imported on an existing empty sheet using these settings:

image

My trigger is running as expected on the text polling interval and receives all rows from the imported CSV (this is a production execution):

Were you perhaps using any location other than “Replace current sheet” when importing? In this case, your new sheet would most likely have received a new URL from Google, while your trigger node is still checking the old URL.

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