Is it possible to load a .csv file in Qualtrics and pipe text from that file?

I didnt try the exact solution but can be done with something similar below.

Create a google sheet doc

There should be 2 blocks.

Your prompt question should be in 2nd block

Add these 2 embedded data after the first block.

add the below javascript to generate random number and store in the random number varialbe 

Qualtrics.SurveyEngine.addOnload(function() {
  // Generate a random number between 1 and 20
  var randomNumber = Math.floor(Math.random() * 20) + 1;

  // Set the value of the variable named 'randomnumber' to the generated random number
  Qualtrics.SurveyEngine.setEmbeddedData('RandomNumber', randomNumber);
});

Go to workflow and create this flow

In google sheet task set it as below

in the code task replace the existing code with this.

function codeTask() {
  // Access the data retrieved from the Google Sheet task in Qualtrics
  var googleSheetData = Qualtrics.SurveyEngine.getEmbeddedData('GoogleSheetData');

  // Extract the specific value from the Google Sheet data (assuming it's in the first row, first column)
  var value = googleSheetData[0][0];

  // Set the value to the embedded variable "abcd"
  Qualtrics.SurveyEngine.setEmbeddedData('PipedPromptCSV', value);

  // Log the result for debugging purposes
  console.log('Value retrieved from Google Sheet and stored in embedded variable abcd:', value);

  return {
    result: ""
  }
}

I was also stuck in that way. Logically it should work. I tried few times after replying to you. Im wondering whether the issue is because of the time taken to draw information from google sheet.

But checking at the embedded data its not populated. Random number is generated anyway.

it would be best to put random nuber generator code in the 1st block with q1 to execute first.

Dis you try replacing the script 

var googleSheetData = Qualtrics.SurveyEngine.getEmbeddedData('PipedPromptCSV');

Im stuck here.

@Shashi Thank you for your clarification. Could you please specify better which steps should I follow to perform this? 

“use imported data project and it’s API to get random prompt in the survey flow.”

Thank you in advance