Hi, I can write a google appScript in google sheet for your add-on. The AppScript can be made as add-on and you can connect it to third-party webapp.
I have done similar app, and still doing app script now days for various purposes. It's esier if you use app script instead using other language.