Google Drive Connections
Follow this guide to configure a Google Drive connection in an Alteryx Analytics Cloud workspace:
Create OAuth 2.0 Client App
Before the connection configuration, make sure to have the client app ready.
Go to Google Console.
Select Create Project.
Enter a Project name and other information.
Select ENABLE APIS AND SERVICES from the APIs & Services dashboard.
Search for Google Drive API and select it.
Select ENABLE.
Search for Google Sheets API and select it.
Select ENABLE.
Navigate to Credentials and select CREATE CREDENTIALS, then select OAuth client ID.
Select CONFIGURE CONSENT SCREEN.
Select External and select CREATE.
Enter App name, User support email, and Developer contact information.
Select SAVE AND CONTINUE.
When you finish the setup, select PUBLISH APP and then CONFIRM.
Navigate to Credentials and select CREATE CREDENTIALS, then select OAuth client ID.
In Application type, select Web application.
In Authorized redirect URIs, select ADD URI and enter the URI of your Alteryx Cloud tenant:
Select CREATE.
The console displays the Client ID and the Client Secret.
Create Google App in AAC
To connect to Google Drive, your admin has to create a Google app in AAC.
Select your profile picture and go to Workspace Admin.
In the Connectivity category, select OAuth Clients and then select Create.
Enter an appropriate name.
Select the google technology.
Enter your Client ID and Client Secret from the Create OAuth 2.0 Client App section.
Enter these values:
Authorization URL:
https://accounts.google.com/o/oauth2/v2/authToken URL:
https://oauth2.googleapis.com/tokenScopes:
https://www.googleapis.com/auth/drive
Enter the Access Token Expiry and Refresh Token Expiry time limits of your choice.
Create Google Drive Connection
Go to the Connections Page for more information.
To create the connection, navigate to the Connections page.
Select Create Connection and search for Google Drive. You can also find it under the File-API tab under the search window.
Select the Google Drive card.
Once the connection configuration form opens up
name the connection appropriately,
select the appropriate OAuth client from the dropdown for OAuth Client,
select Authenticate.
You are led through a regular OAuth 2.0 flow of authenticating against your Google Drive cloud tenant app.
Once the authentication is successful, save your connection and start using it in workflows.
Filtering Capability Under the Output Tool in AAC
Follow these steps to setup the configuration for Google Drive in a workflow:
Drop an Output Tool onto the canvas.
Select the Google Drive cloud connection and let it load the browsing experience for finding Google Drive files.
Select the destination for the dataset at the preferred drive.
Locate the correct folder as applicable and select it.
Find the appropriate file under the folder,
optionally, enter a new File Name,
select Next.
Select either Create New or Overwrite.
Note
If you select the Create New option, every time you run the job, AAC will create a new file with a unique name. If you want to overwrite the data instead, you need to change the connection after you create the file. Select the newly created file and then select the Overwrite option.
Select the Column Delimiter. The options are comma (default), tab, semicolon, or pipe.
Optionally, clear the check boxes to include quotes and to include column names as first row. Both are selected by default.
Select Confirm.
Known Limitations
Google Drive connection is write-only.
Only CSV files are supported as the output format.
Output tool does not show an error if the user edited a tested connection with incorrect values. The test connection passes, but the Output tool doesn't show any files linked with the user.