Read the setup guideSetup

Google Sheets™ add-on · GA4™ and Search Console™ reports

TrafficLane — Google Analytics 4 and Search Console Reports in Google Sheets

Your traffic numbers, in your sheet, up to date.

TrafficLane puts Google Analytics™ 4 and Google Search Console™ reports into tabs of your spreadsheet: traffic by day, top pages, channels, search queries and more, for the dates you choose. Refresh with one click, or, with Pro, every day, week or month at the hour you choose, even when the spreadsheet is closed. If Google refuses a refresh, you see why, and the last good data stays.

  • Every ready-made report free
  • Read-only access to GA4™ and Search Console™
  • No BiLingoPlus server in between

Version 1.0updated 12 Nov 20267 Google permissions, none restricted

Illustration, not a screenshot.

How it works

From your analytics to a sheet in three steps

Set up a report once. After that it is one click, or no click at all with a schedule.

  1. 1Open it from the Extensions menu

    In a Google Sheets spreadsheet: Extensions → TrafficLane → Open TrafficLane. The panel lists the GA4 properties and Search Console sites your Google account can already see.

  2. 2Choose a source, a report and the dates

    Traffic by day, top pages, channels and sources, countries, devices or landing pages from GA4; queries, pages, countries, devices or days from Search Console. Last 7, 28 or 90 days, last month, month or year to date, or your own dates.

  3. 3Save and refresh, or set a schedule

    The numbers land in their own tab, with a bold, frozen header and an “Updated … by TrafficLane” note beside them. Refresh now is free. With Pro, it refreshes every day, week or month at the hour you choose.

When Google says no

A failed refresh says why, and the last good data stays

Google limits how often a property can be asked, and access can change. TrafficLane tells you in plain words, in the panel and in the tab.

  • Hourly quota used upThis GA4 property used up its Google Analytics quota for this hour. TrafficLane tries again next hour.
  • Access removedYour Google account cannot read this GA4 property any more. Check that you still have at least Viewer access in Google Analytics, or choose another property.
  • Property deletedGoogle Analytics could not find this property. It may have been deleted — edit the report and choose another one.

Messages as TrafficLane 1.0 writes them.

  • Never silentThe error shows as a red line under the report in the panel, and as a “Last refresh failed …” line in the tab, for the people who only look at the sheet.
  • The last good data staysA refresh that fails does not touch the table. Busy answers from Google are tried twice more; an hourly GA4 quota is tried again the next hour.
  • Your own data is safeEach report writes only to its own tab. TrafficLane refuses a tab that already holds data it did not write, and finds its tab again after you rename it.

Features

Made for numbers people rely on

Eleven ready-made reports

Six from GA4 and five from Search Console, with the columns already chosen and formatted as numbers, percent and dates. Filter GA4 rows by a dimension of the report, Search Console rows by page or query, and pick web, image, video or news results.

Compare with an earlier period (Pro)

Next to every number, its value for the period before or for the same dates a year earlier, and the change: in percent for counts, as a plain difference for rates and positions.

Custom GA4 reports, names checked (Pro)

Up to 9 dimensions and 10 metrics by their API names, your own custom dimensions included. When you save, TrafficLane checks every name with your property and suggests the closest one for a typo.

And more

  • Any dates: last 7, 28 or 90 days, last month, month or year to date, or your own
  • Up to 25,000 rows per report
  • Each report in its own tab, with the header bold and frozen
  • Search queries that start with =, + or @ written as text, never as formulas
  • Google’s sampling and data-threshold remarks in the tab’s note
  • Refresh all, from the panel or the Extensions menu
  • Your time zone for dates and schedules
  • A TrafficLane log tab of every refresh (Pro)

Compared

Ways to get GA4 and Search Console numbers into a sheet

Scroll the table sideways →

WayGA4 and Search ConsoleOn a scheduleWhat you getCost
Export from each report by handEach from its own screenNo, you export each timeA copy of one table; Search Console exports up to 1,000 rowsFree
Looker StudioBoth, through its connectorsScheduled emails of the reportA dashboard, not rows in your sheetFree
Your own Apps Script with a timerGA4 through the Analytics Data service; Search Console through its API by handYes, once you write and test itWhat your code writesFree, plus your time
TrafficLaneBoth, in one panelDaily, weekly or monthly at an hour (Pro)11 ready-made reports, custom GA4 reports (Pro), comparisons (Pro)Free · Pro $4.99/month or $39/year

The exports, Looker Studio™ and a script you can copy, step by step: how to get Google Analytics 4 and Search Console data into Google Sheets.

Pricing

The reports are free. Pro keeps them fresh.

Start free. Upgrade from the TrafficLane panel when you want schedules and comparisons.

Pro

Pro · schedules and more sources

$4.99/ month

or $39 a year · cancel anytime

  • Daily, weekly or monthly refreshes at the hour you choose
  • Up to 30 reports, and as many properties and sites as your account can see
  • Compare with the period before or a year earlier
  • Custom GA4™ reports and a run log tab
  • Everything in Free
How Pro works

Free

$0forever

Up to 3 reports per spreadsheet, refreshed by hand as often as you like.

  • Every ready-made GA4™ and Search Console™ report
  • One GA4™ property and one Search Console™ site per spreadsheet
  • Any dates, filters, up to 25,000 rows
  • Refresh now and Refresh all
Read the setup guide

Pro is bought inside the add-onPaddle is our Merchant of Record14-day refund on any charge

Privacy & permissions

Your numbers go from Google into your sheet, and nowhere else

ReadsThe names of the GA4 properties and Search Console sites your account can see, and the reports you set up from them: the dimensions, metrics, dates and filters you chose. Both permissions are read-only. In Google Sheets, only the spreadsheets you set TrafficLane up in: Google words its spreadsheet permission as “all your Google Sheets spreadsheets”, because scheduled refreshes (Pro) open your spreadsheet while it is closed. TrafficLane opens no other.
SendsReport data goes from Google Analytics and Search Console straight into your spreadsheet. Nothing is sent to BiLingoPlus. The add-on asks Paddle whether your email has an active Pro subscription.
Permissionsanalytics.readonly · webmasters.readonly · spreadsheets · script.external_request · script.scriptapp · script.container.ui · userinfo.email

TrafficLane cannot change your Google Analytics™ settings or your Search Console™ sites: both permissions are read-only. No Google Drive™ or Gmail™ permission, no ads, no selling of data and no AI reading your numbers.

Full privacy policy →
Made by BiLingoPlus LLC, Wyoming · support from the people who build it

Questions

Questions about GA4 and Search Console in Google Sheets

Which Google Analytics versions work?

Google Analytics 4 properties. Google switched off Universal Analytics in 2024, so there is nothing left to read there.

What access do I need?

At least Viewer access to the GA4 property, and to be a verified owner or user of the Search Console site. TrafficLane lists only what your Google account can already see.

Will it overwrite my sheet?

Each report writes to its own tab and replaces everything in that tab on each refresh. TrafficLane refuses a tab that already holds data it did not write. Build charts and formulas in another tab that points to the report tab; they keep working after every refresh.

How fresh is the data?

As fresh as Google’s. Last 7, 28 or 90 days end yesterday, because today is not complete yet; month to date and year to date include today so far. Search Console data of the last two or three days is still being collected and can change.

Do the numbers match the GA4 screens?

They come from the same Google Analytics Data API. Small differences happen when Google samples a large report or hides rows with very few users (data thresholds); TrafficLane says so in the note beside the table when Google reports it.

What happens when Google’s quota runs out?

Google limits how much each GA4 property can be asked per hour and per day. TrafficLane says which limit was hit and keeps the last good data. A scheduled refresh stopped by the hourly limit is tried again the next hour. Fewer rows or shorter dates use less quota.

Is TrafficLane free?

Every ready-made report is free, for up to 3 reports per spreadsheet with one GA4 property and one Search Console site, refreshed by hand. Pro, for schedules, comparisons, custom reports and up to 30 reports, is $4.99 a month or $39 a year, bought from the TrafficLane panel.

What can TrafficLane see in my Google account?

Read-only: your GA4 properties and Search Console sites, and the report data you ask for. In Google Sheets, the spreadsheets you set it up in. Google’s screen says it can see, edit, create and delete all your Google Sheets spreadsheets, because scheduled refreshes have to open your spreadsheet while it is closed. TrafficLane itself opens only the spreadsheets you set it up in. It has no Drive or Gmail permission.

More in Help →

Guides

Guides for analytics in your sheets

Get TrafficLane

Your traffic report, fresh every morning.

Read the setup guide
  • Every ready-made report free
  • Read-only access to GA4™ and Search Console™
  • No BiLingoPlus server in between

More tools from BiLingoPlus

Other tools from the same studio

Google Analytics™, GA4™, Google Search Console™, Google Sheets™, Looker Studio™ and Google Workspace™ are trademarks of Google LLC. TrafficLane is an independent add-on, not made or endorsed by Google.