Academy ↓
Dall-e-3 API Call
Create an image from Google Sheets with OpenAI's Dall-e
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)
}