Twelve client websites, measured every Monday, and nobody opens Search Console.
MAKE.COM· GOOGLE SEARCH CONSOLE· GOOGLE SHEETS
My client runs an SEO agency. Her clients pay for work they cannot see, so every week she showed them the proof: she opened Google Search Console for twelve websites, one at a time, and copied the numbers into a spreadsheet. I connected Search Console to that spreadsheet with Make.com. Now the numbers are in the sheet every Monday at 08:30, before she has opened anything.
The problem
SEO is slow, invisible work. The proof has to be dug up by hand.
Good SEO takes months to show, and a client paying every month wants to see that it is working. The numbers that prove it all exist in Google Search Console. They just do not come out by themselves. So every week, for every client, the same round:
- Open Search Console and switch to the right client's website.
- Set the date range back to the day the work started.
- Copy the impressions, the clicks and the average position.
- Switch to the search terms and pick out the ten that bring in the most clicks.
- Work out which of those searches used the client's own name, and which did not.
- Switch to the pages and copy the ten that perform best.
- Paste all of it into the spreadsheet, under the right client and the right date.
- Close it, open the next website, and start again.
About thirty minutes per website, twelve websites, every single week. Six hours of copying before the actual SEO work could even start.
What I built
One list of clients, and the round runs itself.
The whole automation is driven by one tab in her spreadsheet: a list of clients. Each row holds the website, the client's brand name, and the date the SEO work started. Every Monday at 08:30, Make.com reads that list and goes through it one website at a time.
For each website it asks Google Search Console three questions. How is the site doing overall? Which searches bring people in? Which pages do they land on? The answers are written into the spreadsheet as new rows, stamped with the client and the date. Then it moves on to the next website on the list.
She keeps one list. Adding a thirteenth client is one more row in it, and the next Monday that website is measured too.
The part I care about most
Not every click is proof. The automation sorts out the ones that are.
Someone who types the client's own company name into Google was going to find them anyway. Those clicks look good in a report, but they say nothing about the SEO. The clicks that matter are the other ones: strangers searching for a problem, and landing on the client's website because it now ranks for it.
So every search term Google reports is checked against the client's brand name, which she sets once in the client list. Searches that contain it count as branded. Everything else counts as non-branded. That second number is the one that proves the work is paying off.
Google keeps rare searches private, so those clicks count in the total but in neither column. The report shows what Google shows, and does not fill the gap with a guess.
Total clicks tell a client their website got visitors. Non-branded clicks tell them the SEO is working.
Why a pile of rows, and not twelve tabs
Collect everything in one place, then build every view from it.
Before, every client had their own tab, filled in by hand. The automation does not write into twelve differently shaped tabs. It adds rows to one long record, every week, and never overwrites the week before. Every row carries the client and the date.
That makes it the fastest place to find anything: filter on a client and a date, and the right numbers are there. From the same record she fills each client's own sheet and builds dashboards, for herself and for her clients. And because every week is measured from the day the work started, the history of each website builds itself, one Monday at a time.
Typing goes in on the left, reading comes out on the right. Nothing in the middle is touched by hand.
What changed
Monday used to start with copying. Now it starts with the numbers.
Six hours back, every week
About twenty-six hours a month that went into copying now go into the SEO work her clients actually pay for.
Every client measured the same way
Same date range, same brand rule, same three reports, twelve times over. No number pasted into the wrong row at the end of a long morning.
Proof before anyone asks for it
When a client wants to know if the SEO is working, the answer is already in the sheet, with the history behind it.
What she owns now
A new client is a row in her list, not a call with me.
Taking on a new client means adding their website, their brand name and their start date to the client list. Dropping one means deleting the row. The next Monday the automation follows the list, whatever it says.
This is also the smallest shape a useful automation can take: one trigger, one list, one record. Nothing clever, nothing to maintain. It does one boring job, on time, every week, so that the person who used to do it can go back to the work that needs her.
About thirty minutes per website, twelve websites, every week. Six hours of copying numbers, gone.
Which report do you rebuild by hand every week?
If a Monday morning or the end of every month disappears into copying the same numbers into the same spreadsheet, that is time you are paying for and not getting back. Book a free audit call and I will map it with you.
Get your free audit call →