Also recommend checking out Azure Logic Apps' Google Sheets integration. It's been a few years since I've used it but I built some pretty nifty quick and dirty tools on top of Sheets, Logic Apps, and Azure Functions for back office app work at my last company.