From time to time, you might find you need to add a secondary email address or phone number to a list of Zendesk user profiles via the bulk upload option. In order to do this, you need to add a second row to each user record like you can see in the spreadsheet example below.
If you're creating the spreadsheet from new, then adding in the second line as you go will be easy; but what if you already have the users in your bulk upload spreadsheet ready to go, and simply need to add a second line to each record.....
You can use a really easy script with Google Sheets that will add the second row to each record for you.
Steps:
- Open the Google Sheets where you would like to add in the second row i.e your bulk user upload template
- Go to Script editor by navigating to the Tools > Script editor
- Give your script a name and delete the existing text within the script editor.
- Now paste the below script into the editor window
- Save your script and click on the Run button
- A Review Permissions window will appear - Make sure you are logged in with the correct google account
- Click on the Allow button to allow permissions for the script on your spreadsheet
- The script will now run for you. If it doesn't, click the Run button.
function addRows()
{ var startRow = 1;
var sheet = SpreadsheetApp.getActiveSheet();
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();
for (var i=numRows; i > -1; i--) {
sheet.insertRowsAfter(i + startRow, 1);
}
}
Here's some examples of what this looks like:
Before:
After:
successCX.com can help you achieve your Customer Service objectives, driving better customer experiences and repeat business. successCX.com is an official Master Zendesk Implementation and Solutions partner.