Sync your Amplitude data to Google Drive and Sheets

  • Updated

This article will help 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. Download Amplitude's Sync to Drive and Sheets extension from Google Workspace Marketplace to easily export your chart data to Google Sheets and your chart images to Google Slides. 

NOTE: The Amplitude Sync to Drive and Sheets extension is currently unavailable for EU-based organizations.

Sync your Amplitude data to Google Sheets

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

  1. From within a Google spreadsheet, navigate to Extensions > Amplitude Sync to Drive and Sheets. Then click Start Exporting Amplitude Data. 

  1. In the modal that appears, click Sign in with Google.

NOTE: Make sure to access your Google Sheets instance with the same email that you use to log in to your Amplitude account. If your emails do not match, you won’t be able to export data from your organization.

  1. Next, allow Amplitude access to your Google account when prompted. 

  1. 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.

  1. A tab in your Google spreadsheet will then be populated with the selected chart's data, and will be titled Amplitude [DO NOT EDIT].
  2. As desired, use Manage to refresh or delete selected charts from the sheet. Click the refresh icon refresh.png to refresh and the delete icon trash.png to delete.

Sync your Amplitude data to Google Slides

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

  1. From within a Google Slides presentation, navigate to Extensions > Amplitude Sync to Drive and Sheets. Then click Start Exporting Amplitude Data.

  1. As with steps 2 and 3 in the previous section, you'll be prompted to sign into Google in the modal that appears. You should then allow Amplitude access to your Google account when prompted. 
  2. 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.

Your presentation will then be populated 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.

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