I’d check out Packs like @James_Malloy mentioned. They have made most API use-cases much easier to build for and maintain.
You’ll be looking at Packs and the API as a solution based on your criteria, so here’s another API example for Sheets to Coda that might give you some ideas.