Hi @NTC,
When you configure a GSheets module, it grabs the latest headers at the time you refreshed the module. You’re assigning variables and data to column positions, the names are just there to try to be helpful.
Hopefully someone that knows better will chime in, but I would say there’s nothing we can do about this because there’s nothing keeping you from using duplicate headers.
As far as I know, GSheet cells, columns and rows don’t have any underlying IDs that can be used in lieu of their positions.
I can think of one way to deal with this…
You would have to guarantee yourself you won’t use duplicate header names.
Then, when a source row comes in, iterate each column’s header/name, search row 1 of the destination sheet for the column with that same value, then write the value to the destination row in the matching column.
I know it’s not quite the answer you were looking for, but I hope it was a little helpful and makes sense.