How to update query when adding a new column to a GoogleSheet

Hi,

I have quite a few GoogleSheets as data sources.  However, when I add a new column, it does not pull through in the data (and in fact the query errors out).

I have found posts answering this question, but for Excel files - specifically, I'm looking how to solve this for GoogleSheets.

Thank you,

Rebecca