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.
Solved
Syncing Google Forms Data into Gainsight
+1Best answer by dan_ahrens
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.
+2Hi 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.
+5Is there a way to use the Events Framework in combination with Google Script/Trigger to this without using another tool?
+1+2Hi
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
+5Thank you
I was able to set up an Google App script to do this.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.