I have a big Google Sheet that is used as the database for more than 1 flow.
I have one flow that runs, and it should then add a new row to the Google Sheet. Because this one Google Sheet is used by multiple flows to pull data from, I have decided what each column should contain.
BUT when I add a new row, and the current flow has no data for instance for column C, but has data for column D, the Google Sheet Piece removes column C, and just inserts the data for D into C.
What is the fix?