Sheets & Looker Studio
Google Sheets and Looker Studio: Miraqo's data in your own dashboard.
A Google Sheet on your Drive, updated every day with your project data: connect it to Looker Studio or open it in Excel.
Sheets & Looker Studio: how it works
- 01
The connection
A Google account connected from the project settings, with a permission limited to files created by Miraqo.
- 02
The sheet
“Miraqo — project name” appears on Drive with six tabs, rewritten every day.
- 03
The dashboard
Looker Studio reads the sheet as a “Google Sheets” source: each tab is a table.
Sheets & Looker Studio: a Google sheet with the project data, rewritten every day
The sheet
A Google Sheets file on Drive that Miraqo keeps up to date on its own.
- WhereOn the Drive of whoever connects the Google account, named “Miraqo — project name”.
- Six tabs with fixed namesIn English, so they stay stable identifiers for Looker Studio; column headers are in the account’s language.
- UpdatesEvery day at 7:30 Italian time, and with “Update now” whenever needed.
- Rewritten, not appendedEach run replaces the tables: connected charts always read current data.
What each tab holds
The project’s main tables, one per tab.
- KeywordsMarket, language, volume, difficulty, intent, position, change and URL on desktop and mobile, last check.
- AI VisibilityPrompt, intent and source, share of brand mentions and site citations, position among sources, role and sentiment.
- BacklinksSource, target, anchor, dofollow, authority, spam, status, first seen and lost date.
- Search Console, Audit and Indexing90 days of clicks, impressions, CTR and average position; the last 12 audits with score and issues; the indexing status of each page.
Looker Studio, Excel and the rest
The sheet is where Miraqo data meets the tools already in use.
- Looker StudioA “Google Sheets” data source: each tab becomes a table to build charts from.
- Blended dataThe tables can be combined with sales, campaigns or other data already in Looker Studio.
- ExcelThe sheet downloads from Drive as an .xlsx file.
- Other toolsAny tool that reads a Google sheet can use it as a source.
Access and control
A narrow permission and a connection that closes with one click.
- Limited permissionGoogle grants Miraqo access only to files Miraqo created: the rest of the Drive is not visible.
- Who can connect itAnyone with the “Export CSV” permission on the project.
- Deleted sheetOn the next run a new one is created, at a different address.
- DisconnectThe sheet stays on Drive and stops being updated.
Miraqo creates a sheet called "Miraqo — project name" on your Google Drive with six tabs: tracked keywords, AI visibility, backlinks, Search Console data, audit results and indexing. The sheet is rewritten every day at 7:30 Italian time, and "Update now" refreshes it whenever you want. The permission requested from Google is limited to the files Miraqo creates: the rest of your Drive is left alone.
The sheet is for anyone who wants the data outside Miraqo. In Looker Studio you add it as a "Google Sheets" data source and each tab becomes a table to build charts from, even alongside sales or campaign data. For Excel, it downloads from Drive as an .xlsx file. For ready-made reports to send to clients, there are the branded PDF reports instead.
Use cases
Sheets & Looker Studio: when to use it
- Build an SEO dashboard with the client's branding
- Combine SEO data with sales or campaigns in Looker Studio
- Run custom analysis in Excel
Questions about sheets & looker studio
No. The permission requested from Google is limited to the files Miraqo creates: the rest of your Drive stays out of reach.
Every day at 7:30, Italian time. "Update now" in the project Settings rewrites it right away.
Six tabs: Keywords, AI Visibility, Backlinks, Search Console, Audit and Indexing. Each tab is a table that Looker Studio reads as a data source.
Yes. From Drive the sheet downloads as an .xlsx file and opens in Excel.
On the next run Miraqo creates a new one, with a different address: the data source in Looker Studio has to be set up again. "Disconnect" instead leaves the sheet on your Drive and stops updating it.
Anyone with the “Export CSV” permission on the project. The sheet is created on the Drive of the Google account that connects.
Related tools
Automated Reports PDF reports with your branding, built from the project data and sent to clients automatically, every week or every month. Analytics & Traffic Sessions, users and conversions from Google Analytics 4 or Matomo next to your ranking data, in a single view. Rank Tracking Always know where your keywords rank on Google. See all featuresSheets & Looker Studio: step-by-step guides
Start monitoring
your projects today.
Create a project, add keywords, see real positions. Free to start.
Start free