How to Use Contact List to Share a Sheet

Aly_Olson_Turek

Hello,

I have a sheet with a contact list populated. I want to be able to share the sheet with the people in the contact list.

When I copy the values of the contact list, and paste into the Share window, the contacts do not translate appropriately. Is this expected?

Leroy Noriega

I would create a group for the contacts you would like to share to. I will then share the sheet to the group.

Aly_Olson_Turek

@Leroy Noriega this is a stakeholder sheet which will change with every project my team is assigned to, so I'm not sure if making a group each time is the most time efficient method. The project managers put the project stakeholders in a copy of this sheet when starting a project, so ideally we could just copy/paste to then share with the stakeholders in the sheet. Additionally the project managers are not all Group Admins right now

Leroy Noriega

I just figured out that you can copy emails in bulk and paste them into 'Invite people and groups'.