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:

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": [
  "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

Unfortunately after some test I realize that “Clear” operation is like poison for database in google sheets. It create empty row in a table that cause error when you want to load data from google sheet.
I extremely suggest add “delete” feature to google sheet node for delete a row or range of data in google sheets please?

Dear @jan do you think it is possible for now?

Best regards;

@mooghermez I will have a look and get back to you. But it looks like it will only be possible to define to delete Columns/Rows and then a Start- and End-Index. Did not find anything to delete by “range”.

1 Like

That’s it.
The Index is row number-1

Yes, exactly that would be it.

So do you have time to add this feature to google sheets please?

Got added:

Will be released with the next version.

1 Like

Got released with [email protected]

Hello dear friends
In my case:
I want to get query from my google spreed sheets. (I have some sheets that I want to get query from some of my tables).
Can anyone help me please?

Update: I think we should have this feature (query) in “Google Sheets” node like “clear” or “delete”, isn’t it?