Measuring the workflow execution time and storing it in a spreadsheet

[macomuck]

Hello all,

I’ve gotten an idea, that I want to measure, how long it takes the workflow to execute the user’s request (how long it takes to send a reply to the user). I know I can see that in the “n8n overview → executions”. But I would like to have this data in a spreadsheet, so I can calculate the average time.

Any idea, of I could implement this?
Thank you very much in advance!

• n8n version: The lastest
• Database (default: SQLite): Default
• n8n EXECUTIONS_PROCESS setting (default: own, main): Default
• Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
• Operating system: Windows 11

[Yo_its_prakash]

The easiest option to do this is we can use n8n API

It have a start time and end time data, Just put a n8n node, then google sheet and ad it in columns then add a formula in third column that’s it.

[macomuck]

Could you explain a bit more, I’m a complete beginner to the programmer world.

Thank you for the fast reply!

[Yo_its_prakash]

N8N has its own API which will have all the information that we need to perform this,

[macomuck]

I think I cannot access the API key, as I’m currently working on the free trial version of n8n.

[Yo_its_prakash]

You are right, but there is round about way you can do the same thing

By this you can have more control over your time calculation, you can even caluate what is the time spent between each number of nodes if you want to that is…

[macomuck]

Prakash thank you very much.
Could you please attach this workflow to the conversation?
So I can try it out on my workflow?

Thanks

[Yo_its_prakash]

Yes definitely, i am working on my own self hosted server but that shouldn’t be problem in you trying,

If this solved your issue please consider marking this comment as the solution​:smile: