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 Row
Triggers when a new row is added or modified in a spreadsheet.
- automatically do this!Add Contact From Third Party Source
Adds 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 ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?