Allow to create a new Data Table using a workflow

Feature Requests
1

The idea is: Allow creating a data table using automation

My use case: well, it doesn’t make sense that data tables can be only created manually :slight_smile:

I think it would be beneficial to add this because:

n8n Is an automation platform so creating data tables should also be automated.

Any resources to support this?

currently the Data Table node does not support creating a new Data Table

Are you willing to work on this?

2

I just wrote about it…I am facing same issue, I am reading a google sheet with only 17k rows and N8N is crying, freeze and disconnet, I can belive n8n is no able to process only 17 k rows from a google sheet, And I hope that loading it using batch technicques and upserting in a data table n8n could work properly but I just discover that I had to create all column manually :rofl: wao… And my table is huge, any ways I will create it manually in order to try test if n8n can work with only 17 k rows,for me its a night mare

3

I can definitely do it with more than 80k rows(over 15 columns). Is about resource consumption here(and honestly not worththe configurations and extra job just to support this).

But Ggl sheet is know as high latency request(external , and is even for a simple write )… sheet is NOT a “real” relational database lol.

Agree as well with the data table(use it often for “fast” write/read between others querys for PostgreSQL.