How Send mail to Different Users with different Sheet Url

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

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

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

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.


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.