IMPORTRANGE() column generator of months of the years for Google Sheets

google-sheets-importrange-generator.php

<?php

declare(strict_types=1);

$format = '"=IMPORTRANGE(""%s"",""%s!H1"")"';

$months = [
    "JAN",
    "FEB",
    "MAR",
    "APR",
    "MAY",
    "JUN",
    "JUL",
    "AUG",
    "SEP",
    "OCT",
    "NOV",
    "DEC",
];

$sheets = [
    2031 => "foobar",
    2032 => "fizzbuzz",
];

$content = '';

foreach ($sheets as $sheet) {
    foreach ($months as $month) {
        $content .= sprintf($format, $sheet, $month) . PHP_EOL;
    }
}

file_put_contents('/tmp/results.csv', $content);

echo "Copy contents of '/tmp/results.csv' and paste into a Google Sheets cell the results." . PHP_EOL;