Google Sheets: values sent to the incorrect columns
Your Zap is sending data to the wrong columns in your spreadsheet.
This can happen if you insert, delete, or move columns in your spreadsheet. Your Zap identifies where to send data based on the column position. If you insert, delete, or move columns, and that adjusts the position of the column you’re trying to send data to, the Zap will continue to send data to the original column location.
If you set up your Zap to send data to column C, then delete column B, column C will replace the original column B, becoming the new column B. What was column D will become the new column C and data will be sent there instead.