Hello!
I’m trying to set up a zap that when I receive a new email from a specific address that has a .csv attachment, I upload that to my google drive, then copy the data into a master sheet. I have all of that working fine, and it works as intended.
The problem I’m encountering now, is that I just received the second email from that address that has a .csv attached, and it has new/different headers. Apparently every time the .csv comes from this specific source about 80% of the headers are the same, but there are some differences in the headers. Even some headers that existed previously are now in a different order.
That is frustrating, and I was wondering if it was possible to have a zap align all headers with pre-existing ones, and then if there is a new column/header it hasn’t encountered yet, to create a new column with the data.
Thank you so much in advance