this post was submitted on 27 Sep 2023
428 points (96.7% liked)

Programmer Humor

31992 readers
133 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] randomTingler@lemmy.world 10 points 11 months ago

I use Google sheets on my personal projects.

  • tracking expenses
  • tracking my ride logs from my ev

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.,