Salesforce Batch & Bulk Update Records Skeleton Template
This is a 'Workflow' template which means that it is a single standalone workflow.
Some workflow templates can be modified to work with other workflow templates - e.g. to convert a data sync between two services from uni-directional to bi-directional
This template offers two options to make large scale data update to records in Salesforce using either the "Batch Update" API for synchronous updates to up to 200 records at a time or the "Bulk Update" API to make asynchronous updates to as many records as needed.
There are videos below that explain how to setup the template.
Batch Update Records
Since you can only update 200 records at a time, this option is good for making quick updates to hundreds up to a few thousand records. It operates synchronously, meaning each API call to Salesforce completes when all records are updated. This means you get instant feedback as to whether or not your updates worked, but it runs a bit slower and is therefore not as good for making very large scale updates.
Video: Configuring a batch Salesforce update
Bulk Update Records
This method is slightly more complex in setup, but better suited for many thousands of records as you can programmatically upload a large CSV to Salesforce, which is then processed on the backend. The template stores the job ID for you, so you can check the status of it after creating the job to see the results.