Add Common Room members from Google Sheets
If you keep a list of members in a Google Sheet and want to keep these members meshed with your community, use this template to automatically add or update Common Room members as you add or modify rows in your Google Sheet.
If you keep a list of members in a Google Sheet and want to keep these members meshed with your community, use this template to automatically add or update Common Room members as you add or modify rows in your Google Sheet.
- When this happens...New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet. 
- automatically do this!Add Contact From Third Party SourceAdds a contact to your room. 
- Free forever for core features
- 14 day trial for premium features & apps
- Dont Change Sheet Structure 
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
 Try It
- Drive 
 Try It
- Dont Change Sheet Structure 
- No Team Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Trigger column 
 Try It
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Column NameRequired 
- Index 
 
- Dont Change Sheet Structure 
- No Team Drive 
- SpreadsheetRequired 
- WorksheetRequired 
 Try It
- Dont Change Sheet Structure 
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Trigger column 
 Try It
- Drive 
- SpreadsheetRequired 
 Try It
- Drive 
- SpreadsheetRequired 
- WorksheetRequired 
- Use Timezone set up on the spreadsheet to format date values? 
 













