How to Add New Columns in Google Sheets Without Misplacing Fields in Existing Scenarios?

How To
1

I’m using the Google Sheets - Watch Rows module in Make.com with the following setup:

“Table contains headers” is set to Yes,
Header row range is defined as A1:BS1.

The issue I’m facing:

I need to add new columns in the middle of the sheet (not at the end), but when I do, the fields in my existing scenarios get misaligned. This doesn’t break the scenarios, but it causes fields to be mapped to the wrong columns. For example, I have mapped fields like Address (K) and Beds (Q), and when I add new columns in the middle, the references shift, and fields become misplaced in the module configurations.

My key question:

How can I add new columns in the middle of my Google Sheet without misplacing the field mappings in my existing scenarios? I would prefer a solution that keeps the data order intact and ensures that references remain based on header names rather than column letters.

Thank you.

2

Hi @Justin_GoodBuy_Prope ,

I’ve got the same problem and the workaround I found is to leave some 5 empty columns every few columns and make a “reserve”.

I think one way to do this could be to use ‘Declare multiple variables’ module to declare variables as : dataincolumnA, dataincolumnB… and assign values accordingly. In your Google Sheet : update rows module for example you’d use this module’s variables instead of data from the source. This way you’ll only change the set variable module parameters and rest will follow. Depends on the complexity of the database also… What do you think ?