text: const integration = "googlesheets";
  const name = "Google Sheets";
  
  const fs = require("fs");
  const path = require("path");
  const version = "v0";
  
  const transformer = require(`../${version}/destinations/${integration}/transform`);
  const inputDataFile = fs.readFileSync(
    path.resolve(__dirname, `./data/${integration}_input.json`)
  );
  const outputDataFile = fs.readFileSync(
    path.resolve(__dirname, `./data/${integration}_output.json`)
  );
  const inputData = JSON.parse(inputDataFile);
  const expectedData = JSON.parse(outputDataFile);
  
  inputData.forEach((input, index) => {
    it(`${name} - payload: ${index}`, async () => {
      try {
        const output = await transformer.process(input);
        expect(output).toEqual(expectedData[index]);
      } catch (error) {
        expect(error.message).toEqual(expectedData[index].error);
      }
    });
  });
  