DarraghB1992/README.md

## README.md

      
    Raw
  

              README.md
            
          
    Prerequisites

Python 2.7.x
A basic knowledge of how to move through folders using the terminal/command prompt
Step 1

Head to https://app.intercom.io/ember/saved_replies.json?app_id=YOUR_APP_ID to get the json containing all of your apps saved replies
Step 2

Create a new folder, lets call it saved_reply_converter on your computer somewhere that you can easily navigate to using the terminal.
Copy and paste all of your saved replies into file a new file in this folder, lets call it saved_replies.json.
Step 3

Lets create a new python file now to run our script. Let's call it convert_saved_replies.py
Inside convert_saved_replies.py paste the following code snippet. This snippet assumes you used the names outlined in the previous steps.
import json
import csv

saved_replies = 'saved_replies.json'

with open(saved_replies) as json_data:
    d = json.load(json_data)

starting_point = d['saved_replies']

f=csv.writer(open('saved_replies.csv','wb+'))


for x in starting_point: 
	f.writerow([x['name'].encode('utf-8'), x['html'].encode('utf-8')])


print "Complete"

Step 4

Once you have added the code to convert_saved_replies.py and saved the file head over to you terminal and cd into the saved_reply_converter folder that contains both of our files.
Once in that folder running python convert_saved_replies.py should create a new csv file named saved_replies.csv.
Step 5

You should now have a CSV file containing all of your saved replies! Upload it to Google sheets or import to Excel from here.
This content of the saved replies will contain some HTML but its a great start!