I Made A FREE Fitness Management System (Overview + Demo) Google Sheet & Appscript | E6

A calorie and nutrition tracker: register with your age, weight and gender, get a daily calorie goal calculated for you, then log what you eat by searching a real food database rather than guessing numbers.

The food database is not yours to maintain

This is the design decision that makes it work. Instead of building and updating a table of thousands of foods, the app queries a free public food database published by the US government, using an API key you request and paste into the script. Search "apple", "burger" or "soup" and you get real entries with their actual calorie values per portion — nothing to maintain, and the data is better than anything you would type yourself.

Your goal, calculated

At registration the daily calorie goal is worked out with the BMR formula from your age, weight and gender — so the target is yours rather than a generic two thousand. Log a meal by picking the food and entering the quantity in grams, and the app shows what you have consumed and what remains, with a warning when the intake is too low or over the goal.

Looking back

The history covers today, this month and all time, plus the last five, seven, fourteen and thirty days — the windows people actually judge a diet by. The dashboard adds average daily intake, total calories for the month, days tracked, items logged, and trend charts for both calories and food count.

Worth knowing

Despite the title, this is a personal nutrition and calorie tracker — not gym membership or trainer management. Entries can be deleted, so a mistaken log is fixable, and everything is stored in your own Google Sheet.