Skip to main content
cmultanen
cmultanen
Helper ⭐️
November 1, 2018
Solved

Syncing Google Forms Data into Gainsight

  • November 1, 2018
  • 5 replies
  • 263 views
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.

Best 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.

5 replies

dan_ahrens
dan_ahrensAnswer
Expert ⭐️⭐️⭐️
November 2, 2018
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.

VP of Customer Success at Forcepoint
benwanlessmenlo
benwanlessmenlo
Contributor ⭐️⭐️⭐️⭐️⭐️
June 2, 2021

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

    sai_ram
    sai_ram
    Expert ⭐️⭐️
    June 4, 2021

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

      rakesh
      Gainsight Employee ⭐️
      rakesh
      Lets put your data to work!
      June 17, 2021

      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

        benwanlessmenlo
        benwanlessmenlo
        Contributor ⭐️⭐️⭐️⭐️⭐️
        June 17, 2021

        Thank you @rakesh !

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

          Terms & ConditionsAccessibility statement