Sync your Amplitude data to Google Drive and Sheets

Feature Experiment Web Experiment

SDKs APIs

Find the right chart for your analysis Chart basics in Amplitude Build charts in Amplitude: Add events Build charts in Amplitude: Add user segments Build charts in Amplitude: Modify a user segment Microscope: Explore individual data points in your charts Event Explorer: View event streams in real time Review chart data with the breakdown table Customize your chart's colors Charts

Identify users with similar behaviors

Define a new cohort

Compare and manage your behavioral cohorts

Create cohorts with Microscope, file import, or the Segmentation module

Track changes in your cohort populations over time

Historical Count, part 1: Track user behavior for different instances of each user action

Historical Count, part 2: Order of operations

Historical Count, part 3: Funnels and behavioral cohorts

Customize the Home page Breadcrumbs: Track, organize, and share your analyses Search: Find charts, dashboards, cohorts, and notebooks Workspace: Find your charts and track your work Bulk manage charts with Chart Cleanup Releases: See how users respond to changes in your product

Create, edit, and manage dashboards

Filter your dashboards

Change your dashboard's display preferences

Turn your dashboard into a template

Subscribe to a dashboard

Collaborate on your analyses using spaces Notebooks: Explain important insights to teammates and stakeholders Templates: Re-use your analyses Out-of-the-box Web Analytics Out-of-the-box Product Analytics

Share dashboards within your company Share charts, dashboards, and notebooks with stakeholders outside your company Use Atlassian Smart Links with Amplitude Embed Amplitude charts in Notion documents Integrate Miro with Amplitude Integrate Slack with Amplitude Sync your Amplitude data to Google Drive and Sheets

Account-level reporting in Amplitude Plan your Accounts Instrumentation Set up account-level reporting

Anomaly + Forecast: Find anomalies in your data Insights: Spot anomalies in your metrics quickly with alerts Root Cause Analysis: Track down anomalies in your data Debug Analytics Use Domain Proxy to Relay Events Look up event data for individual users

Use sessions, channels, and attribution to drive marketing analytics

Ask Amplitude

Analytics

Sync your Amplitude data to Google Drive and Sheets

This article helps you:

Export chart data to Google Sheets and chart images to Google Slides

Sometimes you need to share refreshable chart data with team members, or sync chart images into presentations. Amplitude's Sync to Drive and Sheets extension (downloadable from Google Workspace Marketplace) lets you easily export your chart data to Google Sheets and your chart images to Google Slides.

Sync your Amplitude data to Google Sheets

After you download the extension, follow these steps to sync your chart data with Google Sheets:

From within a Google spreadsheet, navigate to Extensions > Amplitude Sync to Drive and Sheets. Then click Start Exporting Amplitude Data.
In the modal that appears, click Sign in with Google.

Note

Use the same email to sign into Google Sheets that you use to log in to your Amplitude account. If the emails don't match, you won’t be able to export data from your organization.

Next, allow Amplitude access to your Google account.
Choose your organization. Hover over the desired chart's name and click Add to export its data. You can select multiple charts for the same export.
A tab in your Google spreadsheet populates with the selected chart's data; this tab is titled Amplitude [DO NOT EDIT].
As desired, use Manage to refresh or delete selected charts from the sheet. Click the refresh icon to refresh and the delete icon to delete.

Note

Export to Sheets uses Amplitude's Dashboard REST API to generate results, so ensure your charts abide by the same limits.

Sync your Amplitude data to Google Slides

After you download the extension, follow these steps to sync your chart images with Google Slides:

From within a Google Slides presentation, navigate to Extensions > Amplitude Sync to Drive and Sheets. Then click *Start Exporting Amplitude Data.
As with steps 2 and 3 in the previous section, Amplitude prompts you to sign into Google in the modal that appears. You should then allow Amplitude access to your Google account when prompted.
Next, choose your organization. Hover over the desired chart's name and click Add to export its data. You can select multiple charts for the same export.

At this point, your presentation populates with chart images, one per slide, depending on how many charts you chose for export.

Note

Charts with a lot of data might take longer to export.

As desired, use Manage to refresh or delete selected charts from the sheet. Click the refresh icon to refresh and the delete icon to delete.

Was this page helpful?

Thanks for your feedback!

June 6th, 2024

Need help? Contact Support

Visit Amplitude.com

Have a look at the Amplitude Blog

Learn more at Amplitude Academy