How do I add a secondary email address or phone number to a Zendesk User Profile?

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: 

1. Open the Google Sheets where you would like to add in the second row i.e your bulk user upload template
2. Go to Script editor by navigating to the Tools > Script editor
3. Give your script a name and delete the existing text within the script editor.
4. Now paste the below script into the editor window
5. Save your script and click on the Run button
6. A Review Permissions window will appear - Make sure you are logged in with the correct google account
7. Click on the Allow button to allow permissions for the script on your spreadsheet
8. 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:

Book in a time with us today to find out how to improve your customer engagement and customer experiences