Hi,
I’ve been using Zapier for a while but I need to do something that experience tells me will be a little tricky.
Is there a way to force an action step to use the data from a column (preceding step likely to be Import CSV file), based on the **column header name**, and not on the column number / position within the file.
I need to automate a process which starts with very similar but not identical outputs - ie predictable column names, but sometimes an extra column or two where additional data is present, which throws out the position.
The goal of this is to homogenise all the outputs into a totally uniform set of columns, so that I can use “Insert Row” in the destination app.
Any ideas? Is there a search or find column utility somewhere?