Google Drive
Description
Google Drive is a cloud-based file storage and synchronization service developed by Google. It allows users to store files in the cloud, share files, and edit documents, spreadsheets, and presentations collaboratively.
Setup guide
Follow this setup guide to connect Google Drive to Improvado.
Google Drive supports two authentication methods: Connect with Google and Service Account.
Click the Connections in the left navigation bar.
Categories on the Data sources page group all available platforms. Use a search to find the required one.
Click on the Google Drive tile.
Use this method to share the files you choose from your personal or organizational Google Drive.
Authorize Improvado with your Google account: Before authorizing, make sure you are signed in to the Google
account that can open the files you want to extract data from.
Select the Connect with Google connection
method and click Sign in with Google. You will be redirected to Google to
sign in.
Review the requested permissions and click
Allow. Improvado asks for your name, email address and access to the
Google Drive files you choose. You will be redirected back to Improvado automatically.
On the connection page, the Google file picker opens. Select the
files you want to extract data from and click Select. To add files later,
click Add files in the Google Drive files section of
the connection page.
Connect with Google
Use this method when you need automated, server-level access without user interaction. Suitable
for shared drives and organizational access.
To authorize your account, you need to provide the following
credentials:
Go to the
Google Cloud Console.
Navigate to IAM & Admin >
Service Accounts.
Click Create Service Account, enter a
name and description, and click Create and Continue.
Under Keys, click
Add Key > Create new key > select
JSON > click Create. A JSON file will be
downloaded.
Open the downloaded JSON file and copy the
client_email and private_key values.
Enable the
Google Drive API
in your Google Cloud project.
Share the Drive folders or files you want to extract with the
service account email address.
Enter the copied values into the Improvado authorization form.
Service Account
After the connection is completed, the Google Drive connection will appear in your Connected sources list.
When the connection status is Active, and the account status column shows a number of accounts, you can move on to data extraction. With Connect with Google, each file you chose is listed as a separate account; with a service account, the account is the service account itself.
To extract data from the connected sources, check the instructions on how to set up data extraction.
Schema information
The schema information shows all report types you can use to extract data from Google Drive.
Release notes
You can find information about the latest API changes in the official Google Drive API documentation.
Was this article helpful?
Thanks for the feedback!
Questions? The Improvado team is always happy to help. Send us an email, contact your Customer Success Manager, or raise a request in the Improvado Service Desk.