Bridge and ServiceNow for new row

calebsgardner

I am clearly missing something…
Overall simple workflow

New row in Smartsheet is added —> create a record in ServiceNow. I can get it all to work just as I want it if I define the row. However, I don't know how to define a row that doesn't exist, yet. Any help with this would be greatly appreciated.

Brian_Richardson

Hi - trigger this workflow when a row is added, then you can get the row ID that was added from {{runtime.event.id}}

You can setup a trigger by exiting the workflow, click Integrations…Smartsheet…Triggers.

Unknown

This content has been removed.

yh374

Brian_Richardson

May 17, 2024

Hi - trigger this workflow when a row is added, then you can get the row ID that was added from {{runtime.event.id}}

You can setup a trigger by exiting the workflow, click Integrations…Smartsheet…Triggers.

Hi Brian, how would I do this in reverse? For new records in Servicenow table auto-added to Smartsheet intake sheet each time?

Brian_Richardson

Take a look at the integrations page for ServiceNow- I think you can set a trigger there in ServiceNow on a new record add.

If not, you can setup a read of ServiceNow with a specific query to give you new items. For example, you could schedule it to run hourly, read a list of records in Pending state, then post those records to Smartsheet and then update them in ServiceNow to Open. Or something like that, so that next time the sync runs it won’t pick the same items up again.

Lauren R

@Brian_Richardson

Hi Brian,

I am currently trying to integrate ServiceNow and Smartsheet for my company and I'm having some trouble. Would you be willing to help me out?

I am using a dev environment in ServiceNow for testing and I was giving admin permissions for testing purposes - I already have admin permissions for Smartsheet. I was able to get the authorization for both SNow and SSheet on Bridge and I thought I created the correct Trigger for SNow and SSheet. My workflow looks like this:

My goal is to get the Incidents from 4 assignment groups to go to a specific Incident sheet in SSheet. I am looking for Incident Number, State, Priority, and Opened Date all in 1 row on the sheet.

Im not sure what Im doing wrong but its not pulling any data from SNow. When I test run the workflow it comes back successful but clearly not since there is nothing on the sheet except for what I have put in the Smartsheet: Add Row Key/Value section for the cells.