Is spilling with fetch possible?

%3CLINGO-SUB%20id%3D%22lingo-sub-1445717%22%20slang%3D%22en-US%22%3EIs%20spilling%20with%20fetch%20possible%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445717%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20return%20data%20from%20an%20external%20source%20and%20that%20data%20will%20fill%20up%20multiple%20cells%20(e.g.%20spilling).%20I%20can%20achieve%201%20or%20the%20other%20but%20not%20both.%20The%20following%20returns%20a%20%23VALUE!%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%2F**%0A%20*%20Get%20text%20values%20that%20spill%20both%20right%20and%20down.%0A%20*%20%40customfunction%0A%20*%2F%0Afunction%20me()%20%7B%0A%20%20let%20url%20%3D%20%22https%3A%2F%2Fexample.com%22%3B%0A%20%20return%20new%20Promise(function%20(resolve%2C%20reject)%20%7B%0A%20%20%20%20fetch(url).then(function%20(response)%20%7B%0A%20%20%20%20%20%20resolve(%5B%0A%20%20%20%20%20%20%20%20%5B'apples'%2C%20200%2C%20'pounds'%5D%2C%0A%20%20%20%20%20%20%20%20%5B'oranges'%2C%203%2C%20'pounds'%5D%2C%0A%20%20%20%20%20%20%20%20%5B'pears'%2C%205%2C%20'crates'%5D%0A%20%20%20%20%20%20%5D)%3B%0A%20%20%20%20%7D)%0A%20%20%7D)%0A%20%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1445717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I am trying to return data from an external source and that data will fill up multiple cells (e.g. spilling). I can achieve 1 or the other but not both. The following returns a #VALUE! error:

 

 

 

 

 

/**
 * Get text values that spill both right and down.
 * @customfunction
 */
function me() {
  let url = "https://example.com";
  return new Promise(function (resolve, reject) {
    fetch(url).then(function (response) {
      resolve([
        ['apples', 200, 'pounds'],
        ['oranges', 3, 'pounds'],
        ['pears', 5, 'crates']
      ]);
    })
  })
 }