Get datas with "," from a google sheet


i store my datas in google sheet
my datas are polygnes with all vertex
i need all the coma “,” between all coordonates.
but i solte them.

what can i do

polygone3 polygone4

Try a script like this:

function doGet() {
  //get data from sheet
  var ss = SpreadsheetApp.getActive();
  var sh = ss.getSheetByName("Sheet1");
  var values = JSON.stringify(sh.getDataRange().getValues());
  return ContentService.createTextOutput(values);  

then blocks:

The json structure gets lost in the cells and on the way, and has to be reformed in the blocks

If you are not yet ready to get into JSON for complex objects, the alternative
would be to normalize your polygons into rows of vertices,
one vertex per row, with an extra column or two to identify the polygon and the vertex number.

That would fit more naturally into a csv table for transport, if you’re into that.

On the other hand, it changes the granularity of your updates to one vertex per update versus one polygon per update.

Great i will learn how to use Json

But I have another problem: in my table I have other data that I have to recover.
I need the name and the quantity for each polygon

how do i get them?

They will be in the list coming back from the script as well - just look at responseContent on its own and you will see.