How Send mail to Different Users with different Sheet Url

Help Studio
, , , , , , , ,
1

How to share Spreadsheet file from Shared Drive Folder with different Users ?

Example
XYZ Shared Drive Folder
Contains
HR Folder—>1.xlsx
Marketing Folder—>2.xlsx
Finance Folder—>3.xlsx

So
1.xlsx needs to be shared with HR Team
2.xlsx with Marketing team
3.xlsx with Finance Team

2

Hey @anmita

It all depends on the design and logic.

You can create a mapping sheet for bot reference and help it achieve the same.

Thanks
#nK

3

Create a datatable with Department, excel path, email address as columns and fill in the details. Then go through the rows using For each row activity and pass on these column values to the send email activity.