Dr. Violet Howard demos n8n's new native data tables with a sales-data AI agent. The agent queries a Bluetooth speaker product and calculates total revenue of $546 using a calculator tool. The data table node stores columns for product, quantity, price, and revenue directly within n8n.
Chapters
N8N just released their native data tables. All right, so we've got our sales data AI agent right here, and it's hooked up to all of these tools so that it can query through our sales database. So I'm going to open up the chat and I'm going to ask it how much total revenue have we made from our Bluetooth speaker. And so what it's going to do is use these tools right here and it used the product name query to look at all of the times that we've sold a Bluetooth speaker. And then it just used its calculator tool to figure out that total. So it just finished up. If I open up the chat, you can see we got the answer. Total revenue from Bluetooth speaker was $546. It calculated this by retrieving all sales rows for Bluetooth speaker, and then it summed each row's total revenue, and that's why it used its calculator and got to the answer 546, which is correct. And so you may have never seen this node before. These are data tables that are stored natively within N8N, and it looks like this right here. You can see this is the data table, and these are the different products and the quantities and price and revenue, and this is what it just searched through. In order to answer our question accurately. If you wanna watch the full breakdown, then click on that play button right here, and I'll see you guys over there.