How to do integration of google sheets with ServiceNow using flow designer

[shareef_223]

Hello all,

I am currently working on integrating Google Sheets with ServiceNow. My objective is to retrieve data from Google Sheets and subsequently create records in ServiceNow. To accomplish this, I am utilizing Flow Designer and have installed a spoke for it.

Before incorporating spokes in Flow Designer, I am seeking guidance on any initial processes that need to be addressed. If there are specific steps or considerations I should be aware of, please provide instructions.

Your assistance in navigating through this integration process is greatly appreciated.

Thanks,
SHAREEF

[Dr Atul G- LNG]

Hi @shareef_223 

I never done this, but may be some point

 - consider this as a normal excel sheet , like we use for import set

- Use SN excel template.

- Create data source and fix the columns and sheet to read.

- Bring this in Staging table. 

This is my thoughts.

[shareef_223]

Hello @Dr Atul G- LNG,

Thank you for your response. I wanted to share that I've resolved the issue. I successfully integrated Google Sheets using Flow Designer. Before utilizing any Flow Designer spokes, it's essential to follow these steps:

Google Cloud Console Side:

1. Create a business account on [Google Cloud Console](https://console.developers.google.com/).
2. Establish a domain and an associated email address, e.g., www.mydomain.com and jane-admin@mydomain.com.
3. Create a project.
4. Enable the API for the project.
5. Generate OAuth app credentials.
6. Add the connection URI (https://instance.service-now.com/oauth_redirect.do) and save it.
7. Copy the Client ID and Client Secret.

ServiceNow Side:

1. Open Flow Designer and navigate to connections, searching for Google Sheets.
2. Click on "View Details" and create a new connection with credentials.
3. Generate the OAuth token.
4. Once the token is generated, you can use Google Sheet spokes in Flow Designer.

I followed these steps, and I'm pleased to report that I have successfully completed the integration with Google Sheets.

Thanks,
SHAREEF

[JLeong]

Hi Shareef,

We need Integration Hub for this, correct?

Thanks.

[shareef_223]

Yes, correct