Import Productboard notes, companies and features into Snowflake
Ready for 3.0What this workflow does
This workflow has 33 nodes and runs on a schedule (every week at 08:00). Along the way it connects Snowflake and Slack. It also calls api.productboard.com over HTTP.
How it runs
Trigger: On a schedule (every week at 08:00).
- Empty Table Productboard Features (Snowflake): run a query
- get productboard features (HTTP Request): calls api.productboard.com
- Split features (Split Out): splits a list into separate items
- Manual mapping feature (Edit Fields (Set)): sets or maps fields
- Loop Over Items features (Loop Over Items (Split in Batches)): loops over the items in batches
- Empty Table Productboard Companies (Snowflake): run a query
- Manual mapping features db (Edit Fields (Set)): sets or maps fields
- get productboard companies (HTTP Request): calls api.productboard.com
- Update Productboard Features (Snowflake): uses Snowflake
- Split companies (Split Out): splits a list into separate items
…plus 22 more steps. See the full node list below.
Services it uses
HTTP calls to: api.productboard.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Snowflake
n8n-nodes-base.snowflake - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Slack
n8n-nodes-base.slack
From the author
This workflow imports Productboard data into Snowflake, automating data extraction, mapping, and updates for features, companies, and notes. It supports scheduled weekly updates, data cleansing, and Slack notifications summarizing the latest insights.…