Keeping your data synchronized across systems ensures your workflows always run on accurate, up-to-date information.<\/p>\n
With Process Street\u2019s Data Sets<\/a> and CSV Import API<\/a>, you can seamlessly connect your external data source (like CRMs, ERPs, HR tools, or databases) to update your information inside Process Street automatically.<\/p>\n This means no more manual uploads, out-of-date records, or missing context. Your workflows can stay aligned with the latest customer data, employee details, project information, or compliance records from the tools you already use.<\/p>\n You can schedule these updates to happen automatically using a Code Task<\/a> and Scheduled Workflow Runs<\/a>.<\/p>\n This allows you to fetch new data, generate a CSV file, and import it into your Data Set on a regular cadence; daily, weekly, or as often as your business requires. The result is a fully automated refresh cycle that ensures the latest information always powers your workflows.<\/p>\n You can import records into an existing Data Set from a CSV file using one of three strategies:<\/p>\n Append:<\/strong> Adds new rows only and does not change or remove existing data.<\/p>\n<\/li>\n Upsert:<\/strong> Updates a row if the key matches, otherwise creates a new one (no deletions).<\/p>\n<\/li>\n Sync:<\/strong> Performs an upsert and removes rows that do not exist in the CSV file.<\/p>\n<\/li>\n<\/ul>\n For Upsert<\/strong> and Sync<\/strong>, a key column must be defined to determine whether a row matches.<\/p>\n Keep external data sources synchronized with Process Street<\/p>\n<\/li>\n Automate daily or scheduled data refreshes<\/p>\n<\/li>\n Maintain accurate, current information across dependent workflows<\/p>\n<\/li>\n Support reporting, dashboards, and compliance tracking with clean, up-to-date records<\/p>\n<\/li>\n<\/ul>\n If your data changes frequently and workflows need the most recent information, use Sync.<\/strong><\/p>\n This ensures the Data Set matches your external source exactly by updating existing rows, adding new ones, and removing outdated records.<\/p>\n It’s ideal for systems that refresh daily, such as real estate listings, inventory databases, or dynamic sales pipelines.<\/p>\n Combine this with a Scheduled Workflow Run<\/a> to automatically refresh your Data Set every day or week.<\/p>\n If you maintain ongoing records and never want to delete historical data, use Upsert.<\/strong><\/p>\n It updates matching rows while preserving everything else.<\/p>\n This is perfect for HR data, customer lists, or partner directories where you want to retain older entries but refresh key details.<\/p>\n Use a Code Task<\/a> to generate your CSV and a Scheduled Workflow Run<\/a> to trigger the import at regular intervals.<\/p>\n If you\u2019re periodically adding new information without modifying existing data, use Append.<\/strong><\/p>\n It\u2019s safest for systems that grow over time, such as audit logs, registrations, or lead captures.<\/p>\n Append imports can be triggered manually or scheduled<\/a> through a recurring workflow for consistent updates.<\/p>\n Example<\/strong><\/p>\n A real estate operations team uses Sync to refresh property data every morning.<\/p>\n A Scheduled Workflow Run automatically executes a Code Task that retrieves the latest listings, creates a CSV, and imports it to update the Data Set, ensuring every workflow references the most recent information.<\/p>\n Export your data as a Use the CSV Import API<\/a>\u00a0to upload your file and choose the correct import strategy (Append, Upsert, or Sync).<\/p>\n<\/li>\n Optionally, set up a Code Task<\/a> in your workflow to generate or fetch the CSV automatically from your source system.<\/p>\n<\/li>\n Use Scheduled Workflow Runs<\/a> to trigger the workflow regularly (e.g., every 24 hours) for continuous data synchronization.<\/p>\n<\/li>\n<\/ol>\n All column names must be unique and match between the CSV and Data Set (case-insensitive).<\/p>\n Maximum file size: 20 MB<\/p>\n<\/li>\n Available via the Public API<\/p>\n<\/li>\n Key column must be of type “Text” for Upsert and Sync<\/p>\n<\/li>\n If multiple rows share the same key, one matching row will be updated randomly<\/p>\n<\/li>\n All column names must be unique; name matching is not case-sensitive<\/p>\n<\/li>\n<\/ul>\n You can connect file uploads and CSV imports to automation tools such as Make.com, Zapier, or Power Automate, or run them natively through Scheduled Workflows and Code Tasks.<\/p>\n Example automation<\/strong><\/p>\n This approach keeps documents and data synchronized automatically, so there’s no manual maintenance required.<\/p>\n","protected":false},"excerpt":{"rendered":" Keeping your data synchronized across systems ensures your workflows always run on accurate, up-to-date information. With Process Street\u2019s Data Sets and CSV Import API, you can seamlessly connect your external data source (like CRMs, ERPs, HR tools, or databases) to update your information inside Process Street automatically. This means no more manual uploads, out-of-date records, […]<\/p>\n","protected":false},"author":11,"template":"","meta":{"_acf_changed":false,"available_plan":"","available_product":"","footnotes":""},"ht_kb_category":[194],"ht_kb_tag":[442,580],"class_list":["post-9439","ht_kb","type-ht_kb","status-publish","hentry","ht_kb_category-integrations","ht_kb_tag-api","ht_kb_tag-files"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb\/9439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/users\/11"}],"version-history":[{"count":7,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb\/9439\/revisions"}],"predecessor-version":[{"id":9450,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb\/9439\/revisions\/9450"}],"wp:attachment":[{"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/media?parent=9439"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb_category?post=9439"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.process.st\/help\/wp-json\/wp\/v2\/ht_kb_tag?post=9439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Importing CSVs into Data Sets<\/h2>\n
What it does<\/h3>\n
\n
Why it\u2019s useful<\/h2>\n
\n
Recommendations by Use Case<\/h2>\n
How it works<\/h2>\n
\n
.csv<\/code> file from your source system (Salesforce, SQL, or Google Sheets).<\/p>\n<\/li>\nLimitations<\/h2>\n
\n
Automating Data Uploads<\/h2>\n
\n