Need help to setup connection to Microsoft drive from Ui Studio

Help Activities
,
1

Hello,
I am new to UI Path and I am creating a small productivity project . Below are the process steps . and I am having trouble setting up connection to Microsoft and google .

Step 1: Access the web page using an open browser activity
Step 2: Extract Structured data (table) from the webpage
Step 3: Set up a connection with ‘Microsoft One Drive and SharePoint’ and create an Excel workbook in the selected folder in Microsoft One Drive
OR
Step 3:Set up a connection with ‘Google Drive’ and create a Google workbook in the selected folder in Google One Drive

Step 4: Write extracted data to the Excel workbook
Step 5: Download the Excel workbook to be sent in the email
Step 6: Send email.

Do i need to create Microsoft 365 scope ? if yes what parameters I need to add or how will I go about it . as I am stuck in step 3 . I am using latest UI studio 2026.0.179 STS

2

Hi @sobin_paul

There are 2 ways you can connect to onedrive 1) using classic activities 2) using integration service connectors.

Please refer below videos on both .

3

Follow below steps for Microsoft OneDrive/SharePoint:

Install UiPath.MicrosoftOffice365.Activities.
Set Connection = Interactive Login.
Provide Tenant Name + Email.
Inside the scope, use Create File to make the Excel workbook.

To use Google Drive:

Install UiPath.GSuite/GoogleWorkspace package.
Use Google Workspace Scope.
Add Client ID + Client Secret from Google Cloud.

You can check this playlist, it’s been explained in a very simple lucid way.