Data & reporting integrations
Looker Studio integration
There's no dedicated Looker Studio connector yet. Export AutoSEO tables to Google Sheets, or load answers, prompts, mentions and citations from the REST API — and build your dashboards on top.
Overview
What you get for Looker Studio dashboards
- Beta: data reaches Looker Studio through Google Sheets, not a native connector
- Export tables such as tracked prompts, competitors, sources, fan-outs, tasks and rankings to Google Sheets
- REST API export of answers, prompts, mentions, citations and fan-outs as CSV or NDJSON
- Incremental exports with a since parameter for scheduled refreshes
- API keys with separate read, write, spend and export scopes
- The built-in Report Builder as an alternative for client-ready decks
Use cases
What you can do with Looker Studio and AutoSEO
Add AI visibility to existing dashboards
Put mention rates, citations and competitor data into the Looker Studio reports your stakeholders already read.
Blend with GA4 and Search Console
In Looker Studio, combine an AutoSEO sheet with your GA4 or Search Console data sources in one report.
Refresh on a schedule
A small script — for example in Google Apps Script — can call the export endpoint with your API key and append new rows to the sheet Looker Studio reads.
Setup
Get data into Looker Studio in three steps.
- 1 Step 1
Export a table to Google Sheets
Open a table in AutoSEO, choose Export → Google Sheets and connect your Google account the first time. AutoSEO creates the spreadsheet in your Drive.
- 2 Step 2
Or pull data from the REST API
Under Settings → API & MCP, create a key with the export scope and call GET /api/v1/projects/{projectId}/export with format=csv.
- 3 Step 3
Add the sheet in Looker Studio
In Looker Studio, add a Google Sheets data source that points to the spreadsheet and build your charts.
FAQ
Frequently asked questions
Is there an AutoSEO connector for Looker Studio?
Not yet — the integration is in beta. Today you connect through Google Sheets: export tables from AutoSEO or fill a sheet from the REST API, then use it as a Looker Studio data source.
Which AutoSEO data can I use in Looker Studio?
Any table with Export → Google Sheets, plus the REST API export of answers, prompts, mentions, citations and fan-outs as CSV or NDJSON. Other endpoints cover visibility metrics, AI traffic, Search Console and attribution data.
How do I keep a Looker Studio dashboard up to date?
Sheets exports are snapshots. For regular updates, call the export endpoint on a schedule with since set to the previous high-water mark and append the new rows to your sheet.
What access does the Google Sheets export need?
Google's drive.file permission, which only covers spreadsheets AutoSEO creates. On a self-hosted instance, an admin first registers a Google OAuth client under Admin → Data Providers.
Is the REST API included in AutoSEO?
Yes. The REST API, the MCP server and all exports are part of the open-source app: free when you self-host, and included in an AutoSEO Cloud workspace.
Data & reporting integrations
More integrations in this category
- AutoSEO REST APIREST API v1 with OpenAPI spec for prompts, visibility, traffic and reports.
- AutoSEO MCP serverConnect Claude, ChatGPT, Cursor or VS Code with 100+ MCP tools.
- Google SheetsExport keyword, ranking, backlink and audit tables to Google Sheets.
Bring AI visibility into your dashboards
Start with an AutoSEO Cloud workspace for $50/month, or self-host the open-source edition for free.