Do we have a good workaround or direct connector like G- Connector?

Forum|Forum|7 years ago
August 1, 2019
9 replies
764 views

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

data management

sai_ram

Expert ⭐️⭐️

@shiv_kumar_katiyar What kind of data would you kind to move? What is the exact use-case you want to achive?

N

nkogelman

Contributor ⭐️⭐️

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.

sai_ram

Expert ⭐️⭐️

@sumesh any thoughts??

L

LoLock

Contributor ⭐️⭐️

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

jean.nairon

Expert ⭐️

@shiv_kumar_katiyar, if you’re using the SFDC version and the data resides in a SFDC object, I would recommend using a SFDC connect to G-Suite like mentioned above. This is likely the easiest solution for data that resides in SFDC.

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