Mixpanel Segmentation Data Export for report automation into Google Spreadsheets using Google Apps Script
Retrieves data from Mixpanel via the Data Export API Segmentation end point.
To use this:
-
Create a Google Spreadsheets document in Google Drive. In the document menu, select "Tools" then "Script Editor".
-
In Google Apps Script, select create script for "Blank Project".
-
Copy and paste the contents of mixpanel-segmentation.gs (found in this repository) into the blank project named Code.gs
-
Follow the five configuration steps found in the mixpanel-segmentation.gs script comments. They ask you to fill in your Mixpanel account information, set up script options, and to define the queries against the Mixpanel Segmentation endpoint.
-
Set up awesome automated Mixpanel event reports into spreadsheets. Never cut and paste again!