Google app script pickup email received from banks and update the transaction automatically. I modify it using web based form of needed.
The ev company has api. It will be called on periodic basis to get the ride details and update the sheets. I use telegram api to interact, by triggering the api webhook, getting charts, etc.,
Initially I setup OCR to extract the ride information, so the process was like
send an image that has ride details to a telegram bot
the bot saves the image in Google drive
the image would be opened in docs
the text would get extracted and stored in Google sheets as data
edits can be done using telegram webapp
sheets provide charts for analysis
built a process using sheets to handle telegram bot for maintaining users, approvals, etc.,
It would be hard if I have used any other services… setting up OCR preparing charts etc.,