Step 4: Send Merits to Your Team

How do I send multiple merits from the organization portal?

Need to send (or propose) merits in bulk? Upload a spreadsheet with your merit recipient data to save time.

Before you start

  1. Make sure that you've already created a merit template to send to your recipients.
  2. Have your bulk merit data organized into columns on a spreadsheet so it can be easily saved into a pre-formatted .csv file and uploaded to Merit.

Skip to: 

How it works

Step 1: Go to the Organization Portal and navigate to the Automate merits folder on the left. At the top or in the center of the page, click the Automate merits tab.

Screen Shot 2020-02-26 at 11.55.10 AM

Step 2: Create a connector by selecting where you store your recipients' information.

  • Click on Spreadsheet from my computer.

Screen Shot 2020-02-26 at 12.00.13 PM

Step 3: Name your connector to represent the merits that will be sent from this connector.

  • Type the name in the Connector name box.
  • Click Next, upload a file.

Screen Shot 2020-02-26 at 12.00.34 PM

Create a .csv file that includes all of the fields associated with that merit template, as well as fields that need to be filled out.

Screen Shot 2019-09-03 at 1.13.46 PM

Step 4: Fill in your .csv file with your member information. Do not delete the column headers or the .csv file may not import appropriately. 

Invalid date format

All date fields must be of the format YYYY-MM-DD. E.g. “2020-05-14” for May 14 2020. Formatting the date differently will cause a read error. 

Screen Shot 2019-07-31 at 4.23.54 PM

Step 5: Once you have completed your file, make sure that it's saved as a .csv file.

Screen Shot 2019-09-03 at 1.20.10 PM

Drag or click to upload your spreadsheet. 

Import view:

Screen Shot 2020-02-26 at 12.22.07 PM

Click Finish creating connector.

Screen Shot 2020-02-26 at 12.26.50 PM

Step 6: Select the Map a template in the connector you just created. 

Screen Shot 2020-04-24 at 10.48.26 AM

Step 7: Merit then directs you to Select a template and map your column headers with the fields found on the merit template. Once the .csv file is successfully mapped, click Create mapping. 

Screen Shot 2020-02-26 at 1.20.38 PM

Step 8: The page will return to the Automate merits screen and a window will pop up that asks you to send merits.  Click Send merits to complete the process or Cancel to go back. 

Screen Shot 2020-02-26 at 1.47.39 PM


Step 9: The connector will now show the file as Syncing.  The length of this process will depend on the size of your file.  

Screen Shot 2020-02-26 at 1.56.37 PM

Once this process is complete, the Syncing will change to Sync complete. 

Screen Shot 2020-02-26 at 1.58.11 PM

See any error messages after sync?

Learn about possible errors here:

Troubleshooting errors when sending merits in bulk

Step 10.  Any merit within your spreadsheet can also be edited or revoked.  Merit templates must have "Recipients can only have one merit from this merit template" selected in order for a sync to edit or revoke. 

Screen Shot 2020-04-24 at 11.33.42 AM

Edit - To edit multiple merits with your automation sync, change the values of the fields within your spreadsheet that you would like to edit and save. New fields cannot be introduced, and you cannot remove existing fields using this method. 

Screen Shot 2020-04-24 at 12.26.34 PM

Once the edit is complete, save your CSV file and sync or resync your merit connector.


Revoke - Revoke a merit by changing the value in a Revoke column of your CSV file. 

The value in the revoke column must be any of the following: 1, y, yes, true

Every other value (including blank) will not revoke the merit. 

Screen Shot 2020-04-24 at 12.48.54 PM

Once the revoke values are changed, save your CSV file and sync or resync your merit connector.