I track my budget in Sheets. I have some AWS Lambda functions that IFTT calls to update the sheets with new data
I'm interested in hearing more about this setup. What triggers the IFTTT calls and what do the Lambda calls accomplish?
Ask HN: What do you use Google Sheets for?
31–40 of 52 posts
Re: Ask HN: What do you use Google Sheets for?
#32Tracking shipping containers as they progress from supplier -> port -> ship(s)/port(s) -> port of discharge -> rail -> depot -> our warehouse and then returned to the depot.
Interesting use case! Any reason you didn't consider something like Trello for this? It seems like it would fit it nicely and give you a nice visual overview of where each shipping container is.
It has other data that I need to store, bunch of relevant dates and locations of pickup/dropoffs.
I have an script that updates our ERP from that spreadsheet.
I also have a google apps script that sends out an email with all the relevant containers. e.g. container ABCD needs to be picked up by 5/12/2020 and container UVWX needs to be returned by 5/17/2020.
This allows our logistics guy to allocate resources.
Re: Ask HN: What do you use Google Sheets for?
#33I track my workout progress in a sheet that is backing a google form. After every session, I enter the details from my phone. My priorities were: 1. not having to install yet another app; 2. not locking my data into a silo.
Re: Ask HN: What do you use Google Sheets for?
#34I have so many Google Sheets.
I track my weight, running performance, workout progress, my spendings, savings, investment performance, car expenses, all trips out of the country (for visa purpose) and more.
Everything with fancy charts showing progress and how well I'm achieving my goals.
Re: Ask HN: What do you use Google Sheets for?
#35I use it as a great way to share data from ad-hoc queries, and often times can drive a quick workflow without having to build out a full set of screens in our line of business app. On a personal level, despite many attempts to find a perfect app, my relatively simple set of budgeting spreadsheets is still the best solution I've ever come up with. Not Google Sheets, but the president of our company has been able to bu…
I use Google Sheets to share ad-hoc queries with other people too. Fun tip for those who use Postgres: psql has a command `\copy` that allows you to write the results of a query out into a local (clientside) CSV file. From there, it's pretty straightforward to import that into a Google Sheet.
Re: Ask HN: What do you use Google Sheets for?
#36I recently used Google Sheets to create a simple list[0] of people who want to co-hack on projects.
[0] https://docs.google.com/spreadsheets/d/1YKQ9g6h4BuWI32xcMbSM...
Re: Ask HN: What do you use Google Sheets for?
#37I recently used Google Sheets to create a simple list[0] of people who want to co-hack on projects. [0] https://docs.google.com/spreadsheets/d/1YKQ9g6h4BuWI32xcMbSM...
Curious - do any online communities exist for this purpose?
Re: Ask HN: What do you use Google Sheets for?
#38I recently used Google Sheets to create a simple list[0] of people who want to co-hack on projects. [0] https://docs.google.com/spreadsheets/d/1YKQ9g6h4BuWI32xcMbSM...
Curious - do any online communities exist for this purpose?
None that I know of. But in the past people use to linger around various IRC channels to meet others and start projects together.
Re: Ask HN: What do you use Google Sheets for?
#39They fit perfectly on my Google Bed.
Re: Ask HN: What do you use Google Sheets for?
#40They fit perfectly on my Google Bed.
(＾▽＾)