All tools
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.

Try free View pricing

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. In Excel you open it from Drive or import it with "Data → From Web". For ready-made reports to send to clients, there are the branded PDF reports instead.

What you can do

Sheets & Looker Studio: everything you need, ready to use.

Six tabs: keywords, AI visibility, backlinks, Search Console, audit, indexing
Updated every day, or right away with "Update now"
Ready to use as a Looker Studio data source
Opens in Excel and in any tool that reads a Google Sheet
Access limited to the files Miraqo creates
Enabled per project, by members with the "Export CSV" permission
How it works

Sheets & Looker Studio: simple to set up, solid in results.

1
Connect Google
From the project Settings → Google Sheets, with a permission limited to the files Miraqo creates.
2
Miraqo creates the sheet
"Miraqo — project name" appears on your Drive with six tabs, rewritten every day.
3
Connect Looker Studio
Add a "Google Sheets" data source, pick the sheet and build the charts you need.
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
Explore Miraqo

Related tools

Automated Reports
Create branded PDF reports for your clients, generated automatically every month.
Analytics & Traffic
Connect Google Analytics 4 or Matomo and view sessions, users and conversions next to ranking data — in a single dashboard.
Rank Tracking
Always know where your keywords rank on Google.
See all features
Help center

Sheets & Looker Studio: step-by-step guides

Create white label SEO reports in PDF
Configure templates, cover page and scheduling to generate and send SEO PDF reports with your agency's logo — 10 toggleable sections, automatic table…
Connect Google Search Console to your project
How to connect Google Search Console to the project and read the GSC Data page — metric cards with activatable chart series, 6 tabs (Queries, Pages,…
Connect Google Analytics 4 or Matomo
How to connect GA4 (Google OAuth) or Matomo (URL + auth token) to a project and read the analytics dashboard — metric card toggles, secondary KPIs,…
All guides
FAQ

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. Open it from Drive or import it into Excel with "Data → From Web".

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.

Yes, on every plan. Whoever enables it just needs the "Export CSV" permission on the project.

Start monitoring
your projects today.

Create a project, add keywords, see real positions. Free to start.

Start free
No credit card required