Skip to main content
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.



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.




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


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


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


Thank you @rakesh !

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


Reply