Export Google Analytics into a spreadsheet and schedule automatic updates
Extract your Google Analytics website traffic, conversions, events, build custom reports, and more.
Ready to Get Started?
(click to install in Google Workspace)
to export your Google Analytics data into a spreadsheet so you can analyze it and build custom reportsgoogle analytics
you’ll get a few results, including our GA v3 connector and various Google Analytics templates.Already have SyncWith Installed?
Last 30 days
Last 90 days
Last Month
Month to Date
Last 5 Months
Campaign
First user campaign
Session campaign
YYYYMMDD
YYYY
Session source
if you want the same effect. This will help you understand which sources drive the most conversions. Eg Google drives more conversions than Reddit.First user source
would be Google
newsletter
email
cpc
.Search
Display Shopping
Video
Discovery
App
Smart
Hotel
Local
Performance Max
United States
India
Canada
Brazil
United Kingdom
Japan
France
Germany
/
- the root of your website /support
- your support page /pricing
- your pricing pagePricing
- Acme Services Pricing Plans
this might correspond to a page location of https://www.example.com/pricing/plans?query_string=valuehttps://www.example.com/about/contact-us?query_string=value
Populated by the event parameter 'page_location'.www.example.com/about/contact-us?query_string=value
/about/contact-us?query_string=value
/about/contact-us
?query_string=valueEvent count
and Event value
to understand the performance of your custom eventsad unit exposure
or Publisher ad impressions
. This is app specific.country
and date
as dimensions you still need to specify what you want to know about them, for example show me my Views
and Sessions
by date
by country
.MAU
- monthly active users and DAU
- daily active users. You’ll also see metrics like Engaged sessions
that leverage the advanced measurement baked into GA4.Engaged sessions
(Sessions
- Engaged sessions
)/ Sessions
This is different from GA3 where a bounce meant a users who didn’t click to a second page which wasn’t a good measure of non-engagement, so this can be considered an improvement.Sessions
/ Active users
gives you the average number of sessions per user.Views
/ Sessions
Checkouts
{"error": {"code": 400,"message": "Requests are limited to 10 metrics within a nested request. This request is for 11 metrics.","status": "INVALID_ARGUMENT"}}
Date
AscendingSessions
DescendingManual Refresh
Is the default scheduling for a connection. Data will not be updated until you actively refresh it. In order to refresh the data you must either:Automatically refresh daily
will refresh the data into your spreadsheet every day at the same time. The time is set based on when the connection was last updated. If you wish to set the refresh to happen at a specific time you would need to open the connection and save it at that time.Automatically refresh hourly
will refresh the data every hourlyAutomatically refresh every 5 minutes
will refresh the data every 5 minutes. This is not typically used for google analytics - unless you’re looking in detail at the current day. A maximum of 100 connections can use 5 minute refresh.