Automatically Sync Google Sheets Data with Mixpanel Lookup Table

Hi Md S., 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> 👋

To sync Google Sheets data with Mixpanel into a lookup table automatically, you can use the Sheets ⇔ Mixpanel extension. Here's how you can set it up: 1. Install the Sheets ⇔ Mixpanel extension from the Google Workspace Marketplace.2. In your Google Sheet, you'll see a new "Sheets ⇔ Mixpanel" dropdown under the "Extensions" menu.3. Select "Sheet → Mixpanel" from the dropdown to import data from your sheet to Mixpanel.4. Choose "Lookup Table" as the type of data you're importing.5. Use the visual mapper to connect your sheet's column headers to the required fields for the lookup table.6. Provide your Mixpanel project details (project_id, project_token, project_region, and project_secret or Service Account).7. Set up a sync to run the configuration automatically. This will update your lookup table in Mixpanel on an hourly basis.It's important to note that syncs run on an hourly schedule, but you can also trigger them manually by choosing "Sync Now!" from the main menu.For more detailed instructions, you can refer to the Google Sheets integration documentation.Remember that lookup tables in Mixpanel have certain limitations, so make sure your use case is appropriate for a lookup table before setting up the sync.Lookup Tables documentation

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.