How do I export insights to Google Sheets?
Hi Rachel V., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To export Insights reports from Mixpanel to Google Sheets, you can use the native Sheets ⇔ Mixpanel extension. Here’s how you can do it: 1. Install the Extension: Go to the Sheets ⇔ Mixpanel Google Workspace Marketplace page and install the extension.2. Open the Extension in Google Sheets: After installation, you’ll find the Sheets ⇔ Mixpanel option under “Extensions” in your Google Sheet.3. Select “Mixpanel → Sheet”: This mode allows you to export reports or cohort data from your Mixpanel project into your Google Sheet.4. Provide Required Parameters: - The easiest way is to paste the URL of the Insights report you want to export; the extension will try to parse the necessary parameters automatically. - If needed, manually provide: - A Service Account with appropriate permissions - The report URL (must be from mixpanel.com or eu.mixpanel.com) - Your project_id - Your workspace_id - The report_id (found in the report URL)5. Run or Sync the Export: - Use the “Run” button to export the report once. - Use the “Sync” button to schedule hourly exports (note: syncs are supported for Insights, Funnels, and Retention reports only).Note: Since v1.12, only Insights, Funnels, and Retention reports are supported for export to Google Sheets using this extension. Flows and other report types are not supported via this method. Learn more in the official documentation
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.