Dall-e-3 API Call

Create an image from Google Sheets with OpenAI's Dall-e

Code.gs

function aiImage() {
  var prompt = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange("B2").getValue()
  var apikey = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("apikey").getRange("A1").getValue();
  var data = {
  "model": "dall-e-3",
  "prompt": prompt,
   "n": 1,
   "size": "1024x1024"
}
  var options = {
    'method': 'POST',
    'contentType': 'application/json',
    'headers': {
      'Authorization' : 'Bearer ' + apikey
    },
    'payload': JSON.stringify(data)
  }
  var answer = UrlFetchApp.fetch("https://api.openai.com/v1/images/generations",options)
  var response = answer.getContentText()
  var json = JSON.parse(response)
  var imageUrl =  json.data[0].url
  var revisedPrompt = json.data[0].revised_prompt
  var sheetResponses = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1")
  sheetResponses.insertRowBefore(4)
  sheetResponses.getRange(4,1,1,1).setValue(prompt)
  sheetResponses.getRange("B2").clearContent()
  sheetResponses.getRange(4,2,1,1).setValue(imageUrl)
  sheetResponses.getRange(4,3,1,1).setValue(new Date())
  sheetResponses.getRange(4,4,1,1).setValue(revisedPrompt)
}