AI Automation for NetSuite and Geckoboard Dashboard Integration
The client had been waiting nearly a year for NetSuite and Geckoboard support teams to complete a live dashboard integration. Large screens around the office were meant to motivate staff and reassure visiting customers, but the data behind them was always out of date. Management asked me to step in and build an AI automation instead.
Manual NetSuite Reporting Blocking Live Geckoboard Dashboards
Sales assistants were pulled away from revenue work to pull reports from NetSuite and copy values into Geckoboard by hand. The real problem was not the dashboards themselves. It was that NetSuite and Geckoboard had no native connection, and neither vendor was willing to build the bridge. Manual updates were the only fallback, and that fallback was expensive.
Building an AI Integration Between NetSuite and Geckoboard
I started by reading both the NetSuite and Geckoboard API docs. Because there was no direct integration, I chose the client’s existing n8n instance as the middleware for a custom AI integration. NetSuite saved searches became the data source, custom HTTP request nodes queried the NetSuite REST API for each metric, and the Geckoboard Datasets API received the formatted payloads. I avoided the deprecated Geckoboard custom widget API so the solution would stay reliable.
Two workflows powered the AI automation. One fetches key metrics on a schedule; the other listens for manual override triggers when the team needs an immediate refresh. The automation runs hourly on weekdays from 8am to 5pm Sydney time to avoid overloading NetSuite with unnecessary queries.
Live Geckoboard Dashboards Powered by NetSuite AI Automation
What changed: a proof-of-concept dashboard was live in one day, after a year of waiting. Sales assistants no longer spend time copying numbers. The office screens now refresh automatically, and leadership can trigger an update on demand through the AI automation.
