Improve google sheet node [GOT CREATED]

As you know in current google sheet there are some features and some have issues.
I ask to improve:

  • In “Read” feature, node load all data from table on google sheets but it return just first row unfortunately.

I thin there are some two important feature for google sheets for manage rows and column that is missed.

I search google sheet API and I see below references:
REST Resource: spreadsheets.developerMetadata

By these methods:
get feature: You could get specific row or column I think.
search feature: It return all matches rows or columns. (lookup feature just return one matches row, I think)

Sorry do not understand what you mean with that it just loads in the first row. It should load in all the columns and rows you define in “Range”.

Dear @jan
As you see in below screen shots:

1- Position of google sheet node (Read feature):

2- Loaded data in google sheet node (in table and JSON):


3- In next node (in variable selector), Just is shown first row of loaded data:

It is wired for me that why google sheet load all data but in next node in variable selector just is shown the first row of loaded data.

Best regards

n8n gets all the data and also processes all the data. Only the variable selector just displays the data of the first item for simplicity.

In your example above it should actually send 13 Telegram messages. The first one with the data you see in the variable selector and the other 12 with their corresponding data.

In fact in my case I want to use those data in one message.
Can I probably use them by array ([]) or something like that?

In other hand it is very useful to create multi message in telegram messenger

I think we could search a table in google sheet we could query specific data and show it on a message and if it be able it could be great I think:sob::sob::sob::face_with_head_bandage:

Solved:
I toked RAW DATA :sweat_smile::innocent:

Ah great to hear that you found a solution!

It would also be possible in the regular mode and a Function-Node like this:

{
  "nodes": [
    {
      "parameters": {
        "functionCode": "const returnData = [];\nfor (item of items) {\n  returnData.push(item.json);\n}\n\nreturn [\n  {\n    json: {\n      data: returnData\n    }\n  }\n];"
      },
      "name": "Function1",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        850,
        650
      ]
    }
  ],
  "connections": {}
}

As you mentioned here:


You improved “google sheets” more.
Can I ask you one more option please? (I want to know that I know you are very busy:pray:)
Clear Or Delete Option.
This option can delete or Clear one specific row in google sheets

Ah yes, try to add it asap.

1 Like

Released [email protected] which now includes the operation “clear”.

1 Like