Using append Method for GoogleSheets

How To
,
1

I am trying to add many rows to a googleSheet.
For that reason I’m using the Method: spreadsheets.values.append and it works nice.

The configuration I have is as follows:

image
image296×862 28.6 KB

Now I need to slightly change that to allow the loading not being in the initial Sheet (gid=0) but on the Sheet on my selection.

So I changed what was working

spreadsheets/{worksheet}/values/A1:append

for this:
spreadsheets/{worksheetId}/values/{sheetId}!A1:append

And it dind’t work.

I tried mani diffente combinations ({sheetId}!A1, {sheetId}A1, include range in the body or inthe query strings) but nothing worked.

Does anyone how to code that range specification

2 Likes
2

Hi @Enrique,

I found this here:

image
image834×618 69 KB
.

Maybe, you could try: spreadsheets/{worksheet}/values/{sheet}!A1:append
where sheet is the name of the sheet.

Moreover, could you share the blueprint of your scenario (it helps during testing)?

Philippe

2 Likes