{"id":17179,"date":"2025-01-16T10:39:52","date_gmt":"2025-01-16T01:39:52","guid":{"rendered":"https:\/\/84office.jp\/?p=17179"},"modified":"2025-01-16T11:30:17","modified_gmt":"2025-01-16T02:30:17","slug":"google-sheets-ga4-linked-add-on","status":"publish","type":"post","link":"https:\/\/84office.jp\/en\/google-sheets-ga4-linked-add-on\/","title":{"rendered":"How to Connect GA4 Data to Google Sheets: A Step-by-Step Guide Using the Official Google Analytics Add-On"},"content":{"rendered":"<div class=\"codoc-evacuations\" style=\"display:none;\" data-shortcode=\"\"><\/div>\n<p>This article is for those who want to simplify data integration between Google Analytics (GA4) and Google Sheets.<\/p>\n\n\n\n<p>By using the official Google Add-On, you can easily import data into Google Sheets and leverage it for analysis and visualization.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-60\">In this guide, we\u2019ll walk you through the steps of using the <strong>&#8220;GA4 Reports Builder for Google Analytics&#8221;<\/strong> add-on to import GA4 data into your spreadsheet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-30\">About the Google Analytics Official Add-On<\/h2>\n\n\n\n<p>The official Google Analytics add-on, <strong>&#8220;GA4 Reports Builder for Google Analytics,&#8221;<\/strong> is a convenient tool that allows you to easily import GA4 data into Google Sheets.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">With this add-on, you don&#8217;t need to manually configure the <strong>Google Analytics Reporting API<\/strong>, making it simple to fetch data.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-double is-thead-centered u-mb-ctrl u-mb-40\"><table class=\"has-fixed-layout\"><thead><tr><th data-has-cell-bg=\"1\" data-text-color=\"white\"><span style=\"--the-cell-bg: #70c0a2\" data-icon-size=\"l\" data-icon-type=\"bg\" data-text-color=\"white\" aria-hidden=\"true\" class=\"swl-cell-bg\">&nbsp;<\/span>Advantage<\/th><th data-has-cell-bg=\"1\" data-text-color=\"white\"><span style=\"--the-cell-bg: #f69f78\" data-text-color=\"white\" aria-hidden=\"true\" class=\"swl-cell-bg\">&nbsp;<\/span>Drawbacks<\/th><\/tr><\/thead><tbody><tr><td data-has-cell-bg=\"1\" data-text-color=\"black\"><span style=\"--the-cell-bg: #fbfbfb\" data-icon-size=\"l\" data-icon-type=\"bg\" data-text-color=\"black\" aria-hidden=\"true\" class=\"swl-cell-bg\">&nbsp;<\/span><span data-icon=\"circle\" class=\"swl-inline-list\">No need to manually configure the API settings.<\/span><br><span data-icon=\"circle\" class=\"swl-inline-list\">Data can be automatically updated.<\/span><br><span data-icon=\"circle\" class=\"swl-inline-list\">Easy data sharing across the entire team.<\/span><br><span data-icon=\"circle\" class=\"swl-inline-list\">Flexible data analysis through integration with Google Sheets.<\/span><\/td><td data-has-cell-bg=\"1\" data-text-color=\"black\"><span style=\"--the-cell-bg: #fffbfa\" data-icon-size=\"l\" data-icon-type=\"bg\" data-text-color=\"black\" aria-hidden=\"true\" class=\"swl-cell-bg\">&nbsp;<\/span><span data-icon=\"close\" class=\"swl-inline-list\">Menus and settings are only available in English.<\/span><br><span data-icon=\"close\" class=\"swl-inline-list\">Loading times may be longer when handling large volumes of data.<\/span><br><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong><span style=\"--the-cell-bg: #70c0a2\" data-icon-size=\"l\" data-icon-type=\"bg\" data-text-color=\"white\" aria-hidden=\"true\" class=\"swl-cell-bg\">&nbsp;<\/span>Advantage of Integrating GA4 Data with the Add-On<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The integration offers several advantages, such as <strong>automatic data updates<\/strong>, <strong>flexible data analysis<\/strong> through the combination with other spreadsheet functions, and <strong>easy sharing across the team<\/strong>.<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-40\">Key metrics like <strong>user count<\/strong>, <strong>event count<\/strong>, and <strong>page views<\/strong> from GA4 can be effortlessly imported into Google Sheets, making data analysis much simpler.<\/li>\n<\/ul>\n\n\n\n<p><strong><span style=\"--the-cell-bg: #f69f78\" data-text-color=\"white\" aria-hidden=\"true\" class=\"swl-cell-bg\">&nbsp;<\/span>Drawbacks<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The ability to customize the data retrieved is limited, meaning not all GA4 metrics and dimensions can be flexibly imported.<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-60\">When handling large volumes of data, the loading time in Google Sheets may become significantly longer.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Steps<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Installing the Add-On<\/h3>\n\n\n\n<div class=\"swell-block-step u-mb-ctrl u-mb-60\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong><strong>Open Google Sheets<\/strong><\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"509\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-56-1024x509.png\" alt=\"\" class=\"wp-image-17180\" style=\"width:585px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-56-1024x509.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-56-300x149.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-56-768x381.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/image-56.png 1504w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Start by opening a new Google Sheet.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Click &#8220;Get Add-ons&#8221;<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"363\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/99cad943f41353987e52d4d9b7e598ad-1024x363.png\" alt=\"\" class=\"wp-image-17181\" style=\"width:627px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/99cad943f41353987e52d4d9b7e598ad-1024x363.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/99cad943f41353987e52d4d9b7e598ad-300x106.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/99cad943f41353987e52d4d9b7e598ad-768x272.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/99cad943f41353987e52d4d9b7e598ad.png 1273w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>From the <strong>Extensions<\/strong> menu, select <strong>&#8220;Add-ons&#8221;<\/strong> &gt; <strong>&#8220;Get add-ons.&#8221;<\/strong><\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Install the Official Add-On: &#8220;GA4 Reports Builder&#8221;<\/strong><\/div><div class=\"swell-block-step__body\">\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"545\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/018ec664818b57452e302752bd98fd65-1024x545.png\" alt=\"\" class=\"wp-image-17183\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/018ec664818b57452e302752bd98fd65-1024x545.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/018ec664818b57452e302752bd98fd65-300x160.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/018ec664818b57452e302752bd98fd65-768x409.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/018ec664818b57452e302752bd98fd65-1536x817.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/018ec664818b57452e302752bd98fd65.png 1977w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In the search bar, type <strong>&#8220;Google Analytics&#8221;<\/strong> and search for it.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Several options will appear, but the official add-on by Google is <strong>&#8220;GA4 Reports Builder for Google Analytics.&#8221;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large u-mb-ctrl u-mb-40\"><img decoding=\"async\" width=\"1024\" height=\"296\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/114cfd7a0f7a93a07cd12eb27550fe35-1024x296.png\" alt=\"\" class=\"wp-image-17182\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/114cfd7a0f7a93a07cd12eb27550fe35-1024x296.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/114cfd7a0f7a93a07cd12eb27550fe35-300x87.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/114cfd7a0f7a93a07cd12eb27550fe35-768x222.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/114cfd7a0f7a93a07cd12eb27550fe35-1536x444.png 1536w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/114cfd7a0f7a93a07cd12eb27550fe35.png 1559w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Install the add-on.<\/p>\n\n\n\n<p>Once installed, <strong>&#8220;GA4 Reports Builder&#8221;<\/strong> will appear in the <strong>Extensions<\/strong> menu.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Creating a Report and Importing Data<\/h3>\n\n\n\n<div class=\"swell-block-step\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong><strong><strong>Open &#8220;Create New Report&#8221;<\/strong><\/strong><\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"635\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-1024x635.png\" alt=\"\" class=\"wp-image-17184\" style=\"width:543px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-1024x635.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-300x186.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-768x476.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5.png 1276w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>From the <strong>Extensions<\/strong> menu, select <strong>&#8220;GA4 Reports Builder&#8221;<\/strong> and click <strong>&#8220;Create New Report&#8221;<\/strong> to create a new report.<\/p>\n\n\n\n<p>If prompted to authenticate your Google account to access the GA4 property, follow the instructions to complete the authentication process.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Report Configuration<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"272\" height=\"491\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fb95842875113d9a3d87cbe9a579421b.jpg\" alt=\"\" class=\"wp-image-15871\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fb95842875113d9a3d87cbe9a579421b.jpg 272w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/fb95842875113d9a3d87cbe9a579421b-166x300.jpg 166w\" sizes=\"(max-width: 272px) 100vw, 272px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-60\">A report configuration panel will appear on the right side of the spreadsheet.<\/p>\n\n\n\n<p><strong>Enter a Report Name<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-20\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"198\" height=\"54\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-66.png\" alt=\"\" class=\"wp-image-15873\"\/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Provide a name for the report to clearly indicate what it represents.<\/p>\n\n\n\n<p><strong>Select an Account<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-20\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"200\" height=\"74\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-67.png\" alt=\"\" class=\"wp-image-15874\"\/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">From the dropdown list, choose the Google Analytics account associated with the data you want to import.<\/p>\n\n\n\n<p><strong>Select a Property<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-20\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"192\" height=\"66\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-68.png\" alt=\"\" class=\"wp-image-15875\"\/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-40\">From the dropdown list, choose the property you want to use in the report.<\/p>\n\n\n\n<p><strong>Set Start and End Dates<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-20\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"195\" height=\"130\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-69.png\" alt=\"\" class=\"wp-image-15876\"\/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-20\">Specify the time period for the data you want to retrieve:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>today<\/li>\n\n\n\n<li>yesterday<\/li>\n\n\n\n<li>NdaysAgo<\/li>\n\n\n\n<li class=\"u-mb-ctrl u-mb-30\">specific date<\/li>\n<\/ul>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">If you choose <strong>&#8220;specific date,&#8221;<\/strong> you can select the date from a calendar.<\/p>\n\n\n\n<p><strong>Dimensions<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-20\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"240\" height=\"58\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-70.png\" alt=\"\" class=\"wp-image-15877\"\/><\/figure>\n<\/div>\n\n\n<p><strong>Dimensions<\/strong> are attributes or criteria used to organize or categorize data.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Select the dimensions for the data you want to retrieve (e.g., <strong>Date<\/strong>, <strong>Region<\/strong>, etc.).<\/p>\n\n\n\n<p><strong>Metrics<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-20\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"242\" height=\"62\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-71.png\" alt=\"\" class=\"wp-image-15878\" style=\"width:242px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<p><strong>Metrics<\/strong> represent quantitative data points or measurements.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Choose the metrics for the data you want to retrieve (e.g., <strong>Pageviews<\/strong>, <strong>Users<\/strong>, etc.).<\/p>\n\n\n\n<p><strong>Set Filters<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-20\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"220\" height=\"263\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-72.png\" alt=\"\" class=\"wp-image-15879\"\/><\/figure>\n<\/div>\n\n\n<p>Configure filters to extract specific data for your report.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">For example, you can add filters such as <strong>&#8220;Show traffic only from a specific region&#8221;<\/strong> or <strong>&#8220;Include only a specific page&#8221;<\/strong> to narrow down the data for your analysis.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Click &#8220;Create Report&#8221;<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"324\" height=\"309\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-73.png\" alt=\"\" class=\"wp-image-15880\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-73.png 324w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-73-300x286.png 300w\" sizes=\"(max-width: 324px) 100vw, 324px\" \/><\/figure>\n<\/div>\n\n\n<p>Once all the settings are configured, click the <strong>&#8220;Create Report&#8221;<\/strong> button to generate the report.<\/p>\n\n\n\n<p>A new sheet will be created, containing the report&#8217;s configuration details based on the specified metrics and dimensions.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong>Run the Report<\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"635\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-1-1024x635.png\" alt=\"\" class=\"wp-image-17185\" style=\"width:543px\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-1-1024x635.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-1-300x186.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-1-768x476.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-1.png 1276w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-50\">From the <strong>Extensions<\/strong> menu, select <strong>&#8220;GA4 Reports Builder&#8221;<\/strong> and click the <strong>&#8220;Run Reports&#8221;<\/strong> button to import GA4 data into the spreadsheet in the specified format.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-20\">For example, if you want to view pageviews for a specific period, configure the settings accordingly.<\/p>\n\n\n\n<div class=\"swell-block-capbox cap_box is-style-onborder_ttl u-mb-ctrl u-mb-50\"><div class=\"cap_box_ttl\"><span>Example Configuration<\/span><\/div><div class=\"cap_box_content\">\n<ul class=\"wp-block-list\">\n<li><strong>Report Name<\/strong>: Test<\/li>\n\n\n\n<li><strong>Account<\/strong>: GA4 Account<\/li>\n\n\n\n<li><strong>Property<\/strong>: GA4 Property<\/li>\n\n\n\n<li><strong>Start Date<\/strong>: Specific date (11\/03\/2024)<\/li>\n\n\n\n<li><strong>End Date<\/strong>: Today<\/li>\n\n\n\n<li><strong>Dimensions<\/strong>: Day<\/li>\n\n\n\n<li><strong>Metrics<\/strong>: Screen Page Views<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p><strong>Report Details<\/strong><\/p>\n\n\n<div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full\"><img decoding=\"async\" width=\"389\" height=\"424\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-74.png\" alt=\"\" class=\"wp-image-15882\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-74.png 389w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-74-275x300.png 275w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/figure>\n<\/div>\n\n\n<p>The report will display:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Total pageviews for the specified period<\/li>\n\n\n\n<li>Daily pageviews<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Automatic Data Updates<\/strong><\/h2>\n\n\n\n<p>The add-on also includes a feature for automatic data updates.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">By using <strong>&#8220;Schedule Reports,&#8221;<\/strong> you can set the frequency of updates (e.g., daily or weekly) to ensure your data is refreshed automatically.<\/p>\n\n\n\n<div class=\"swell-block-step\" data-num-style=\"circle\">\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\"><strong><strong>Open &#8220;Schedule Reports&#8221;<\/strong><\/strong><\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"635\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-2-1024x635.png\" alt=\"\" class=\"wp-image-17186\" style=\"width:543px\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-2-1024x635.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-2-300x186.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-2-768x476.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/5164d46128de70caaab89d966f68e1d5-2.png 1276w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>From the <strong>Extensions<\/strong> menu, select <strong>&#8220;GA4 Reports Builder&#8221;<\/strong> and click the <strong>&#8220;Schedule Reports&#8221;<\/strong> button.<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"swell-block-step__item\"><div class=\"swell-block-step__number u-bg-main\"><span class=\"__label\">STEP<\/span><\/div><div class=\"swell-block-step__title u-fz-l\">Set Update Frequency<\/div><div class=\"swell-block-step__body\"><div class=\"wp-block-image u-mb-ctrl u-mb-40\">\n<figure class=\"alignleft size-full is-resized\"><img decoding=\"async\" width=\"554\" height=\"669\" src=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-75.png\" alt=\"\" class=\"wp-image-15884\" style=\"width:380px;height:auto\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-75.png 554w, https:\/\/84office.jp\/wp-content\/uploads\/2024\/11\/image-75-248x300.png 248w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"u-mb-ctrl u-mb-20\">Choose the update frequency from the dropdown list:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>never<\/li>\n\n\n\n<li>every month<\/li>\n\n\n\n<li>every week<\/li>\n\n\n\n<li>every day<\/li>\n\n\n\n<li>every hour<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading u-mb-ctrl u-mb-40\">Conclusion<\/h2>\n\n\n\n<p>Using Google\u2019s official add-on, <strong>&#8220;GA4 Reports Builder for Google Analytics,&#8221;<\/strong> you can easily import GA4 data into Google Sheets.<\/p>\n\n\n\n<p>By setting a schedule, you can automate data updates, eliminating the need for manual execution each time.<\/p>\n\n\n\n<p>In addition to this add-on, you can also integrate Google Sheets with GA4 using tools like <strong>Google Apps Script (GAS)<\/strong> or <strong>Google Looker Studio<\/strong>.<\/p>\n\n\n\n<p class=\"u-mb-ctrl u-mb-40\">Integrating GA4 with Google Sheets simplifies data visualization and facilitates seamless sharing within your team.<\/p>\n\n\n<div class=\"p-postListWrap u-mb-ctrl u-mb-20\"><ul class=\"p-postList -type-card -pc-col3 -sp-col1\"><li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/shorten-url-generator-bulk\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/87f85c9d503086e91d753ad48aa7758d.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">How to Bulk Create Shortened URLs Using Google Sheets and Google Apps Script<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-10\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u670810\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-sheets-information-sharing-easy\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/8d7f06d5148ba7af39f6cf06f4d9a1b9-1024x538.png\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/8d7f06d5148ba7af39f6cf06f4d9a1b9-1024x538.png 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/8d7f06d5148ba7af39f6cf06f4d9a1b9-300x158.png 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/8d7f06d5148ba7af39f6cf06f4d9a1b9-768x403.png 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/01\/8d7f06d5148ba7af39f6cf06f4d9a1b9.png 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">Google Sheets Tips: Easily Share Information with the Cell Link Feature<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-01-07\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e741\u67087\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<li class=\"p-postList__item\">\n\t<a href=\"https:\/\/84office.jp\/en\/google-news-template\/\" class=\"p-postList__link\">\n\t\t<div class=\"p-postList__thumb c-postThumb\">\n\t<figure class=\"c-postThumb__figure\">\n\t\t<img decoding=\"async\" width=\"1024\" height=\"538\"  src=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/c2fc7fedc4f307708a0b5f65f7039b96-1024x538.jpg\" alt=\"\" class=\"c-postThumb__img u-obf-cover\" srcset=\"https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/c2fc7fedc4f307708a0b5f65f7039b96-1024x538.jpg 1024w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/c2fc7fedc4f307708a0b5f65f7039b96-300x158.jpg 300w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/c2fc7fedc4f307708a0b5f65f7039b96-768x403.jpg 768w, https:\/\/84office.jp\/wp-content\/uploads\/2025\/07\/c2fc7fedc4f307708a0b5f65f7039b96.jpg 1200w\" sizes=\"auto, (min-width: 960px) 400px, 100vw\" loading=\"lazy\" >\t<\/figure>\n\t\t\t<span class=\"c-postThumb__cat icon-folder\" data-cat-id=\"12\">Google Sheets<\/span>\n\t<\/div>\n\t\t\t\t\t<div class=\"p-postList__body\">\n\t\t\t\t<h2 class=\"p-postList__title\">Google News Fetch Template: Streamline Information Gathering with Google Apps Script and Google Sheets<\/h2>\t\t\t\t\t\t\t\t<div class=\"p-postList__meta\">\n\t\t\t\t\t<div class=\"p-postList__times c-postTimes u-thin\">\n\t<time class=\"c-postTimes__posted icon-posted\" datetime=\"2025-07-19\" aria-label=\"\u516c\u958b\u65e5\">2025\u5e747\u670819\u65e5<\/time><\/div>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t<\/a>\n<\/li>\n<\/ul><\/div>\n\n\n<p class=\"is-style-emboss_box has-swl-pale-02-background-color has-background\">Our company offers support for improving work efficiency through the use of Google Apps Script. <br>If you need assistance with Google Apps Script customization or error resolution, please feel free to contact us. <br>We are fully committed to supporting your business improvements.<br><br><a href=\"https:\/\/84office.jp\/contact\/\">Contact us here<br><\/a><\/p>\n\n\n\n<script src=\"https:\/\/codoc.jp\/js\/cms.js\" data-css=\"rainbow\" data-usercode=\"pQLZofrBiA\" charset=\"UTF-8\" defer><\/script>\n <div id=\"codoc-entry-9lNr9PuMXQ\" class=\"codoc-entries\" data-without-body=\"1\" data-support-button-text=\"Support with a Tip\" data-support-message=\"We will keep offering tools and information to boost work efficiency. Your support helps us provide even better content.\"><\/div>\n\n\n\n<p class=\"has-white-background-color has-background\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article is for those who want to simplify data integration between Google Analytics (GA4) and Google Shee [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17188,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","_locale":"en_US","_original_post":"https:\/\/84office.jp\/?p=15864","footnotes":""},"categories":[12],"tags":[],"class_list":["post-17179","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","en-US"],"_links":{"self":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17179","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/comments?post=17179"}],"version-history":[{"count":11,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17179\/revisions"}],"predecessor-version":[{"id":17199,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/posts\/17179\/revisions\/17199"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media\/17188"}],"wp:attachment":[{"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/media?parent=17179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/categories?post=17179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/84office.jp\/wp-json\/wp\/v2\/tags?post=17179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}