Solved

Syncing Google Forms Data into Gainsight

  • 1 November 2018
  • 5 replies
  • 196 views

Userlevel 4
Badge +1
Hi there,



Does anyone have any recommendations on how to automatically bring Google Forms survey data into Gainsight. When a seller closes a new logo deal, they currently fill out a Google Form with important handoff/deal information. We want to start pulling and capturing this information in GS to make this information more accesible and actionable for our CSMs.



I know I can create a custom object and bulk update via CSV but is there a more automated way of doing this? Alternatively, has anyone built out a similar survey using Gainsight's own survey tools?



Curious to hear what others have done in this area.


icon

Best answer by dan_ahrens 2 November 2018, 21:41

View original

5 replies

Userlevel 7
Badge +2
Hi Calvin, It looks like Zapier has OOTB integrations between Google Forms and Amazon S3 (https://zapier.com/apps/amazon-s3/integrations/google-forms) and once you get the data into an S3 CSV file, it's easy to schedule a rule to grab that data and use it in Gainsight.


Userlevel 4
Badge +3

Is there a way to use the Events Framework in combination with Google Script/Trigger to this without using another tool?

Userlevel 7
Badge +1

@benwanlessmenlo checking with the team, I will get back to you on this.

Userlevel 6
Badge +1

Hi @benwanlessmenlo 

 

It should be possible via Google App script and events framework. I did not test it but saw this great post on stack overflow - https://stackoverflow.com/questions/50397157/how-to-use-an-external-api-in-google-apps-script-that-requires-an-api-key . This code matches our events framework code snippet here - https://support.gainsight.com/SFDC_Edition/Administration_and_Permissions/General_Administration/Events_Framework_Overview

Userlevel 4
Badge +3

Thank you @rakesh !

I was able to set up an Google App script to do this.

Reply