Overview
Step 1: List your sites
siteUrl
for each, which you'll need in the next step.List sites [Google Search Console]
Please fill in any necessary fields and click Run.
Preview
View the API data, get a live Google Sheet dashboard
siteUrl | permissionLevel |
---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets
Step 2: Export your queries
siteUrl
from step 1, we can now pull stats for all search queries. Paste your siteUrl below, and you can also modify the to/from dates if you want.Queries [Google Search Console]
Please fill in any necessary fields and click Run.
Preview
View the API data, get a live Google Sheet dashboard
query | clicks | impressions | ctr | position |
---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets
Step 3: Pull stats for a single query
{insertKeywordHere}
with a keyword (query) for your site.Individual query [Google Search Console]
Please fill in any necessary fields and click Run.
Preview
View the API data, get a live Google Sheet dashboard
query | clicks | impressions | ctr | position |
---|---|---|---|---|
Get a live Google Sheet
Export your data to a google sheet, with the SyncWith Addon, or download to CSV
Automatically updated
Schedule your data to update hourly or daily
Add data sources
Import additional data from other apps
Build reports & dashboards
Easily build live reports within Google Sheets