Skip to content
ClickRuntime

Connect Google Analytics to Google Sheets

Google Analytics shows today's picture; a Google Sheet keeps the history, sits next to your other numbers and can be shared with anyone. Connecting them writes your key website metrics to a sheet on a schedule, ready for charts, targets and reports, without exports.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Analytics and Google Sheets

Weekly metrics logs, daily KPI checks with alerts and monthly search reports, written to your sheet. These are ready-made starting points. Anything else you can describe works too.
On a scheduleAI

Log your weekly website numbers to a sheet

Every week your key GA4 numbers are added as a row in your reporting sheet, and you get an email summarising what changed.

See how it works
On a schedule

Log daily website KPIs and get alerted when one drops

Every day yesterday's key numbers go into a sheet, and you are alerted in Slack and by email if any falls well below its recent average.

See how it works
On a scheduleAI

Write a monthly search traffic report to a sheet

Each month, organic search traffic by landing page is written to a sheet with the change from the month before, and you get an email listing the best opportunities.

See how it works
On a schedule

Log daily GA4 traffic by source to Google Sheets

Each morning yesterday's GA4 sessions, users and key events per source / medium are appended to a Traffic tab.

See how it works
On a schedule

Weekly GA4 top pages report in Google Sheets

Every Monday a new tab lists last week's top 50 pages by views, with users, engagement time and change against the week before.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Analytics and Google Sheets, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Analytics and Google Sheets automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Analytics and Google Sheets in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Each week, read the list of URLs in column A of my Pages sheet and fill in their GA4 pageviews and average engagement time for the last 7 days.

Every day, log GA4 sessions by source and mark the row red in a Status column when any source drops more than 40% from its 4-week average.

Use cases

Why people connect Google Analytics and Google Sheets

How the two apps work together

  • The script queries the GA4 Data API on a schedule, such as every morning, because GA4 has no webhooks.
  • It appends rows or updates a range in the Google Sheet you choose.
  • It can also read targets or page lists from the sheet and use them to decide what to fetch or flag.

  • Analysts keep a daily metrics table

    Users, sessions, conversions and revenue are added as one row per day. Pivot tables and charts in Sheets update on their own.

  • Agencies build client dashboards in Sheets

    Each client's GA4 numbers fill a tab that feeds a Looker Studio or Sheets chart. Monthly reports no longer need manual exports.

  • SEO teams track pages over time

    Pageviews and engagement for each landing page are logged weekly. It shows which pages are slipping long before rankings tools flag them.

  • Finance teams reconcile marketing numbers

    GA4 conversions by source are written next to spend data in the same workbook. Cost per acquisition is calculated with normal formulas.

More apps

Google Analytics, Google Sheets and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Sheet log with a Slack summary

Every morning, add yesterday's GA4 numbers to my KPI sheet and post a one-line summary with the change from the day before in #growth on Slack.

GA4 and Google Ads in one sheet

Every day, write yesterday's Google Ads spend and clicks per campaign next to GA4 conversions for the same campaigns in my Marketing sheet.

Email when a sheet target is missed

Each Monday, compare last week's GA4 signups with the target in my Targets sheet and email me if we are more than 10% below it.

Setup

Connect Google Analytics and Google Sheets once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Analytics

Analytics

  1. In Google Cloud Console, enable the Google Analytics Data API (and the Admin API if you want reports across several properties).
  2. Create a service account and download a JSON key for it.
  3. In GA4, go to Admin, Property Access Management, and add the service account's email with the Viewer role.
  4. In the ClickRuntime dashboard, open Connections & secrets, upload the JSON key and enter your numeric GA4 Property ID.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

FAQ

Questions about connecting Google Analytics and Google Sheets

Does it need access to my whole Drive?
No. It uses the Sheets permission for the spreadsheet you name, plus read-only access to your GA4 property.
Will it overwrite my formulas?
No. It adds rows below your data or writes to a tab you set aside, so formulas and charts built on top keep working.
Can I chart the results?
Yes. Rows are added in the same format every time, so a chart on the tab updates as new rows arrive.
Can it log more than one website?
Yes. List the GA4 properties and each gets its own row or tab.
How far back can it go?
GA4 keeps standard reports for years, so you can ask for a first run that fills in past weeks or months.
Can it backfill past data?
Yes. A one-time run can pull past dates from GA4 into the sheet, within the data your property retains.
Will it change rows I have edited?
Only the rows or ranges you tell it to write. Appending new rows leaves existing ones alone.
Can I choose the dimensions and metrics?
Yes. Name the GA4 metrics and dimensions you want, such as sessions by sessionSource, and the script requests those.

Related pages

Keep exploring

Tell your assistant what Google Analytics and Google Sheets should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude