How to build a Google Sheets Google Ads cost guide

1. Manual ways to build a Google Ads cost calculator

‍

A. Start with a clean Google Sheets structure

1. Open Google Sheets and create a new spreadsheet.  
2. Rename the first tab to Raw Data and a second tab to Cost Calculator.  
3. In Raw Data, add columns: Date, Campaign, Ad Group, Clicks, Impressions, Cost, Conversions, Conversion Value.
4. Format Cost and Conversion Value as currency, and Date as a proper date.
5. Learn about formatting and basics here: https://support.google.com/docs/answer/3093480

‍

B. Export data from Google Ads

1. In Google Ads, go to Campaigns.  
2. Set the date range you care about (e.g. Last 30 days).  
3. Click the download icon above the table and choose CSV or Google Sheets export.  
4. If CSV, upload it into your Raw Data tab (File → Import in Sheets).  
5. Official guide to exporting reports: https://support.google.com/google-ads/answer/2375435

‍

C. Build core metrics in your calculator

In the Cost Calculator tab:

1. Add headers: Campaign, Clicks, Cost, Conversions, Conv. Value, CPC, CPA, ROAS, Budget, Target ROAS.
2. Use UNIQUE() to list campaigns:=UNIQUE('Raw Data'!B2:B)

3. Use SUMIF() or SUMIFS() to aggregate:
   • Clicks: =SUMIF('Raw Data'!B:B, A2, 'Raw Data'!D:D)  
   • Cost: =SUMIF('Raw Data'!B:B, A2, 'Raw Data'!F:F)  
   • Conversions: =SUMIF('Raw Data'!B:B, A2, 'Raw Data'!G:G)  
   • Conv. Value: =SUMIF('Raw Data'!B:B, A2, 'Raw Data'!H:H)
4. Derived metrics:  
   • CPC: =IF(B2=0, 0, C2/B2)  
   • CPA: =IF(D2=0, 0, C2/D2)  
   • ROAS: =IF(C2=0, 0, E2/C2)
5. Add conditional formatting to highlight campaigns below your ROAS target. Learn more: https://support.google.com/docs/answer/78413

‍

D. Add industry benchmarks and targets

1. In another tab, store benchmark CPC and conversion rates for your niche (e.g. legal, ecommerce).  
2. Use VLOOKUP() or XLOOKUP() to bring benchmarks next to each campaign.  
3. Compare your CPC and ROAS to benchmarks with simple formulas and color‑coded flags.

‍

E. Schedule manual review

1. Block 30 minutes weekly to export fresh Google Ads data.  
2. Paste it into Raw Data, let formulas recalc.  
3. Adjust budgets in Google Ads based on what the calculator reveals (e.g. increase budgets where ROAS > target).

‍

2. No‑code automation with Google Sheets + tools

‍

A. Use Google Ads’ native Google Sheets export

1. In Google Ads, create a saved report with columns you need: campaigns, clicks, cost, conversions, conversion value.  
2. From the download menu, choose Google Sheets and send it directly to Drive.  
3. Set a schedule (daily/weekly) so the report updates automatically. See: https://support.google.com/google-ads/answer/2404174
4. In your calculator spreadsheet, reference that report sheet instead of pasting CSVs. Your metrics tab recalculates whenever the report refreshes.

‍

B. Automate via AppScript inside Google Sheets

1. Open your Sheets file → Extensions → Apps Script.  
2. Write a small script that clears and reimports data from the linked report sheet into your Raw Data tab.  
3. Add a time-driven trigger (e.g. daily at 7am) so data refresh runs automatically.  
4. Apps Script basics: https://developers.google.com/apps-script/guides/sheets

‍

C. Connect through third‑party no‑code tools

1. Use a tool like Zapier, Make, or similar to connect Google Ads → Google Sheets.  
2. Configure a scenario: every day, pull campaign metrics and append a new row in Raw Data.  
3. Let your existing calculator formulas compute CPC, CPA, and ROAS.  
4. Add a second automation that sends a Slack or email summary when ROAS drops below a threshold.

‍

Pros of no‑code methods  

• Huge time savings vs manual exports.  
• Less prone to copy‑paste errors.  
• Easy to maintain for non‑developers.

‍

Cons  

• Limited conditional logic compared to a full AI agent.  
• Still requires you to interpret the sheet and update budgets yourself.

‍

3. Scaling with an AI agent as your cost analyst

Now you let an AI computer agent operate like a junior analyst who never gets tired.

‍

A. Agent‑driven desktop and browser workflow

1. Configure your AI agent to open Google Ads, log in, and navigate to the Campaigns view.  
2. It downloads the latest performance report or opens the existing scheduled report in Google Sheets.  
3. The agent pastes or syncs fresh data into Raw Data, verifies row counts, and checks that totals match Google Ads.  
4. It reviews CPC, CPA, and ROAS columns in your calculator tab, using your rules: e.g. “flag campaigns with ROAS < 3 or CPA > $100.”
5. The agent writes a short summary in a Notes tab: which campaigns to cut, which to scale, and by how much.
6. Optionally, it can log back into Google Ads and propose budget changes, leaving them in draft or applying them with your approval.

‍

Pros  

• End‑to‑end automation: data refresh, analysis, and suggested actions.  
• Works across desktop, browser, and cloud apps exactly like a human.  
• Transparent execution: every click and edit is inspectable.

‍

Cons  

• Requires initial setup and onboarding (documenting your rules and targets).  
• You’ll still want human oversight, especially for big budget moves.

‍

B. AI agent for multi‑account, multi‑sheet scaling

1. If you run an agency, configure the agent with a roster of clients, their Google Ads accounts, and the corresponding Sheets calculators.  
2. On a schedule, the agent loops: account by account, it refreshes the reports, updates Sheets, and generates per‑client summaries.  
3. It can email or Slack each client’s snapshot, pulling key stats directly from the calculator tabs.

‍

Pros  

• Scales from one account to dozens without extra headcount.  
• Consistent logic across all clients; no forgotten accounts.  
• Frees humans to focus on creative and strategy instead of manual reporting.

‍

Cons  

• You must keep naming conventions and sheet structures consistent so the agent can navigate reliably.

With this stack—Google Ads for data, Google Sheets as the cost brain, and an AI agent as the operator—you move from reactive, manual reporting to a living, automated system that defends your margins every single day.