Two tools which intuitively make sense that they are connected are Google Spreadsheets and Google Forms. If you get many responses in your form, you w

Create your own Personal Expenses Tracker with Google Sheets and Google Forms

submited by
Style Pass
2021-07-23 13:00:05

Two tools which intuitively make sense that they are connected are Google Spreadsheets and Google Forms. If you get many responses in your form, you will want to visualize them and potentially make some calculations. So having form responses immediately added to a Google Spreadsheet is very useful.

The way to connect a form to a spreadsheet is very simple. In your forms click on “Responses”, and then click on the three dots. By clicking on “Select response destination”, you guessed it, you can select a response destination.

One great use case is expenditure tracking. There are a lot of expense tracking tools out there, all of which work well. However, if you are looking for a free and customizable option, the Forms/Sheets combo is something worth considering.

I personally have a quite high threshold when it comes to expenditure tracking. I have tried and failed to establish an expenditure tracking habit many times. If tracking an expense becomes too cumbersome, I tell myself “I’ll just do it later in one go” and then forget.

Leave a Comment