Looker Studio Spreadsheet-Based Dashboard With Controls
Build a dashboard on top of a spreadsheet.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Plan a dashboard from a spreadsheet. Columns and sample rows: [SPREADSHEET_SAMPLE]. Questions to answer: [QUESTIONS]. Who edits the spreadsheet: [EDITORS]. Sheet-based dashboards are fragile if columns are renamed, so keep it simple. Sheet design rules: one header row, one row per record, consistent types, no merged cells. Add a data check tab with formulas described in words: count of blank required cells, count of dates outside the expected range, and count of duplicate IDs. Explain how to connect it, which fields to create (such as month from date and a conversion rate protected against zero), and which controls (date range, drop-downs) to add, including the risk that two controls conflict. Propose charts and scorecards with definitions. Prevent breakage by protecting headings and agreeing who edits. If a column is renamed, update the data source schema and check each chart [VERIFY]. Test with five records where every number can be predicted. Mention data refresh and caching [VERIFY].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.