How to set data pulled from google sheet as embedded data?

Hey all,

Im having a difficult time navigating the google sheet workflow and was hoping someone could point me towards a solution. I have set up my workflow and have confirmed that it is pulling from the correct cell, but now I need to set that value set as embedded data to be used in the survey and I cannot for the life of me get it working.

Ive tried using the Code workflow to set the value, as seen below

function codeTask() {
  // Access the data retrieved from the Google Sheet task in Qualtrics
  var value = Qualtrics.SurveyEngine.getEmbeddedData(~{ch://OCAC_3Oi8XgpnB4rN99s/LookupData});

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

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

  return {
    result: ""
  }
}

but I keep getting the “ReferenceError: Qualtrics is not defined” error 

Im only barely familiar with JavaScript so I would not be surprised if I goofed something up, but ive been able to use the .setEmbeddedData function successfully in the past and just dont know what is going wrong.

anyways, im not married to the code workflow if there is a more elegant way to plug that data into an embedded data field. any help/suggestions would be greatly appreciated.

Thanks