Import data from Google to Servicenow

Fredo1 · ‎05-04-2017

Hi

I wonder if anybody can provide me with sites, documentation, WIKI, examples to import data from Google (docs, sheets) to ServiceNow.

Many thanks in advance

Chuck Tomasi · ‎05-04-2017

HI Alfredo,

While I haven't done this specific task, I believe Google's REST API can do what you want.

Google Drive REST API Overview | Drive REST API | Google Developers

Take a look at these videos:

ServiceNow Live Coding Happy Hour for 2016-09-23 - Outbound OAuth Part 1 - YouTube

ServiceNow Live Coding Happy Hour for 2016-09-30 - Outbound OAuth Part 2 - YouTube

View solution in original post

Fredo1 · ‎03-13-2018

How did you do that?

diannemcintosh · ‎03-14-2018

Using a service account with domain access, I created credentials in Google and enabled API's needed. I created an entry in application registry, then a rest message. I'm receiving data back and using that data to populate tables in Servicenow.

Fredo1 · ‎03-14-2018

It would be great if you can create some kind of HOWTO Doc/web page for the community.

Many thanks in advance

diannemcintosh · ‎03-14-2018

I'll try to get something together this weekend and get it posted. I couldn't find any help on the community so I understand.

diannemcintosh · ‎03-14-2018

This link is a good start

https://docs.servicenow.com/bundle/istanbul-application-development/page/integrate/outbound-rest/task/t_OAuthDemoCreateProvider.html