Download mail google sheet

Help Studio
,
1

can anyone tell me, there is google sheet file & in that file there is multiple sheet. I want to download specific google sheet and mail that google sheet to given mail ID. how I can do it.

2

@yogitagaikwad2206

Follow this simple workflow steps:

-install UiPath.GSuite.Activities , UiPath.Mail.Activities

-Set Up Google API Access

  1. Create a new project and enable the Google Sheets API for that project.
  2. Create credentials (OAuth client ID) for your project to access the Google Sheets API.
  3. Download the credentials JSON file and securely store it.

-Use Google Sheets Activities

  1. Use the “Google Sheets Scope” activity to authenticate and access Google Sheets. Provide the path to the credentials JSON file and set up the required permissions.
  2. Inside the scope, use the “Read Range” activity to read data from the Google Sheet.

-Use the “Write Range” activity to write the data to a local Excel file.

-Use Email Activities

  1. Use the “Send SMTP Mail Message” activity from the “UiPath.Mail.Activities” package to send an email.
  2. Configure the email properties such as the recipient email address, subject, and body.
  3. Attach the local Excel file to the email using the “Attach Files” property.
3

Hi @yogitagaikwad2206 ,

Please follow the below steps to achieve.

  1. Install UiPath.GSuite.Activities
  2. Use the Download File activity to download the file from Google Drive.
  3. Use Send Email activity and specify the downloaded Excel file path in the Attachment(s) property to attach the file

You can explore Google Workspace activities: Activities - About the Google Workspace activities package (uipath.com)