Have you ever experienced the warning about “number of columns in the data does not match the number of columns in the range” when trying to set values or paste a range of values back into your Google Sheet with Google Apps Script?
Check out this post to see how this script can help you fill out your column data to match the number of columns in a range.