# Making a personal dashboard (hopeless idea) **URL:** \ **Category:** Tech\ **Created:** [November 16, 2017, 1:48pm UTC](https://forum.beeminder.com/t/making-a-personal-dashboard-hopeless-idea/3597 "2017-11-16T13:48:32Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![bcool](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bcool](https://forum.beeminder.com/u/bcool)\ **Post date:** [November 16, 2017, 1:48pm UTC](https://forum.beeminder.com/t/making-a-personal-dashboard-hopeless-idea/3597/1 "2017-11-16T13:48:32Z")
So I wanted to create a dashboard in sheets instead of the current app i’m seeing everyday for some extra stimulus. idea: every day open up an excell sheet in the excellsheet i would see a pyramid. basic setup: 3 rows couple of columns bottom row are the helpers (e.g. exercise, administrative things) middle row are the “must do things” (work & my rails project) top row (e.g. 1 item) is like "wish do things) (extra hours on my rails project 🙂 ) I think this could be some kind of thing that I would love to see in the web version as well for beeminder. So i looked at zapier to setup a daily zap for all of my beemidners towards sheets, but it doesn’t have that option. Should I do this myself with the api then towards a simple client app & deploy that to heroku? Anyone with similar ideas? What are the options 🙂 Something like this: ![](https://us1.discourse-cdn.com/flex019/uploads/beeminder/original/2X/5/5871ee0678f632835efa761286813cb3c34ae79c.jpeg) ---
**Author:** ![cgamer1](https://avatars.discourse-cdn.com/v4/letter/c/838e76/32.png) [@cgamer1](https://forum.beeminder.com/u/cgamer1)\ **Post date:** [November 16, 2017, 3:42pm UTC](https://forum.beeminder.com/t/making-a-personal-dashboard-hopeless-idea/3597/2 "2017-11-16T15:42:37Z")
That is a difficult task. A possible consideration: If you have an Android phone you can technically create a pyramid on your home screen with widgets. ---
**Author:** ![cgamer1](https://avatars.discourse-cdn.com/v4/letter/c/838e76/32.png) [@cgamer1](https://forum.beeminder.com/u/cgamer1)\ **Post date:** [November 16, 2017, 4:45pm UTC](https://forum.beeminder.com/t/making-a-personal-dashboard-hopeless-idea/3597/3 "2017-11-16T16:45:51Z")
It looks like IFTTT has the ability to send Beeminder data to a Google sheet. Here a few options: 1. Datapoint created for a specific goal -\> update data in a specific cell 2. Datapoint created for any beeminder goal -\> Update data in a specific cell 3. Datapoint created for a specific goal/any goal -\> Create a new google sheet row 4. Send the number of buffer days left for a goal -\> create a new row or update cell So you could create a Google Sheet with the cells in the form of a pyramid. From there you can add conditional formatting to each cells to change the color (e.g. if there are less than 2 buffer days highlight red) ---
**Author:** ![bcool](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bcool](https://forum.beeminder.com/u/bcool)\ **Post date:** [November 18, 2017, 6:02pm UTC](https://forum.beeminder.com/t/making-a-personal-dashboard-hopeless-idea/3597/4 "2017-11-18T18:02:54Z")
> [@cgamer1](#): > > Send the number of buffer days left for a goal -\> create a new row or update cell I setup up a trigger to see if this actually works. > N days of safety buffer for a specific goal > This Trigger fires when a specific goal gets too close to derailing. You choose which goal and how many days before derail it should fire when you set up the Trigger. I make this applet: IF more than 1 day for a goal that currently has 38 days to derailment THAN fire the trigger to post (XYZ) to a specific cell in a sheet. When I click on “check now” for the applet, it should send some information to the sheet right? But the applet still says: “never run”. Did a couple more combinations, but none seem to work. Debugging this applet seems too time consuming as I don’t know why the applet isn’t firing the trigger. Anyone has done this setup? Thinking about using the api again. Giving goals priorities and based on that order them in 3 lists. Will come back later to this. The current user dashbaord e.g. /username is certainly something that could benefit from this idea. ---
**Author:** ![bcool](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bcool](https://forum.beeminder.com/u/bcool)\ **Post date:** [November 21, 2017, 5:20pm UTC](https://forum.beeminder.com/t/making-a-personal-dashboard-hopeless-idea/3597/5 "2017-11-21T17:20:33Z")
Anybody else wants to see a change on their goals dashboard as well? ---
**Author:** ![josephholsten](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/josephholsten/32/1733_2.png) [@josephholsten](https://forum.beeminder.com/u/josephholsten)\ **Post date:** [January 4, 2018, 8:50am UTC](https://forum.beeminder.com/t/making-a-personal-dashboard-hopeless-idea/3597/6 "2018-01-04T08:50:36Z")
Is all the data you’re after on the beeminder dashboard? If so, you should be able to wrangle it into shape using > **[stylish-userstyles/stylish](https://github.com/stylish-userstyles/stylish/wiki)** > > User styles manager for Firefox and other Mozilla software - stylish-userstyles/stylish If you’re needing to pull from multiple data sources, then there are a few dashboarding services: > **[Business Dashboards - Monitor Your KPIs with our dashboard software | Geckoboard](https://www.geckoboard.com/)** > > Use Geckoboard to build clear, effective data dashboards for your business that keep teams informed, motivated and aligned around your KPIs. Try for free. Or you could build one yourself (I’ve done this at work) using: [http://dashing.io/](http://dashing.io/) ---
**Author:** ![bcool](https://avatars.discourse-cdn.com/v4/letter/b/a88e4f/32.png) [@bcool](https://forum.beeminder.com/u/bcool)\ **Post date:** [January 4, 2018, 12:07pm UTC](https://forum.beeminder.com/t/making-a-personal-dashboard-hopeless-idea/3597/7 "2018-01-04T12:07:35Z")
Hey Joseph, thanks. For now its only beeminder. Going to checkout that first link next week.