Has anyone successfully integrated Netsuite with their Slack Org? I'm looking to post a message to our operations channels when a Netsuite project stage is updated.

You can use a saved search email notification sent to slack channel's email address

Genius, can't believe I didn't think of that

Okay, so this technically worked but the emails come in a "click to view" format and unfortunately don't have the ability to be shown in a way that is most effective.. any other tips or tricks michoel? ❤️

Hmm, there are a couple of options for email - slack on that link. I only personally tried the top one, and yup we do need to expand to see the email body, but that works for us. If none of those options work for you, you can see if any off the shelf automation tools like zapier or IFTT would work or go fully custom and built your own integration with the API

We love Zapier and have a ton of Zaps, but unfortunately there isn't a zap connector for Netsuite available yet.

Similar product to Zapier

The only commercial integrations are like Celigo, and the connector for Celigo is incredibly complex and I don't understand how to actually use it, otherwise we would because the first connector is free and that would be all we need to use.

I haven't used Celigo slack integration but it looks pretty doable based on that screenshot.

My goal is to send a message to our general operations channel every time a project gets updated, stating what the old project stage & substage was and what the new project stage & substage is after the update. For example, Project Stage Update Notification • Project: ProjectName • Old Stage: OldProjectStage • New Stage: CurrentProjectStage Click here to view this project.

Hmm I'm not familiar enough with Celigo to say if you can access record changes. It might be a good idea to post that as a separate thread

@Jared McKenzie Sorry for a late response, but here are some tips: 1. The slack channel in that mapping screen shot should be hardcoded to the channel id, which will look something like “CTK3RBK2F”. You can find the channel id for a channel by right-clicking on the channel name in the side nav, and “copy link”, which will give you the full URL… like https://netsuiteprofessionals.slack.com/archives/CBQ338ZE0 2. the text field will be a multi-select field. It will end up looking like:

Project: `{{{projectName}}}`
Old Stage: `{{{oldProjectStage}}}`
New Stage: `{{{currentProjectStage}}}`

@matt.graney we are fine with it only including the new value. would that make it easier?

much easier

You are the MF man Matt. I will go through this shortly and reply with a feedback / any issues. I hope to succeed. Thank you so much for providing value and helping. Talk soon 💪

Good luck!

I believe this would cause an update to be sent to slack anytime a project is updated, even if something other then the stage was changed. If that's an issue, you can create a custom field in NetSuite to store the "previous stage". You could then add a filter to your flow so it only runs of the updated stage differs from the previous stage. After your flow sends the slack message it would then update the previous stage custom field to the current stage. This would also make to possible to achieve your original goal of showing the previous and new stages in the slack message.