Google Sheets Integration - Pipe - Must have!

[philipteng]

Hi @Sara

Currently the Google Sheet pipe is only able to add a row of values to the Sheet. I think the Google Sheet API can insert values in columns. Can we request for values to be added into a column?

Thanks a lot in advance.

[philipteng]

I tested the recent addition of values into a column, and I encountered an error.
First I added value to column C
Then I try to add values to column D, and I get this error. Seems like it is trying to compare with column C.
{
“error”: {
“code”: 400,
“message”: “Request range[Sheet1!D1] does not match value’s range[Sheet1!C1]”,
“status”: “INVALID_ARGUMENT”
}
}

[philipteng]

Another request is whether we can introduce a “starting” cell to add the values, whether it is for row or column. We don’t always want to start with Row 1 or Column A.

[philipteng]

I was trying to update a row of values to A1:D1. But I get the following error. Seems like it was writing outside the range?

Update a row of values in a sheet
{
“error”: {
“code”: 400,
“message”: “Requested writing within range [‘Course Run 111’!A1:D1], but tried writing to column [E]”,
“status”: “INVALID_ARGUMENT”
}
}