Hey, I’m having an issue with one of my workflows.
The role of the node is to automate shopify orders with my supplier. Basically it fetches new orders, extracts relevant information and appends a row in google sheets.
What’s the problem? When a new order comes it appends the row but it won’t append any other order that comes later on after the first one.
It pops the following error - "Column names were updated after node’s setup.
Anything I can do to resolve this?
Thanks in advance!
Try to press the Refresh button, I think some of your column wasn’t included
The yellow triangle and the refresh button indicate that the columns in your sheet have actually changed compared to what is on the “append row” configuration window. Please click the two rounded arrows symbol next to the yellow triangle to update the columns in the configuration window.
That’s the problem, every time I click the refresh button it works again until the next order comes in.
It requires me to do it every time instead of automating the process which is the point. Once the Append row node executes it changes the sheet ( adds a row ) which is exactly what I want but then it breaks the automation because it “changes the sheets”
Even though you’re activate the workflow?
Is there a place in your workflow anywhere where you specify the file to use or the sheet to use or is there only a single file and single sheet all the time?
Dear @iGothica that may be because, your google sheet is keep changing the data.
Are you using the same sheet into any other automations ???
Not really, I fetch the information from the order, get the row from the sheet, edit specific fields I need and append a new order row.
Nope, only for this automation. the “change” appears to be the new appended row but that’s the whole point of the automation to append new rows automatically so I don’t understand why it’s happening.
@iGothica, try using Append or Update the raw node, instead of Append row.
I think this will help.
If still the problem not get solve, let me know…
