n8n Workflow: Migrate SmartSuite Comments to Monday Items

Migrate SmartSuite comment history into Monday.com—automatically

This n8n workflow manually migrates SmartSuite record comment history into a Monday.com board by fetching each record’s comments, formatting them into a plain-text archive, locating the matching Monday item, and writing the archive into a long-text column.

What this workflow does

• Runs on demand: start it manually in n8n when you’re ready to migrate.
• Fetches SmartSuite records in pages: it pulls records from a specified SmartSuite table using configurable paging values (batch limit and offset) to control load.
• Collects comments per record: for each SmartSuite record, it requests up to 100 comments and skips records that have no comments.
• Builds a dated plain-text archive: it flattens SmartSuite comments into an ordered text log, preserving @mentions and enforcing both per-comment and total length limits.
• Matches the correct Monday item: it queries Monday.com to find the board item by checking where the SmartSuite record ID appears in a designated text column.
• Updates the long-text field: it writes the formatted comment archive into the target Monday.com long-text column and waits briefly between items to respect API rate limits.

Use cases

• Consolidate historical context when moving from SmartSuite to Monday.com.
• Preserve conversation trails during data migrations so teams don’t lose past decisions.
• Bulk backfill comment archives for specific tables before starting ongoing collaboration in Monday.

Technical details

• Integrations: SmartSuite API + Monday.com API
• Nodes / building blocks used: if, set, code, wait, split out, sticky note
• Setup: configure SmartSuite API key, Account-Id (workspace), and table ID; add Monday.com API key and board ID; set the Monday column IDs for (1) the SmartSuite record ID text column and (2) the long-text column that receives the archive.