Google Analytics Spreadsheet Add-on - Google Analytics — Google Developers
The add-on combines the Google Analytics API with the power of data manipulation in Google Spreadsheets. Here is what you can do with it:
1. Query data from multiple views (profiles).
2. Create custom calculations from your report data.
3. Create dashboards with embedded data visualizations.
4. Easily control who can see your data and visualizations by leveraging.
5. Google Spreadsheet's existing sharing and privacy features.