-
Visit Kloudio's Account Page.
-
Enable Office Access to Google Sheet by clicking on the "Enaable Offline Access" button. Log in with Google Account having access to the desired Google sheet(s).
- Now you should see the "Enabled" button in the Accounts page as seen below. Now click on the "Generate Key" button in the Accounts Page.
- The Kloudio API key will now be generated and will show up as follows.
-
Enable Kloudio Action in your looker Administration page for actions (/admin/actions).
-
Once the Kloudio Action has been enabled, use this API key and URL of the desired Google Sheet to push data from Looker to Google Sheet.