Google Drive

Installation

If Google Drive support is required the following steps must be performed to enable ReportWORQ to integrate with Google Drive.

ReportWORQ uses Service Accounts and Impersonation in order to publish documents in user's Google Drive Accounts.  This technique is documented here: https://developers.google.com/identity/protocols/oauth2/service-account

• Create a Google Project and enable the Google Drive API
  • Follow Steps: https://developers.google.com/workspace/guides/create-project
  • Choose Enable APIS and Services then add Google Drive
• Create an API Service Account
  • Follow Steps:  https://cloud.google.com/iam/docs/creating-managing-service-accounts
  • Edit the Service Account
  • On the Details Tab:
    • Enable the option to "Enable Google Workspace Domain-wide Delegation"
    • Record the Unique ID which will be used as the Client ID below
  • On the Keys Tab:
    • Choose Add Key > Create New Key
    • Choose the JSON Format
    • Save the downloaded file for use in the ReportWORQ Settings >> Distribution screen
• Grant Google Workspace Access to the Service Account
  • Follow Steps: https://developers.google.com/identity/protocols/oauth2/service-account#delegatingauthority
  • Navigate to Google Workspace Admin: https://admin.google.com/
  • Choose Security > API Controls > Manage Domain Wide Delegation
  • Create an entry with the Client ID from the service account
  • Add the following scopes:
    • https://www.googleapis.com/auth/drive
    • https://www.googleapis.com/auth/drive.file
• Configure ReportWORQ Settings
  • Navigate to Settings >> Distribution >> Google Drive
  • Enter the Application Name, which is the Project Name from the first step
  • Provide the Key file which was downloaded above
  • Test the connection and verify that a test file was created in the test user's Google Drive