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!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-ImportExport.png
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!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-ImportExport.png
Imports/Exports
Import contact updates using spreadsheets and link spreadsheet contents with iMIS in real-time!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-SurveyMonkey.png
SurveyMonkey
Easily record poll, survey, and voting results from SurveyMonkey in iMIS fields or activities!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-GoToWebinar.png
GoToWebinar
Automate GoToWebinar creation and registration using iMIS Events!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-SurveyMonkey.png
SurveyMonkey Integration
Easily record poll, survey, and voting results from SurveyMonkey in iMIS fields or activities!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-Zoom.png
Zoom Integration
Automate Zoom meetings and registration using iMIS Events!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-Square.png
Square Integration
Record monetary transactions outside of iMIS using Square!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-HubSpot.png
HubSpot Integration
Account details synced between HubSpot and iMIS. Plus see how easy HubSpot form data passes into iMIS!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-HubSpot.png
HubSpot
Account details synced between HubSpot and iMIS. Plus see how easy HubSpot form data passes into iMIS!
https://www.iappconnector.com/images/1-Armstrong/iAppConnector/Integrations/Bubble-GoToWebinar.png
GoToWebinar Integration
Automate GoToWebinar creation and registration using iMIS Events!