Google Sheet columns with the same name

[Matthew Pryor]

Hi

Is there a way to map variable names for use in subsequent steps when a Google Sheet has more than one column of the same name?

I understand it would be preferable to just rename the column, but there are reasons that is not ideal.

To be clear, say I have a sheet with 6 columns, being primary and secondary contact details - if the 6 columns are A,B,C,D,E,F and the header names are firstName,lastName,email,firstName,lastName,email - it seems I can't refer to those columns by the auto generated variable names in a Google Document/PDF generation tasks - the values are blank.

If I rename the columns, the generation works - so it seems like the duplicate column names are causing an issue.

Is there some way to control the mapping of variable name to column name?

Thanks

Matthew