How to enable the Google Sheets Action in Looker?

  • Looker FAQs
  • January 20, 2018
Get Started Transforming Your Data in Snowflake

From Looker 7.4 version onwards, Looker’s secure OAuth-based Google Drive action can be used to send dashboards and looks from Looker to Google Drive. A Looker admin would have to enable the Google Drive action within the Looker Action Hub to make this work. Once the Google Drive action is enabled, the users select Google Drive as a destination while creating schedules or sending looks/dashboards.

Steps for Looker admins to enable the Google Sheets action :

  1. Click on the Actions link under the Platform header within the Admins panel.
  2. Within the Action Hub actions, navigate to Google Sheets and tap on the Enable button.
  3. Now on the Google Sheets action page, click on the Enabled button and then click Save .
  4. The Google Sheets action should now be enabled within the list of Action Hub actions.

If there is any Looker user with send_to_integrations permissions, they would easily send or schedule Looks / Explores in CSV format using the Google Sheet.

 


Up Next:

Read How to plot Latitude and Longitude from Google Sheets into Looker?