Analytics • Automation
RollingSearchConsolereportingwithoutspreadsheets.
30-day top queries & pages, parsed and sent on a schedule—plus dashboards.
The Brief
Keep managers informed without manual exports; make wins/losses obvious.
n8n flow hits the Search Console API, parses the last 30 days, and ships a tidy email (and Looker Studio refresh) every two days.
DESIGN & BUILD
What I shipped
- GSC API integration (property: sc-domain; rolling 30-day windows).
- Parsing & ranking: top queries, top pages, CTR & position deltas.
- Looker Studio dataset refresh + templated boards.
- Scheduled email summaries with highlights and links.
- Error handling and simple observability on run failures.
Results
Manual reporting time
Automated summaries
Stakeholder visibility
Predictable email cadence
Decision speed
Trends & deltas surfaced early
UI
Highlights
After automating the reporting loop
–90%
Time spent on monthly reporting
+3×
Stakeholder touchpoints
2d
Update cadence
Got a Shopify or automation brief?
I build fast, clear storefront UX and pragmatic n8n workflows. Let’s map the simplest path to a win.