Hi There,
Is there a way to move data from Gainsight into either a Google Sheet or Excel? I'm imagining something like what G-Connector does in Google Sheets where it automatically updates Google Sheets based off of a report in SFDC
Question
Do we have a good workaround or direct connector like G- Connector?
+2
+1@shiv_kumar_katiyar What kind of data would you kind to move? What is the exact use-case you want to achive?
Hi @sai_ram_pulluri,
@shiv_kumar_katiyar submitted this based on my chat into GS support. We currently are doing some KPI reporting, based off of metrics we maintain in GS, in a spreadsheet. The long-term plan is to eventually move this into a data visualization tool but for a couple quarters of development, testing, etc the spreadsheet option is faster to iterate/customize/etc. Having a data connector that would automatically refresh this data daily, rather than having to do manual exports, would save our team time, help with predicatability and reduce the element of human error. I hope this helps to explain the use case, if you have additional questions please just let me know.
@shiv_kumar_katiyar submitted this based on my chat into GS support. We currently are doing some KPI reporting, based off of metrics we maintain in GS, in a spreadsheet. The long-term plan is to eventually move this into a data visualization tool but for a couple quarters of development, testing, etc the spreadsheet option is faster to iterate/customize/etc. Having a data connector that would automatically refresh this data daily, rather than having to do manual exports, would save our team time, help with predicatability and reduce the element of human error. I hope this helps to explain the use case, if you have additional questions please just let me know.
Bubbling this thread back into existence, as I also have questions around this? Particularly in regards to the CSM level (not an admin).
I’m hoping to be able to export sentiment updates, and KPI updates to a google sheet that I can create rules to auto populate certain cells to help me better manage my clients.
Are there any resources to auto export specified data to a designated google sheet when I can then customize?
I found this thread on G-Connector for Salesforce, and wondering if something like this could be replicated for Gainsight/Timeline data, as well as other data.
https://gsuite.google.com/marketplace/app/gconnector_for_salesforce/971770431958
+4
But if your data resides in the MDA or you’re using Nxt, you can export it to S3. Once in S3, there are some connector options like the following:
https://zapier.com/apps/amazon-s3/integrations/google-sheets
https://www.workato.com/recipes/801216-record-s3-files-to-google-sheets
I’m not aware of any options that allow you to go directly from MDA to Google sheets. You can export a report to CSV and save it to google sheets but that would likely require human intervention.
Jean
+1Hi Team,
Is there any progress on the direct connector? I think that would be a great addition.
+1Hi
Forgot to post an update on this thread.
However, I was able to create a working integration via GSheets and Rule Manager. I’ve been using the same from last 4 months.
Happy to help in case you are still looking for an integration.
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.