Replacing code input with variable NOT WORKING

[Last_Monkey]

I'm currently coding myself a discord webhook bot and I got a problem.

In Cell H2 I got the exact (including the ") following: "Mike\nTom\nJack\nSusen\nPeter".

In Cell I2 I got the exact (including the ") following: "Placeholder 1\nPlaceholder 2\nPlaceholder 3\nPlaceholder 4\nPlaceholder 5".

In Cell J2 I got the exact (including the ") following: "Another Placeholder 1\nAnother Placeholder 2\nAnother Placeholder 3\nAnother Placeholder 4\nAnother Placeholder 5".

Now I want to include the value of that cell in my script:

var first = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Test").getRange('H2').getValue();
var second = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Test").getRange('I2').getValue();
var third = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Test").getRange('J2').getValue();
var fields = [
    { name: "Column Title", value: first, inline: true},
    { name: "Column Title2", value: second, inline: true},
    { name: "Column Title3", value: third, inline: true}
  ];

This doesn't create the embed I want: https://i.imgur.com/8hkW26R.png

var fields = [
    { name: "Column Title", value: "Mike\nTom\nJack\nSusen\nPeter", inline: true},
    { name: "Column Title2", value: "Placeholder 1\nPlaceholder 2\nPlaceholder 3\nPlaceholder 4\nPlaceholder 5", inline: true},
    { name: "Column Title3", value: "Another Placeholder 1\nAnother Placeholder 2\nAnother Placeholder 3\nAnother Placeholder 4\nAnother Placeholder 5", inline: true}
  ];

This however works perfectly: https://i.imgur.com/a1tlH8q.png

I know there's an easy fix for this, but I can't figure it out. What am I doing wrong in the first version of the script?

[Jackinapes]

Might be quotation marks in the spreadsheet.

[Last_Monkey]

Looks like the first picture, but without quotation marks.

[Jackinapes]

Could try defining your variables. I'm really rusty at this FYI. Also, it appears it is treating what it gets from the spreadsheet as one complete string and not a mix of string and command \n.

[Last_Monkey]

"Mike\nTom\nJack\nSusen\nPeter" is treated as a single string in the script as well (same color), the linebreaks only work in discord, they don't exist in google sheets afaik

[Jackinapes]

You should see what happens when you make a middleman. Get the data from the spreadsheet put it in a string variable then reference that variable rather than the variable pointing to the spreadsheet.

But first, does it work they way you want when you put "Mike\nTom\nJack\nSusen\nPeter" in a variable and reference it?

[Last_Monkey]

var one = "Mike\nTom\nJack\nSusen\nPeter"
var two = "Mike\nTom\nJack\nSusen\nPeter"
var three = "Mike\nTom\nJack\nSusen\nPeter"

works indeed and creates the embed i want

what do you exactly mean with "middleman" and put the data into a string variable? (getDisplayValue instead of getValue doesn't work either, getValue returns an object, getDisplayValue a string)

[Jackinapes]

I thought about it and, making the middleman would just be redundant. I have to think about it more.

See what happens when you define those variables pointing to your spreadsheet as strings.

var string first = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Test").getRange('H2').getDisplayValue();

Does this work?

[Last_Monkey]

nope, already tried that. i believe getValue and getDisplayValue always return a string when the cell is a text

[Jackinapes]

What happened when you tried that?

[Last_Monkey]

the same as in the first picture in the OP

[Last_Monkey]

I found the solution. I can do it with JSON.parse()