Business Intelligence

Looker Studio

13min
with looker studio modules in {{product name}} , you can manage the assets and data in your looker studio account to use the looker studio modules, you must have a google account, and a looker studio project created in your google cloud platform https //console cloud google com/welcome?pli=1\&project=storied scarab 310722 you can create an account at accounts google com https //accounts google com/signup/v2/createaccount?hl=en\&flowname=glifwebsignin\&flowentry=signup\&theme=glif you need to add {{product name}} as an authorized data source in looker studio refer to the looker studio api documentation https //developers google com/looker studio/integrate/api/reference for a list of available endpoints {{product name}} 's use and transfer of information received from google apis to any other app will adhere to google api services user data policy https //developers google com/terms/api services user data policy connect looker studio to {{product name}} to establish the connection, you must looker studio docid\ xtza jjg20mx9tokhtvuy looker studio docid\ xtza jjg20mx9tokhtvuy looker studio docid\ xtza jjg20mx9tokhtvuy create and configure a google cloud platform project for looker studio before you establish the connection in {{product name}} , you must create and configure a project in the google cloud platform to obtain your client credentials create a google cloud platform project for looker studio to create a google cloud platform project log in to the google cloud platform https //console cloud google com/ using your google credentials on the welcome page, click create or select a project > new project enter a project name and select the location for your project click create in the top menu, check if your new project is selected in the select a project dropdown if not, select the project you just created to create a new project or work in the existing one, you need to have the serviceusage services enable permission if you don’t have this permission, ask the google cloud platform project owner or project iam admin to grant it to you enable apis for looker studio to enable the required apis open the left navigation menu and go to apis & services > library search for the following api looker studio api click looker studio api , then click enable configure your oauth consent screen for looker studio to configure your oauth consent screen in the left sidebar, click google auth platform under audience , select external for more information regarding user types, refer to google's exceptions to verification requirements documentation https //support google com/cloud/answer/9110914#exceptions ver reqts under contact information , enter your gmail address under finish , agree to the google user data policy click continue > create in the branding section, under authorized domains , add make com and integromat com click save optional in the audience section, add your gmail address on the test users page, then click save and continue if you want the project to remain in the testing publishing status in the data access section, click add or remove scopes , add the following scopes, and click update click save publishing status testing if you keep your project in the testing status, you will be required to reauthorize your connection in {{product name}} every week to avoid weekly reauthorization, update the project status to in production in production if you update your project to the in production status, you will not be required to reauthorize the connection weekly to update your project's status, go to the google auth platform , the audience section, and click publish app if you see the notice needs verification , you can choose whether to go through the google verification process https //support google com/cloud/answer/13463073?authuser=1\&visit id=638718595933013017 1855034908\&rd=1 for the app or to connect to your unverified app currently connecting to unverified apps works in {{product name}} , but we cannot guarantee the google will allow connections to unverified apps for an indefinite period for more information regarding the publishing status, refer to the publishing status section of google's setting up your oauth consent screen help https //support google com/cloud/answer/10311615#zippy= create your looker studio client credentials to create your client credentials in google auth platform, click clients click + create client in the application type dropdown, select web application update the name of your oauth client this will help you identify it in the platform in the authorized redirect uris section, click + add uri and enter the following redirect uri https //www integromat com/oauth/cb/google custom click create click the oauth 2 0 client you created, copy your client id and client secret values, and store them in a safe place you will use these values in the client id and client secret fields in {{product name}} configure your api clients in google workspace admin portal to configure your api clients you must have a google workspace admin account to configure your api clients log in to your google workspace admin account at admin google com https //admin google com/ in the left sidebar, click security > access and data control > api controls in the domain wide delegation section, click manage domain wide delegation click add new in the client id field, enter the copied client id above in the oauth scopes field, enter the following scopes https //www googleapis com/auth/userinfo email https //www googleapis com/auth/userinfo profile https //www googleapis com/auth/datastudio click authorize now you are ready to establish the connection with {{product name}} establish the connection with looker studio in {{product name}} to establish the connection in {{product name}} log in to your {{product name}} account, add a looker studio module to your {{scenario singular lowercase}} , and click create a connection optional in the connection name field, enter a name for the connection in the client id and client secret fields, enter the values you copied in the looker studio docid\ xtza jjg20mx9tokhtvuy above click sign in with google if prompted, authenticate your account and confirm access you have successfully established the connection you can now edit your {{scenario singular lowercase}} and add more looker studio modules if your connection requires reauthorization at any point, follow the connection renewal steps here docid\ so88fm6pkt0g adkddfzz set up looker studio webhooks this app uses webhooks docid 1yhunj8jvzyxip9cf3ps1 to trigger a {{scenario singular lowercase}} when an event occurs instantly all webhook modules have an instant tag next to their name to set up a webhook, follow these steps add a looker studio instant module to your {{scenario singular lowercase}} and click create a webhook optional enter a name for the webhook in the webhook name field select the corresponding connection for the webhook in the connection field click save > copy address to clipboard log in to your looker studio account click create > data source under partner connectors , select make in the webhook url , insert the webhook url you copied above click connect looker studio will now send data to {{product name}} through the webhook when the selected event occurs build looker studio {{scenario plural}} after connecting the app, you can perform the following actions assets search assets list asset permissions add asset members revoke asset permissions data source new request new response other make an api call