Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
ServiceNow and Smartsheet BRIDGE integration
Hi,
I am trying to bring all records from a table in ServiceNow into my Smartsheet. All field names align and I am able to get the record from ServiceNow but unable to send that data into an existing Smartsheet.
I did get it to add one row from ServiceNow but that's only if I reference the row specifically in the Key and Value fields. I want to be able to reference all the records in ServiceNow and add them into Smartsheet as a one-time pull and then have it automatically bring in new rows as new records are made in ServiceNow table. Could anyone assist?
Current workflow:
Key#1: Name
Value#1: {{states.startstate.servicenow.get_records.data.Name}}
Answers
-
Hi @yh374,
I believe you’ll need to create child workflows for each row you want to add. However, if you have a large number of rows, you’ll need to use JavaScript to streamline your workflow - I’d recommend taking a look at this comment for @Brian_Richardson's explanation of updating multiple rows at once, since it’ll likely be similar for adding multiple rows at once: Bridge | How to Find Rows With Status & Delete Them.
For more information about creating child workflows, take a look here: Use child workflows to manage complex processes.
I’d also recommend reviewing the following related threads:
Hope that points you in the right direction!
Georgie
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for the callout @Georgie
Here’s some more examples using JavaScript and child workflows to push multiple row updates at once:https://community.smartsheet.com/discussion/97621/use-javascript-in-bridge-to-efficiently-import-data-from-an-api#latest
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending Posts
- So every Global Update i have pushed, no matter how simple or complicated of a push, it has resulted in only partially completing. I would then need to go on to run this same update maybe 4 or 5 times…
- I’ve heard EU instance of Smartsheet requires a license of every user regardless of being the content creator or editor. I am also told that the US will be moving to that financial arrangement in 2026…
- When I attempt to open my favorites it will not list them. The arrow will point down but it will not list them.
