Google Ads Report Automation: 3 Free Ways to Get a Weekly Email
The short answer
A Google Ads report doesn’t need a paid tool or a Monday morning of copying numbers. Google Ads can email a saved report on a schedule, Data Studio (the free tool called Looker Studio until April 2026) can send a PDF dashboard to people with no account access, and a short script can fill a Google Sheet and email you a summary. Pick one, set it up once, and spend your time reading the numbers instead of collecting them.

On this page
- What belongs in a weekly Google Ads report
- Way 1: Schedule a Google Ads report by email
- Way 2: A Data Studio dashboard by email
- Way 3: A free script that fills a Sheet and emails you
- Which Google Ads report should you set up?
- How to read a Google Ads report in five minutes
- When a paid reporting tool is worth it
- The copy-ready checklist
- A worked example: one Monday email
- Frequently asked questions
Most small accounts don’t need a reporting tool. They need the same few numbers at the same time every week, in a place someone will actually look. This guide covers the three free ways to automate a Google Ads report, starting with the one that takes five minutes, then what to put in it, how to read it, and when a paid tool starts to earn its fee. The steps come from Google’s own help pages, checked on 5 November 2026.
What belongs in a weekly Google Ads report
A report earns its place if it tells you what to look at next. For a small account, that’s a short list, in this order:
- Cost against plan. What you spent, next to seven times your average daily budget.
- Clicks. A sudden drop points to a paused campaign, a disapproved ad or a budget problem.
- Conversions. The leads, calls or sales you count as primary conversions.
- Cost per conversion. If you sell online, add conversion value as well.
- Change on the week before. A number on its own says little; a direction says more.
- Campaigns with spend and no conversions. This is the line most worth reading.
Leave everything else, such as impressions, click-through rate and quality score, in the account, where you can act on it. If you follow our Google Ads checklist, this Google Ads report is where the weekly routine starts: it tells you where to look before you open anything.
A report can’t fix tracking. If the conversions column is empty or looks wrong, sort that out first; conversion goals are the first campaign setting in our Google Ads campaign settings guide.
Way 1: Schedule a Google Ads report by email
This is the fastest route, with nothing to install. The Report Editor inside Google Ads builds tables and charts, and it can email any saved report on a schedule.
- In Google Ads, select Campaigns, then Insights & reports, then Report editor.
- Open a predefined report, or select Custom and then Table to start from a blank one.
- Drag Campaign into Row, then drag Cost, Clicks, Conversions and Cost / conv. into Columns.
- Use the date range selector at the top right. Pick a rolling range, such as the last 7 days, not fixed dates.
- Select Save and name the report.
- Select the email and schedule icon, choose the account users who should get it, set the frequency to weekly, pick a format such as CSV, and select Save.
Read the first email, and check its dates and totals against the account. Four things are worth knowing:
- Recipients need account access. The steps only offer account users, so a client or a boss with no login needs way 2 or way 3.
- It runs overnight. Google’s current page says reports begin running at 3 AM in your account’s time zone; an older page says 1 AM.
- Everyone on the account can see it. Saved reports are visible to anyone with access, so name them clearly.
- Unused reports disappear. Google removes saved reports you haven’t accessed in over 18 months. Opening or downloading one counts. A scheduled email isn’t on Google’s list, so open the report now and then.
You can also start from any table. Set up the columns and filters you want on a page such as Campaigns, click the download icon and choose Schedule. Campaign filters carry over, so a report filtered to enabled and paused campaigns picks up new campaigns by itself. The same icon downloads the table as Excel CSV, TSV, PDF, XLSX, XML or Google Sheets when you only need it once.
If you live in spreadsheets, Google also has a free Google Ads add-on for Sheets that creates reports in a sheet and can refresh them on a schedule. It was still listed in the Workspace Marketplace on 5 November 2026, but Google’s help says it’s only available in the English version of Sheets and in the United States, and each spreadsheet connects to one account.
Way 2: A Data Studio dashboard by email
Data Studio is Google’s free reporting tool. If you know it as Looker Studio, it’s the same product: Google brought the old name back in April 2026, existing reports moved across with no action needed, and lookerstudio.google.com now redirects to datastudio.google.com. Older guides still use the Looker Studio name.
Use it when the reader has no Google Ads login, or wants charts on one page instead of a spreadsheet. This Google Ads report takes longer to build, but you only build it once. Google’s connector guide has the full steps:
- Sign in to Data Studio, select Create, then Data Source.
- Select the Google Ads connector, and authorize access if you’re asked.
- Select All accounts, choose your account, select Overall Account Fields, then Connect. That option puts all your Google Ads fields in one list.
- Check the credentials at the top of the fields panel. Owner’s credentials let other people view the data without their own access to it.
- Select Create report, then Add to report.
- Add a scorecard each for cost, conversions and cost per conversion, then a table by campaign and a time series chart.
The Report Gallery also has community-built reports, including a Google Ads one when we looked, which can save the layout work. They aren’t Google’s, so check every metric before you send one to anyone.
To send it, view the report, select Share, then Schedule delivery. Add recipients, choose the pages, set the start date and time, and use Repeat to make it weekly. The email carries the report as a PDF, a preview of the first page and a link to the full report. Without the paid Data Studio Pro edition, these limits apply:
- One schedule per report, once a day at most. More schedules, hourly delivery and delivery to Google Chat or Slack need Pro.
- 50 recipients per schedule. Individual accounts can email 200 recipients a day and 800 a month; Google Workspace accounts 500 and 3,000. Past a quota, further emails aren’t sent, and you can’t check how close you are.
- Your computer’s time zone. Delivery follows your operating system’s time zone, and you can’t change that inside Data Studio.
- Google Ads data refreshes every 12 hours. You can’t change that, so don’t expect a match with the account to the minute.
- Missing data. Campaigns with zero impressions don’t appear, and Auction Insights fields are no longer available in the connector.
Agencies can connect up to 50 sub-accounts of a manager account to one data source. Read Google’s warning first: viewers of a report built on a manager account need access to that manager account and to every selected sub-account. For a client-facing report, connecting the client’s own account avoids that.
Way 3: A free script that fills a Sheet and emails you
A Google Ads script runs inside your account on Google’s servers, so there’s nothing to install or host. This one reads last week, Monday to Sunday, and the week before. It adds one row per campaign to a Google Sheet and emails a short summary: cost, clicks and conversions, each with the change on the week before, then cost per conversion and any campaign that spent money without converting. It only reads Google Ads and never changes a campaign.
After a few months, the Sheet gives you what an email can’t: a history you can chart, filter or point a Data Studio report at. First, create a blank Google Sheet and copy its URL. Then, in Google Ads, click the Tools icon, open Bulk actions and choose Scripts, then click the plus button (Google’s scripts help has screenshots). Name the script, delete the sample code and paste this:
// Weekly Google Ads report: a campaign table in a Google Sheet and a summary email.
// Guide: https://marketingstackhub.com/blog/google-ads-report/
// It only reads Google Ads. Schedule it weekly, on Monday, at 6 AM or later.
const SHEET_URL = 'PASTE YOUR SHEET URL HERE';
const TAB_NAME = 'Weekly report'; // created for you if it doesn't exist
const EMAIL_TO = 'you@example.com'; // separate several addresses with commas
const HEADERS = ['Week', 'Campaign', 'Cost', 'Clicks', 'Conversions', 'Conv. value',
'Cost / conv.', 'Cost week before', 'Conversions week before'];
function main() {
if (SHEET_URL.indexOf('https://') !== 0) throw new Error('Paste your sheet URL into SHEET_URL.');
const account = AdsApp.currentAccount();
const today = Utilities.formatDate(new Date(), account.getTimeZone(), 'yyyy-MM-dd');
const noon = new Date(today + 'T12:00:00Z');
const sinceMonday = (noon.getUTCDay() + 6) % 7;
const day = n => new Date(noon.getTime() + n * 86400000).toISOString().slice(0, 10);
const from = day(-sinceMonday - 7);
const to = day(-sinceMonday - 1);
const week = campaignStats(from, to);
const before = campaignStats(day(-sinceMonday - 14), day(-sinceMonday - 8));
const names = Object.keys(week).sort((a, b) => week[b].cost - week[a].cost);
const label = 'Week of ' + from;
const rows = names.map(name => {
const s = week[name];
const b = before[name] || { cost: 0, conv: 0 };
return [label, name, round(s.cost), s.clicks, round(s.conv), round(s.value),
s.conv ? round(s.cost / s.conv) : '', round(b.cost), round(b.conv)];
});
const now = totals(week);
const then = totals(before);
const wasted = names.filter(name => week[name].cost > 0 && week[name].conv === 0);
const lines = [
account.getName() + ', ' + from + ' to ' + to + ' (' + account.getCurrencyCode() + ')',
'',
'Cost: ' + round(now.cost) + change(now.cost, then.cost),
'Clicks: ' + now.clicks + change(now.clicks, then.clicks),
'Conversions: ' + round(now.conv) + change(now.conv, then.conv),
'Cost / conv.: ' + (now.conv ? round(now.cost / now.conv) : 'no conversions'),
'',
];
if (!names.length) lines.push('No campaign had impressions. Check billing and campaign status.', '');
if (wasted.length) {
lines.push('Spend and no conversions:');
wasted.forEach(name => lines.push('- ' + name + ': ' + round(week[name].cost)));
lines.push('');
}
lines.push('Full table: ' + SHEET_URL, '',
'Conversions are counted on the click date, so this number can still rise.');
const subject = 'Google Ads report: ' + label;
if (AdsApp.getExecutionInfo().isPreview()) {
Logger.log(subject + '\n\n' + lines.join('\n'));
return;
}
writeRows(rows, label);
MailApp.sendEmail(EMAIL_TO, subject, lines.join('\n'));
}
function campaignStats(from, to) {
const rows = AdsApp.search(
'SELECT campaign.name, metrics.cost_micros, metrics.clicks, metrics.conversions, ' +
"metrics.conversions_value FROM campaign WHERE segments.date BETWEEN '" + from +
"' AND '" + to + "' AND metrics.impressions > 0");
const stats = {};
while (rows.hasNext()) {
const row = rows.next();
const s = stats[row.campaign.name] || { cost: 0, clicks: 0, conv: 0, value: 0 };
s.cost += Number(row.metrics.costMicros || 0) / 1000000;
s.clicks += Number(row.metrics.clicks || 0);
s.conv += Number(row.metrics.conversions || 0);
s.value += Number(row.metrics.conversionsValue || 0);
stats[row.campaign.name] = s;
}
return stats;
}
function writeRows(rows, label) {
const book = SpreadsheetApp.openByUrl(SHEET_URL);
const sheet = book.getSheetByName(TAB_NAME) || book.insertSheet(TAB_NAME);
if (sheet.getLastRow() === 0) sheet.appendRow(HEADERS);
const weeks = sheet.getRange(1, 1, sheet.getLastRow(), 1).getValues();
if (!rows.length || weeks.some(row => row[0] === label)) return;
sheet.getRange(sheet.getLastRow() + 1, 1, rows.length, HEADERS.length).setValues(rows);
}
function totals(stats) {
return Object.keys(stats).reduce((t, name) => {
t.cost += stats[name].cost;
t.clicks += stats[name].clicks;
t.conv += stats[name].conv;
return t;
}, { cost: 0, clicks: 0, conv: 0 });
}
function change(now, before) {
if (!before) return ' (nothing the week before)';
const pct = Math.round((now - before) / before * 100);
return ' (' + (pct > 0 ? '+' : '') + pct + '% on the week before)';
}
function round(n) {
return Math.round(n * 100) / 100;
}
Change the three lines near the top: your sheet’s URL, the tab name if you want a different one, and your email address. Then:
- Click Authorize now, then Grant access. The script needs your Google Ads account, your Google Sheets and permission to send email from your Google account.
- Click Preview. Google’s preview mode only protects Google Ads itself, not other services, so this script checks for preview: it writes the email to the log and leaves the sheet and your inbox alone.
- Click Run once, then check the sheet and the email.
- On the Scripts page, set the Frequency column to weekly: Monday, at 6 AM or later. Google says statistics can be delayed up to 3 hours.
A few details help once it’s running. If it runs twice in a week, it sends a second email but doesn’t add duplicate rows. If no campaign had impressions, the email says so, which is a useful alarm for a billing problem or a paused account. It pulls the week before fresh on every run, so that column picks up late conversions. A run can last 30 minutes, and a free Google account can email 100 recipients a day, far more than this needs.
We tested the script’s logic offline against mock Google Ads, Sheets and email services, with 32 checks: normal weeks, runs on other weekdays, a new year, campaigns with no conversions, an empty account, a brand-new account, a second run in one week, and preview mode. It hasn’t run in your account, so preview it first and compare the first email with the account.
If you’d rather start from Google’s code, its Account Summary Report script fills a template sheet with charts and sends a daily email for the whole account. It has no breakdown by campaign.
Which Google Ads report should you set up?
Choose by who reads it, not by which tool looks best:
- You, on your own account: way 1. It takes five minutes, and you can move up later.
- You, and you want history: way 3. The Sheet builds up week by week, and the email flags what needs a look.
- A client or a boss with no login: way 2. Send the PDF weekly or monthly, with a link they can open.
- Both: ways 2 and 3 work well together: the script for you on Monday, and a dashboard for everyone else.
Whichever you pick, send one report at one time. Three overlapping emails get ignored faster than one.
How to read a Google Ads report in five minutes
Start with cost. Compare it with your plan. A week slightly over seven days’ budget isn’t a fault: Google can spend more on some days, and your monthly limit is 30.4 times your average daily budget for most campaigns. Look harder when the gap grows two weeks running.
Treat recent conversions as unfinished. Google’s main conversion columns are calculated from the time of the click, not the time of the conversion. If someone clicked last week and converted this week, both land in last week. So the newest week usually looks worse than it will. Google warns about exactly this: spend is fully reported, while some of the people who clicked haven’t converted yet.
That’s why one bad week in a Google Ads report rarely justifies a big change. Judge cost per conversion across four weeks. When you need a complete number, Google suggests a date range ending at least 30 days ago, or longer if your conversion window is longer. The same delay decides when to judge a Smart Bidding target change, as our target CPA and target ROAS guide explains.
Comparing with GA4 or Shopify? Add the Conversions (by conv. time) column. Google says it helps with that comparison, and that gaps, often up to 20%, are still expected because the tools attribute conversions differently.
Then pick one place to look. The report tells you where to look, not what to change. If cost rose and conversions didn’t, open the search terms first. If a campaign spent with no conversions, check its tracking and landing page. Then follow the weekly checklist and make one change, so next week’s numbers can show what it did.
When a paid reporting tool is worth it
The free routes are strong inside Google and weaker outside it. Three signs say you’ve outgrown them:
- Several ad platforms in one report. If you also run Microsoft Ads or ChatGPT Ads, you’ll want one view. Data Studio’s connector gallery lists partner connectors for other platforms, so check what each one costs.
- Many client accounts. Building and checking a report per client takes time a template tool can save.
- Someone spends an hour a week fixing the report. That hour has a price, so compare it with the subscription.
If that’s you, our marketing analytics tools guide covers the options beyond GA4, and our automation tools guide compares the platforms that move data between apps. An automation platform needs Google Ads API access to read your account, which a script doesn’t, as we explain in our search terms guide.
The copy-ready checklist
Copy this into your notes, and work through it when you set up your Google Ads report:
GOOGLE ADS REPORT SETUP
PICK ONE
[ ] Inbox only: a saved
report, emailed
[ ] No login needed: a
Data Studio PDF
[ ] History and flags:
the script
WHAT GOES IN
[ ] Cost against plan
[ ] Clicks
[ ] Conversions
[ ] Cost per conversion
[ ] Conv. value, if used
[ ] Change on last week
[ ] Spend, no conversions
BEFORE YOU RELY ON IT
[ ] Rolling date range
[ ] Right recipients
[ ] Time zone checked
[ ] First email read
[ ] One campaign matches
the account
EVERY MONTH
[ ] Open the saved report
[ ] Compare four weeks
[ ] Remove old recipients
A worked example: one Monday email
Here’s how the script’s email might read for the invented plumber from our Google Ads checklist: one Search campaign, a $100-a-day budget and a $700 weekly plan.
- Cost: 760 (+10% on the week before)
- Clicks: 190 (-5% on the week before)
- Conversions: 7 (-22% on the week before)
- Cost / conv.: 108.57
It takes a minute to read. Spend is $60 over plan, which Google’s budget rules allow, so the budget stays as it is. Cost rose while conversions fell, so the plumber opens the search terms, finds job-seeker searches and adds them as negatives. That’s the one change for the week.
A week later, the new row’s Conversions week before column shows 8, not 7: someone who clicked that week called a few days later. That takes the week’s cost per conversion from $108.57 to $95.00. The fall was real, but smaller than the first email suggested, which is why a single week never justifies a big change.
The bottom line
A Google Ads report is worth automating because the value is in reading it, not building it. Start with a scheduled email today. Add a Data Studio dashboard when someone without a login needs the numbers, or the script when you want a history and a Monday summary. Keep it to a few numbers, treat the newest conversions as unfinished, and let each report lead to one change.
Frequently asked questions
How do I schedule a Google Ads report?
Go to Campaigns, then Insights & reports, then Report editor, and save a report. Open it, select the email and schedule icon, choose the account users, set the frequency and format, and select Save.
Can I send a Google Ads report to someone without account access?
Not with the built-in schedule, which only offers account users. Use a Data Studio report with owner’s credentials and scheduled delivery, or a script that emails any address you enter.
Is Data Studio the same as Looker Studio?
Yes. Google renamed Looker Studio to Data Studio in April 2026, and existing reports moved across automatically. It’s still free, and the paid edition is now Data Studio Pro. Looker itself is a separate product.
Can a Google Ads report go to Google Sheets automatically?
Yes, in two ways. A Google Ads script can write to a sheet on a schedule. Google’s Sheets add-on can refresh reports on a schedule too, but Google’s help says it’s limited to English and the United States.
What should a weekly Google Ads report include?
Cost against plan, clicks, conversions, cost per conversion, the change on the week before, and any campaign that spent money without converting. Add conversion value if you sell online.
Why did last week’s conversions go up after the report went out?
Google’s main conversion columns use the time of the click, so a conversion that happens today is reported on the day of the click. Recent weeks keep growing until the delay runs out.
How often should a small business check a Google Ads report?
Weekly for the numbers, and monthly for the trend. A daily email is rarely worth reading on a small account, because a single day holds too few conversions to mean anything.
Do I need a paid tool for a Google Ads report?
Not for one account on one ad platform. The three free ways cover that. A paid tool starts to earn its fee when you report on several platforms in one place, or on many client accounts.
Related guides
- Google Ads Checklist — the 20-minute weekly routine this report feeds
- Google Ads Search Terms — a free script and an AI step for the weekly search-term triage
- Google Ads Campaign Settings — 10 defaults to check before you launch a campaign
- Microsoft Ads Import — copy your Google Ads campaigns across and check 8 settings
- Target CPA and Target ROAS — when to change a Smart Bidding target, and when to wait
- Best Automation Tools — where Zapier, Make, Pabbly and n8n differ
- PPC Tools for Google Ads — free and paid tools for research, automation and ad testing
