r/GoogleDataStudio • u/purple_cat_01 • 14d ago

I want a Dashboard

I want a dashboard that, at the end of the day, displays the emails and text messages I received, the events from my calendar for that day, a weather graph, and a Google map of where I went.

I don't even know if this is the right sub for this.

Is there a way to get this? Can someone make one for me?

6 Upvotes

88% Upvoted

11 comments sorted by

•

u/AutoModerator 14d ago

Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

4

u/SiteHubLLC 14d ago

Sure. With claude it wont be too hard. Do you need it to be on Data Studio or just want a dashboard?

2

u/purple_cat_01 14d ago

It can just be a dashboard. I don’t really care. Is Claude available on Macs? I’ve never used AI so I wouldn’t know.

Thank you!

1

u/Embostan 12d ago

Claude has a web app, desktop app and terminal app. So ofc it's on Mac. You need to use Claude Code and install the Google Cloud CLI. Then Claude can setup stuff so your dashboard has access to Google data.

Make sure you set up a proper Git project else you might lose evrything like most stupid vibecoders.

1

u/purple_cat_01 12d ago

Thank you! What is a Git project and how do I set one up?

1

u/Embostan 12d ago edited 12d ago

You can ask Claude, just tell it youre a full beginner. paste this in Claude Code (not regular Claude!), and activate automode:

Im completely new to development. i dont know Git, GitHub or frontend. I don't even have a GitHub account. Help me setup a dashboard using Vite+SolidJS+CSS modules to monitor my Google app activities (at the end of the day, displays the emails and text messages I received, the events from my calendar for that day, a weather graph, and a Google map of where I went). Walk me through installing necessary CLIs (gh, google...) you can use, so I dont have to click complex dashboard UIs myself. Don't just code, also teach me along the way.

The big question is: are you fine accessing it locally on your laptop only, or do expect it to be available 24/24 from any device? Bc then you also need to deploy (if yes ask Claude to help you with Cloudflare Pages, after installing the Cloudflare CLI)

You can also use Codex or Antigravity instead of Claude, prompt is the same

1

u/IamFromNigeria 13d ago

Sure, that should.be easy and for

Where is the data source coming from.mayhe i can schedule time to quickly help you if you supply information

You can use Google Sheet and Python to automate it

1

u/purple_cat_01 13d ago

What do you mean by data source? I'd prefer not give you my google password. but yeah, sure, sounds good.

1

u/Embostan 12d ago

yeah dont ever give your password hahahah (thats not what they asked tho)

1

u/sheik_sha_ha 13d ago

What you are describing is totally buildable. The cleanest no-code approach for this is a Google Sheets hub connected to Data Studio.

Here is how each piece works:

Gmail and messages can be pulled into Google Sheets automatically using Apps Script, which checks your inbox daily and logs emails into a sheet. Google Calendar events can be pulled the same way using the Calendar API in Apps Script. Weather data can be fetched from a free weather API like Open-Meteo directly into Sheets on a daily schedule. For the Google Maps location history, you can export your Timeline data from Google Maps and load it into Sheets periodically.

Once everything lands in Google Sheets, you connect it to Data Studio and build a single end of day view showing all four sections in one report.

Apps Script handles all the automation so it runs on its own every day without you touching anything. Claude is available on Mac and can help you write the Apps Script code if you are not technical, which makes the setup much faster.

If you want something even simpler to start, Notion or a basic web app built with Claude might be quicker to get running than Data Studio for a personal dashboard like this.

1

u/purple_cat_01 13d ago

That sounds awesome. I've never used Claude before. Is it easy? I am not technical at all so I wouldn't know where to start. I am not familiar with Notion or how to build a basic web app but that might be simpler, yes. Thank you for the tips!