Import notes, companies, and features to Slack
Workflow Description
Scheduled automation that extracts notes, companies, and features from Snowflake database and delivers them to Slack channels in batches at regular intervals, ensuring your team stays informed with synchronized data from your core systems.
How it works
- 1.Execute the scheduled trigger at specified intervals
- 2.Retrieve notes, companies, and features data from Snowflake
- 3.Divide extracted data into manageable batches for processing
- 4.Send each batch to corresponding Slack channels
Use cases
- Distribute company updates and new features to sales teams automatically
- Share critical notes and alerts instantly across Slack channels
- Keep data warehouse information synchronized with team communication tools
Requirements
- Active Snowflake database connection with valid credentials
- Slack workspace with configured channels ready to receive data
- Configured schedule for periodic automation execution
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (35)
Sticky Note1
Sticky Note
Manual mapping feature
Set
get productboard companies
HTTP Request
Manual mapping companies
Set
get productboard notes
HTTP Request
Manual mapping notes
Set
Split features
Split Out
Split companies
Split Out
Split notes
Split Out
Split features in notes
Split Out
Combine Feature ID + Note ID
Set
get productboard features
HTTP Request
Update Productboard Notes
Snowflake
Empty Table Productboard Notes
Snowflake
[CREATE] PRODUCTBOARD_NOTES
Snowflake
[CREATE] PRODUCTBOARD_COMPANIES
Snowflake
Update Productboard Companies
Snowflake
Manual mapping companies db
Set
Manual mapping notes db
Set
Empty Table Productboard Companies
Snowflake
[CREATE] PRODUCTBOARD_NOTES_FEATURES
Snowflake
Manual mapping feature note IDs db
Set
Update Productboard Note and Feature IDs
Snowflake
Empty Table Productboard Note and Feature IDs
Snowflake
Loop Over Items notes
Split In Batches
Loop Over Items features notes
Split In Batches
[CREATE] PRODUCTBOARD_FEATURES
Snowflake
Empty Table Productboard Features
Snowflake
Loop Over Items features
Split In Batches
Manual mapping features db
Set
Update Productboard Features
Snowflake
Schedule Trigger
Schedule Trigger
Slack
Slack
Count Notes Last 7 days and Unprocessed
Snowflake
Sticky Note2
Sticky Note