Some time ago I was able to choose a Google Sheets column dynamically for update. This made possible to collect data every day and save in a separate column
@EmeraldHerald That is simply how the new version of the node behaves.
@artildo What you can do is to select under “Mapping Colum Mode” → “Map Automatically”. Then you add a Set-Node in front of it and there you can then Set the Column Names + Values dynamically. In that mode, it will work then again as the node worked for the first few years.