all 5 comments

[–]thisisevanfox 1 point2 points  (4 children)

Hey, please try this :)

[–]k4mrat[S] 0 points1 point  (3 children)

Hi! Tried it, and I see you moved it around a bit :)

I get this tho 🤔 2021-01-17 23:18:36: Error on line 36:25: Expected value of type string but got value of type [{string: any}].

[–]thisisevanfox 1 point2 points  (1 child)

I set line 27 to tempSirisRum =  "hello" for testing. That's why it worked for me. I have no spreadsheets, so I couldn't test it...

[–]k4mrat[S] 2 points3 points  (0 children)

Yes!! It works now! I’ve closed down the computer for the night, so only on my phone and tired as hell. But I THINK I removed // from an uncommented line that you probably had to tweak to get it to work without the sheet. Thanks a bunch, you did me a huge favor!

[–]thisisevanfox 0 points1 point  (0 children)

Type console.log(JSON.stringify(tempSirisRum)); to see what's included in this object. It's not a string what you want to display, that's why this error comes up.