With TMR’s Google Analytics 4 connector, you can easily streamline and display essential data from multiple GA4 accounts in one Google Sheets dashboard. Let me explain how to connect your GA4 account to Google Sheets using Two Minute Reports.
| Required permissions: To access and view data in Google Analytics, you need a Google Account with Viewer access at both the Property and View levels. For more information on access management in Google Analytics, please refer to their documentation. |
Step 1: Install and launch Two Minute Reports
Start by installing TMR in Google Sheets. You can follow this step-by-step tutorial: How to install TMR in Google Sheets?
After installation, you can connect your GA4 account with Two Minute Reports to access your website and campaign performance.
Step 2: Create a new Connection to streamline your GA4 account
- Click Menu at the top left of the sidebar and navigate to the Connections section. Next, click Add to create a new Connection.
The “Adding new connection” dialog box appears. Here, you can perform three key steps to access your client’s GA4 accounts.
- Selecting the Google Analytics 4 Connector
- Authentication
- Enabling respective accounts with Google Analytics 4 Connector
Select the Google Analytics 4 Connector from the list of options and authorize the Connection by entering your login credentials.
- Once you’ve successfully authenticated, you’ll see a screen displaying your Account name, ID, Connection name, and Status. Enable the toggle for the accounts you wish to query.
- Remember, you cannot extract data from disabled accounts.
| Once you’ve enabled the necessary accounts, you can hit “Refresh Connections” to ensure the connected accounts are reflected in the TMR sidebar. |
And that’s it. You can now extract Google Analytics 4 KPIs in Google Sheets to gain actionable campaign insights.
Step 3: Fetching Google Analytics 4 data to Google Sheets
- Go to the Data Queries section in the TMR sidebar to pull specific performance data from your GA4 account.
- Click Add and choose the respective Google Analytics 4 accounts you wish to analyze.
- You can manage multiple clients’ GA4 accounts under one roof. Simply select one or more accounts to extract actionable insights.
- Alternatively, navigate to the Clients section. Add your client and map their corresponding GA4 account.
- Click on “Manage Clients” and input the necessary account details. Once completed, click “Save & Close” to save your client’s details for future reference.
- Next, add the required Google Analytics 4 metrics and dimensions you want to analyze. Select the date range for which you want to measure performance.
- You can further configure your data reporting by selecting relevant fields, sorting them in ascending or descending order, and applying custom filters to display only the necessary information.
Once you finish the above steps, click Run Query to visualize the final output.
You can also use various Google Sheets features, such as pivot tables and VLOOKUP(), to extract critical insights and build charts to visualize your website or app performance.
| Pro TMR Tip: Run all your queries directly from the Extensions menu in Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action. |
Step 4: (Optional) Get automatic data updates via Schedule Refresh
After creating a report in Google Sheets, you can schedule automatic updates to receive updated data. This feature is particularly useful for sending emails or refreshing your spreadsheets with live data to use as a dashboard.
Under the email section, you can enter the recipient’s email ID and save the new schedule.
You can also specify the reporting format–insert the sheet content into the email body, attach the selected sheet as a PDF or Excel, or attach the spreadsheet as an Excel file.
Two Minute Reports’ Schedule Refresh feature has additional capabilities. To learn more, read “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. If you have any questions, please contact our support team at support@twominutereports.com.