How to programmatically retrieve all Zaps metadata (including owners) in Enterprise workspace for analytics?

We're building internal analytics for our Enterprise workspace and need to programmatically retrieve metadata for all Zaps across all users.

What we need:

• List of all active Zaps in our workspace
• Owner name and email for each Zap
• Zap status, connected apps, last modified date
• Ideally via API for automation (scheduled exports to our analytics platform)

What we've tried:

1. Manual JSON export ("Download private and shared Zaps" from Settings → Security and data)
   • Problem: Does NOT include owner information
   • Requires manual download - can't automate
2. Zapier API (/v1/zaps endpoint)
   • Problem: OAuth Client ID/Secret only available after publishing a public integration
   • Creating a public integration just for internal workspace management seems wrong
3. Private integration with custom action
   • Support suggested building an action that calls /v1/zaps
   • Problem: Unclear how to set up the authentication - the endpoint requires OAuth, and we can’t generate the client ID and secret within Zapier.

Has anyone successfully retrieved all workspace Zaps programmatically or any other Zapier metadata via the Zapier API? If so, how did you handle authentication and what approach did you use?

Thanks,
Razvan