How do I add Google Sheets Accounts in CRD?

This is how you would associate your Google Sheets with CRD. Associating your Google Sheets account gives CRD access to reports you wish to schedule. CRD will use stored credentials to access and export reports.

Integrations - Google Sheets

  • Go to View.
  • Select Integrations.
Crystal Reports: CRD Home Screen.

Crystal Reports: Integrations Library in CRD.
  • Select Google Sheets.
Crystal Reports: Google Sheets in Library Integration in CRD.
  • Click Add to add an account.
Crystal Reports. Adding a Google Sheets Account in CRD.
  • Account Name: Enter the account credentials.
  • Token Data: After adding account name, click Connect to acquire the Token Data from Google.
This will open a web browser.
Crystal Reports. Adding a Google Sheets Account in CRD.
  • Select the account.
Crystal Reports. Adding a Google Sheets Account in CRD.
  • Click Allow to continue in CRD.
Crystal Reports. Adding a Google Sheets Account in CRD.
  • Close this window.
You will return to CRD with the token data credentials.
Crystal Reports. Adding a Google Sheets Account in CRD.
  • Click Save & Close.
  • The Google Sheets account is now added to CRD.