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

Questions
, ,
1

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!

Screenshot 2023-05-25 at 17.17.23
Screenshot 2023-05-25 at 17.17.231056×1444 56.6 KB

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:
3

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):

image
image1893×902 77.2 KB

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.