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)
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.
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
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.
So:
I extremely suggest add “delete” feature to google sheet node for delete a row or range of data in google sheets please?
@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”.
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?