{"id":8586,"date":"2025-03-18T15:46:25","date_gmt":"2025-03-18T15:46:25","guid":{"rendered":"https:\/\/www.process.st\/help\/?post_type=ht_kb&p=8586"},"modified":"2025-03-18T16:51:56","modified_gmt":"2025-03-18T16:51:56","slug":"data-management-data-set-automations","status":"publish","type":"ht_kb","link":"https:\/\/www.process.st\/help\/docs\/data-management-data-set-automations\/","title":{"rendered":"Optimize Data Management with Data Set Automations"},"content":{"rendered":"

Skip to the guide \u2192<\/a><\/h3>\n

The Challenges of Managing Data in Process Street<\/strong><\/h2>\n

Process Street’s Data Sets help centralize and reuse data across workflows. However, unlike dedicated databases, Data Sets have limitations that can slow teams down:<\/p>\n

    \n
  1. Manual updates are time-consuming:<\/strong> Keeping Data Sets current is tedious, especially for dynamic data like client lists, product catalogs, or team rosters.<\/li>\n
  2. Limited data validation:<\/strong> Data Sets don\u2019t include advanced validation features, making it easier for errors like duplicates or inconsistent data to slip through.<\/li>\n
  3. No advanced queries:<\/strong> Data Sets offer basic filtering but lack the robust query tools found in most databases, which are often essential for managing and analyzing complex data structures.<\/li>\n<\/ol>\n

    Most Businesses Already Store Their Data Elsewhere<\/strong><\/h3>\n

    Most critical business data already lives in CRMs, ERPs, or databases. Managing it separately in Process Street creates duplication and inconsistencies. Integrating these sources eliminates manual syncing, ensuring workflows stay accurate and up to date.<\/p>\n

    The Solution: Dynamic Updates<\/strong><\/h3>\n

    By connecting Process Street to an external data source and automating updates, you can:<\/p>\n

      \n
    1. Keep Data Up to Date: <\/strong>Dropdowns automatically reflect the latest information, so you don\u2019t have to update them manually.<\/li>\n
    2. Reduce Errors & Save Time: <\/strong>Dynamic dropdowns ensure accurate, pre-validated selections, making workflows more efficient.<\/li>\n
    3. Use Your Existing Tools More Effectively: <\/strong>Instead of manually copying data, integrate updates directly from your CRM or other systems.<\/li>\n<\/ol>\n

      Scale Without the Manual Effort<\/strong><\/h3>\n

      Managing large Data Sets manually becomes more challenging as your business grows. Automating updates keeps your workflows accurate while freeing your team to focus on more important tasks. With dynamic updates, dropdowns always reflect the latest data. No extra work is required.<\/p>\n

      By linking Process Street with external data sources, you combine easy-to-use workflows with powerful data management from your existing systems.<\/p>\n

      <\/p>\n

      How to Dynamically Update a Data Set<\/strong><\/h2>\n

      This guide is for users who don\u2019t use or have access to Zapier. I\u2019ll be using Power Automate to send HTTP requests to Process Street\u2019s API, but any tool that can send HTTP requests will work.<\/p>\n

      Efficient Data Set Syncing: A Smarter Approach<\/strong><\/h3>\n

      Below is my typical sync flow for creating, modifying, and deleting records in a Data Set. Every action first goes through the System of Record before updating the Data Set. While updating the Data Set directly from a Process Street Workflow Run might seem more efficient, this approach actually reduces the overall automation work required.
      \nInstead of creating multiple automations, I build a single automation that monitors the System of Record for any new or modified records. When a change is detected, the automation locates the corresponding Data Set record and updates it accordingly. This streamlined method simplifies the process and ensures the Data Set stays in sync with your source of truth.
      \n
      \n\"dynamically<\/p>\n

      Step 1: Set Up Your External Data Source & Data Set<\/strong><\/h2>\n

      Start by defining how you want your data to be structured and managed. Consistency matters\u2014without it, your external source and Process Street Data Set will fall out of sync.
      \nExcel and Google Sheets work, but structured databases or tables are better. They enforce formatting and prevent accidental changes.<\/p>\n

      When setting up your Data Set, don\u2019t sync everything. Only pull in what your workflow needs:<\/p>\n