In the Toolbar, hover your cursor over the plus + icon, then Data, and then select Connect Google Sheet. To start, we need to connect a database to Preset. Step 5: Set up Database Connection in Preset Connect the Database Now let's turn our attention to setting up the database and dataset on Preset. Next, navigate to the Google Drive API and select Enable. Navigate to the Google Sheets API screen on the Google Cloud Platform Console and then select Enable. Good news, we're nearly all done with our configurations on the Google side! The last step is to enable APIs for Google Sheets and Google Drive.įirst, ensure that you are logged into the correct Google account. On the Client ID field, paste the Unique ID from your Service Account:Īdd below OAuth scopes in order to grant access to these Google services: Open a new tab on the browser and access this link to manage Domain-wide Delegation on your Google tenant. In this step, we will delegate domain-wide authority (i.e., auto-authorize the service account to access user data on the Google Workspace domain) and setup Open Authorization (OAuth) in terms of the scope of access to Google services. Only a Google Super Administrator account is able to follow these steps. Be sure to save this file.Īlright! So we've created a project, a service account, and now have a JSON key! In the next step we'll assign domain-wide authority to the service account. The key, in JSON file format, will download to your local system. Ensure that this is indeed the case and then select Create. By default, the JSON key type is selected. In the Add Key drop-down menu, select Create new key. The Service Account details screen appears with the Keys tab selected. In the table, under the Actions column header, select the vertical ellipsis icon and then choose Manage keys. This will be used later on when we configure the database connection in Preset. Our next step is to create a private key in JSON that will be downloaded to your local system. The last step-granting access to users-is not required, so feel free to complete the process by selecting Done.Ī table displaying your new Google Service Account-which we've called Preset Connections-appears. If Viewer is selected, then please note that you will be unable to perform a CSV file upload. Viewer: View access to all service account resources. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |