httpRequestToCSVExamlpe.js

const fs = require('fs')
    ,converter = require('json-2-csv')
    ,request = require('request')
    //REPLACE WITH WANTED URL
    ,url = 'https:// [YOUR CREDS @ YOUR STORE] .myshopify.com/admin/products.json'
;

request(url, (error, response, body) => {

    if(response.statusCode === 200){

        const data = JSON.parse(body);
        
        converter.json2csv(data.products, (err, csv) => err ? console.error(err) : fs.writeFileSync('report.csv', csv))
    }
    else {
        console.error(error)
    }
});