• 1 Post
  • 11 Comments
Joined 1 year ago
cake
Cake day: July 4th, 2023

help-circle

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










  • My account was compromised once, though I have 2FA enabled. I assume that I was accessing my account from a browser on a windows pc, it had virus but not 100% sure. Someone was able to access it, change my name send multiple crypto related links to users in bulk.

    It contained years of chat history with my wife. I was able to recover the account. But I deleted all the chat history.

    I still use it to get alerts from various automated scripts I use, mostly for the bots with free API access. No personal data go in there.

    The mistake might be from my side. But if someone takes over your account, you lose everything.