[ACTION] Integrate Pipedream Connect with our Lovable App

Description

We need to integrate Pipedream Connect with our Lovable App to allow users to securely connect and manage third-party services (e.g., Gmail) via managed OAuth.

Requirements:

Implement both Connect Token (popup/iframe) and Connect Link (redirect) authentication flows as per Pipedream Connect documentation.

Ensure backend securely generates Connect tokens and handles API calls using the correct Pipedream OAuth client credentials (Client ID, Client Secret, Project ID).

Store connection metadata in our database and handle connection status updates via webhooks.

Provide clear user feedback for successful and failed connections in the UI.

Follow security best practices for environment variable management and error handling.

References:

Pipedream Connect Overview

Managed Auth Quickstart

Example App (Next.js)

Acceptance Criteria:

Users can connect/disconnect their Gmail (and other supported) accounts through the Lovable App UI.

Connection status is accurately reflected and updated in the app.

All secrets and credentials are managed securely.

Errors are logged and surfaced for troubleshooting.