Integrate and create an automatic 2-way sync between Google Sheets and iMIS

This solution will demonstrate how to use Zapier for iMIS to create an automatic 2-way sync between a Google Sheets spreadsheet and your iMIS system.  The possibilities for using this solution are limited only by your imagination!

With this solution you can:

  • Automatically update member contact information collected through an online contact info update form

  • Automatically insert survey responses into members' iMIS records

  • Automatically add information from iMIS records into Google Sheets spreadsheets based on members' email addresses or other criteria

  • ...and so much more!

Check out the video below to see this solution in action!  


Solution Summary


Trigger: Row added in Google Sheets spreadsheet


Action: Data from Google Sheets inserted into iMIS records

  • Events such as submission of an online survey or Google Form
  • Uses email address to identify specific records
  • Data from Google Sheets spreadsheet inserted anywhere in iMIS
  • Verifies records via email address
  • Add data to custom panels, member profiles, and more!
Import contact updates using spreadsheets and link spreadsheet contents with iMIS in real-time!
Easily record poll, survey, and voting results from SurveyMonkey in iMIS fields or activities!
Automate GoToWebinar creation and registration using iMIS Events!
Account details synced between HubSpot and iMIS. Plus see how easy HubSpot form data passes into iMIS!
Triggered iMIS Data Updates
Replace your SQL Triggers and Stored Procedures; Automate data maintenance! Synchronize roles, company and committee affiliation, Multi-instance tables and activities!
Google Sheets Solution
Create automatic 2-way sync between Google Sheets and iMIS
Record monetary transactions outside of iMIS using Square!
Automate Zoom meetings and registration using iMIS Events!