im.js

const rp = require("request-promise").defaults({ encoding: "utf8" });
const cheerio = require("cheerio");
const _ = require("underscore");
var he = require("he");
 
var parseXlsx = require("excel");
const FilePath =
  "test.csv";
 
parseXlsx(FilePath, function(err, data) {
  for (row in data) {
    let i = 0;
    let col_1 = data[row][0];
    getSearch(col_1);
  }
});
 
function getSearch(artnr) {
  const options = {
    uri: `http://www.google.com/`,
    transform: function(body) {
      return cheerio.load(body);
    }
  };
 
  rp(options)
    .then($ => {
      getResult();
    })
    .catch(err => {
      console.log(err);
    });
}
function getResult() {
  const options = {
    uri: `http://www.example.com/`,
    transform: function(body) {
      return cheerio.load(body);
    }
  };
 
  rp(options)
    .then($ => {
      console.log("done")
    })
    .catch(err => {
      console.log(err);
    });
}