Hi,
I'm having a little problem here automating a data entry flow from my GMAIL to my Google Sheets. After all the variables are set, I use the action "Insert Row" to Google Sheets to add the relevant data to the respective cells. The "value" variable is an integer but every time the flows add the information in the Sheets, the integer comes out with "'" before it, so the sheets read it as a string.
This is the raw input of the "Insert Row" action:
{
"host": {
"connectionReferenceName": "shared_googlesheet",
"operationId": "PostItem"
},
"parameters": {
"dataset": "I don't know if this is sensible data so I erased it",
"table": "1458422655",
"item/CONCEPTO": "daluna594@gmail.com\r\n",
"item/DOLARES": -27,
"item/SUJETO": "CASA",
"item/FECHA": "2021-05-26T18:55:27+00:00"
}
}
As you can see, in the "item/DOLARES" (the sheet is in Spanish), comes out -27 as an integer, but when I check in the Sheets is written," '-27 " (Without the " ", but with the ' just before the integer).
Am I doing something wrong? Can I do something to prevent that from happening?
Thanks in advance
