How do I set up a Google Sheets Destination in SQL-RD?

Using the Google Sheets you can export SSRS reports directly to Google Sheets.

Destinations - Google Sheets

  • In the Schedule Wizard, go to Destinations.

SSRS. Destination Wizard in any report schedule in SQL-RD

  • Click Add and select Google Sheets.

7-9-2019 10-13-33 AM

SSRS Reports: Google Sheet Destination in SQL-RD.

  • Google Sheets allows you to send the report via Google Sheets which can be accessed on any server with the user credentials.
  • Google Sheets Account: Select the account.
    • If there's no account added, click Add New Account.
For more information about adding a Google Sheets account, click here.

11-28-2018 11-50-13 AM

Output Format

The only output format available in Google Sheets destination is Google Sheets.

 SSRS Reports: Google Sheets Destination in SQL-RD.

For information on naming tab, click here.