The approach I took to make entering data in to sheets a little less awful:

1. Setup the google sheet

2. Create a simple AppScript script that accepts Name/Amount/?Date

3. Attach AppScript to the google sheet

4. Set up shortcut through the Apple Shortcuts app to ask for the inputs and create a simple POST to the script URL

So adding an expense is simply clicking the Shortcut icon and entering in the data. No need to open sheets itself