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

Create a post

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

Rules:

  • Posts must be relevant to programming, programmers, or computer science.
  • No NSFW content.
  • Jokes must be in good taste. No hate speech, bigotry, etc.
  • 1 user online
  • 77 users / day
  • 211 users / week
  • 413 users / month
  • 2.92K users / 6 months
  • 1 subscriber
  • 1.53K Posts
  • 33.8K Comments
  • Modlog