If you haven't looked into it yet - Google Apps Script [0] is an incredibly powerful system when combined with Google Sheets. You can integrate lots of business processes and external systems (rest,soap,databases etc) together and integrate with classic spreadsheet functionality, we use it a lot in our business!
[0] https://developers.google.com/apps-script