Import iMIS contacts from Google Sheets or Excel
Import contacts and contact changes via a spreadsheet. Complex data sets can be imported easily. A row containing contact information, addresses, multi-instance table data, committee involvement, or roles can be imported easily. Simply paste or enter new or updated data into your connected spreadsheet!
Create a spreadsheet trigger with a list of contacts to import.
Optional: A condition is set looking at the iMIS ID.
Use the values from the spreadsheet to add or update the contact record.