# Export Google Analytics data to Sheets via Apps Script

DevFeed: [Export Google Analytics data to Sheets via Apps Script](<https://devfeed.tech/articles/export-google-analytics-data-to-sheets-via-apps-script-31144.md>)

Original publisher: [Read original article](<https://technicalwriting.dev/2025/04/sheets/index.html>)

Published: 2025-04-25T00:00:00Z

Content type: tutorial

Language: en

Sources: [technicalwriting.dev](<https://devfeed.tech/sources/technicalwriting-dev.md>)

Topics: [Google Analytics](<https://devfeed.tech/topics/google-analytics.md>), [Google Apps Script](<https://devfeed.tech/topics/google-apps-script.md>), [JavaScript](<https://devfeed.tech/topics/javascript.md>), [Authorization](<https://devfeed.tech/topics/authorization.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [apps](<https://devfeed.tech/tags/apps.md>), [automation](<https://devfeed.tech/tags/automation.md>), [google-analytics](<https://devfeed.tech/tags/google-analytics.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [javascript](<https://devfeed.tech/tags/javascript.md>), [oauth](<https://devfeed.tech/tags/oauth.md>), [script](<https://devfeed.tech/tags/script.md>), [tutorial](<https://devfeed.tech/tags/tutorial.md>)

## AI overview

This tutorial explains how to use Google Apps Script to export Google Analytics data to Google Sheets. The spreadsheet can update automatically each night, and a custom Sheets menu can trigger an on-demand update. It also describes an optional HTTPS exposure feature and the required setup, dependencies, permissions, and OAuth authorization.

## Source excerpt

A tutorial that shows you how to export Google Analytics data to Google Sheets.