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

https://community.smartsheet.com/discussion/comment/436715#Comment_436715

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.