I tried to convert the 7 items into 1 item with the function node, I tried to format the columns in my Google sheet, I tried to rename the range and/or the key row, I tried to first create then append data, merge data, but nothing worked.
Yes, I checked the Spreadsheet ID many times and copy/pasted it many times too (lol):
From this URL “/spreadsheets/d/1vK1zout0B56CDvqnA3sXypLq1X6HxMQ-KU6ZC6CuE00/edit#gid=0” I copied/pasted this “1vK1zout0B56CDvqnA3sXypLq1X6HxMQ-KU6ZC6CuE00”
Also, the node seems to be connected to Google: from my GoogleApi account I gave the access permission to the email account linked to the Google sheet. In fact, I can create a blank spreadsheet with no data in it (wich, I suppose tells me that the connection is there) but I can’t read or append any data from/to a specific sheet.
Yes I tried it too and other combinations like, Joolia!A:M, Joolia!A1:M1 (just to make sure that it was no typo or mistake from my side). But none of them worked.
I tried different Key row to make sure I was pointing at the right row but nothing changed either.
The message is still the same: “UNFORMATTED_VALUE” or “NOT_FOUND” (as shown in the picture above).