Refresh Search Console page performance into Sheets every Monday. Keep its Looker Studio charts current and ask Claude to review the returned search data.
Your task, worked throughIllustration · no live reads or changes
Search Console → Claude
YOU
Have my Search Console report ready for Monday’s SEO review.
✦
Ask Claude for a page-performance brief for the intended property. Preserve Search Console’s reporting caveats and incomplete-day limits.
Metrics
Page · clicks · impressions · CTR · average position
→A specific SEO review brief
Datapipe → Sheets → Looker Studio
YOU
Put the SEO report in a dashboard for the team.
✦
Save the Search Console report and export to Sheets. Build custom page-performance charts in Looker Studio using that Sheet.
Destination
Existing Google Sheet → custom Looker Studio charts
→The SEO report has a dashboard destination
Datapipe
YOU
Refresh this Search Console report every Monday.
✦
In Schedule & send, choose Last week (Mon–Sun), Every Monday and Save. Confirm the next run. Search Console can lag; inspect the dates actually returned.
Refresh
Every Monday · 06:00 UTC
Monday SEO report
✓Last week · Monday–Sunday
✓Every Monday · 06:00 UTC
✓Search Console → existing Sheet → Looker Studio
Illustrative output · no live report values
→A saved weekly SEO refresh
Search Console → Claude
YOU
Claude, what changed in the latest complete search data?
✦
After checking the refresh, ask Claude to compare available complete dates and explain page changes. The Datapipe schedule refreshes data; automatic Claude commentary needs separate supported setup.
Separate steps
Datapipe data refresh · Claude interpretation
Refresh, then review
✓Verify source and Sheet update
✓Open the SEO dashboard
✓Ask Claude to explain the complete search window
Illustrative output · no live report values
→An updated dashboard and an evidence-based review
1 / 4Define the SEO report
Illustrated use case. Save the actual report, dashboard and schedule settings in the indicated app.
MAKE THE TASK CONCRETE
A Monday SEO routine with a saved data refresh and a separate Claude review.
01
Define the SEO report with Claude
Choose the intended property, page metrics and checks. Keep unavailable or incomplete source days explicit.
02
Save the report and Monday refresh
Create the source report and Sheet export. Choose Last week (Mon–Sun), Every Monday and Save. Fixed-date reports do not offer this calendar schedule. The weekly scheduled time is 06:00 UTC.
03
Review the updated dashboard
Build custom page-performance charts in Looker Studio. After the run, check source coverage, export status and freshness. Ask Claude for interpretation; an automatic assistant run is separate.
KNOW WHERE EACH STEP HAPPENS
One use case across the tools you use.
Claude
Read authorized data, agree on the questions and prepare the report, charts or review checklist.
Datapipe
Save source reports, authorize the destination, export the data and review any refresh or email settings.
Google Sheets + Looker Studio
Save a supported prepared copy or build the custom charts described above. Check each source and its freshness settings.
START WITH YOUR ASSISTANT
Give it the task. Follow up with the next step.
Copy these in order into the assistant connected to your Datapipe project.
Prepare the SEO report with Claude
Read the prompt
Use only this project’s authorized data. Discover the intended accounts and compatible fields, read complete dates, and preserve empty or unavailable results. Do not substitute fictional data.
Specify page clicks, impressions, CTR and average position for the intended Search Console property. Note reporting lag and complete date coverage; average position is not a fixed rank.
Prepare Monday setup
Read the prompt
Specify the source report, Sheet export and custom Looker Studio charts. Choose Last week (Mon–Sun), Every Monday and Save in Datapipe. Prepare the configuration and checklist. Save reports, authorize Sheets and save schedules in Datapipe; save or build dashboards in Looker Studio. Do not claim these actions happened from a draft or a read. Every Monday is scheduled for 06:00 UTC. Confirm the next run. Automatic AI commentary is a separate assistant setup.
Review the refreshed SEO data
Read the prompt
Claude, read the complete available Search Console dates after the refresh. Explain pages gaining or losing clicks, query mix and reporting limitations. Keep your interpretation separate from proof that the schedule or destination succeeded.
A FEW USEFUL ANSWERS
Before you start.
What time is the Monday SEO update?
Every Monday is scheduled for 06:00 UTC. Confirm the next run and your local time. Source lag and provider processing can affect available dates.
Does the schedule automatically run Claude?
No. It refreshes the report and configured destinations. Ask Claude to review the available data, or separately configure a supported assistant setup for automatic commentary.
How do I check the update?
Check source-read status, actual returned dates and destination delivery separately. Looker Studio has its own freshness and cache settings. Empty real reads remain empty.
Datapipe
