Create intermediate Works with: Any AI

Looker Studio Connection and Data Source Setup Plan

Structured brief

Plan connectors, credentials and refresh safely.

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.

Rate this prompt

Loading ratings…

Plan data connections for Looker Studio. Sources: [SOURCES]. Who owns each source and who builds the reports: [OWNERS]. Credentials approach (owner's credentials or viewer's): [CREDENTIALS_APPROACH]. Freshness needs: [FRESHNESS].

Present a table by source with connector, credential owner, access level, fields exposed, refresh and caching behaviour [VERIFY], and risk. Highlight the case where a report uses its owner's credentials, because viewers may then see data they could not otherwise access, and the case where the owner leaves and the report stops working [VERIFY]. Also consider quota limits. Recommend a credentials and sharing model, preferring team-owned accounts over personal ones where policy allows, a naming convention, and a documentation sheet. Plan the steps to set up, test with a viewer account of limited rights, and hand over, with a handover checklist for when an owner changes and a quarterly access review. Never include real credentials. Rank the sources by how much would break if each connection failed, and set up the riskiest ones first. State plainly anything you are assuming about who owns each source.

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.

Related prompts