To set up automatic column width adjustment in Google Sheets as new data spills over, first, use “AutoFit” by right-clicking on the desired columns and selecting “Resize column” → “AutoFit.” Then, open the “Apps Script” editor from the “Extensions” menu, replace any existing code with the provided script, and save it. This script, triggered on every sheet edit, automatically resizes columns to accommodate new data by using the autoResizeColumns function. Adjust the sheet name and column range as needed. This setup ensures that you won’t have to manually adjust column width each time new content spills over in Google Sheets.