I am studying dataanlytics course and new to N8n building loveable dashboard automation.
I created work flow its working .after click workflow execute ,click fetch dashboard button getiing data.
But i need without click execute work flow whenever i click fetch button on dashboard need to update my dashboard records…
current workflow
loveable dashboard
Hi @kofianand , I think this is happening because your dashboard is probably calling the Test URL instead of the Production URL.
The Test URL only works while you are inside the n8n editor and have manually clicked Execute workflow or Listen for test event. For the button in your Lovable dashboard to work without opening n8n and executing the workflow manually, I would use the Production URL from the Webhook node and then activate the workflow.
I would open the Webhook node, copy the Production URL, replace the URL used by the Fetch Data button in Lovable with that Production URL, and make sure the workflow is active in n8n.
Since you are using Respond to Webhook, I would also set the Webhook node response mode to use the Respond to Webhook node. Then the flow would be that the dashboard button calls the n8n production webhook, n8n reads the Google Sheet, and Respond to Webhook sends the data back to the dashboard as JSON.
If you are self hosting n8n, I would also make sure the Production URL is publicly reachable. A localhost URL will only work from your own machine and not from a hosted dashboard.
thank you tamy.santos
