Creating an office script where it looks at the first column in each sheet and inserts a column based on the value in the first column

I need help creating an Excel office script that can automate some formatting within each sheet of the workbook.

• I need to place a blank column in all of the worksheets within the workbook.
• I am usually given an excel workbook where the formatting is off in some or all of the worksheets.
• There is no set pattern as to which sheet will be formatted incorrectly.
• I decided to do a conditional decide that will read if Column A has a value. If it does, then insert a blank column. If it does not have a value, leave it alone.

This is what I have done so far and it just seems to insert a blank column anyway. Not sure where I am going wrong. It is adding a column no matter if Column A is blank or not. It is also not reading all of the sheets within the workbook.

function main(workbook: ExcelScript.Workbook) {
    let selectedSheet = workbook.getActiveWorksheet();
    // Set range Z1 on selectedSheet
    selectedSheet.getRange("Z1").setFormula("=IF(A1<>\"\",1,0)");

    // Get the value in cell A1
    let value = selectedSheet.getRange("A1").getValue();

    // Check if the value in A1 is 0
    if (value = 0) {
        // Insert Column
        selectedSheet.getRange("A:A").insert(ExcelScript.InsertShiftDirection.right);
    } else {
        // If value 1, leave alone.
        console.log("All good.");
    }
}

Do you mean that you want to check the value of cell A1 in each sheet and inset a column if it's not blank?

function main(workbook: ExcelScript.Workbook) {
    let sheets = workbook.getWorksheets();

    sheets.forEach(sheet => {
        let cellValue = sheet.getRange("A1").getValue();

        if (cellValue === "") {
            sheet.getRange("A1").getEntireColumn().insert(ExcelScript.InsertShiftDirection.right);
        }
    });
}