Python 2.7.x
A basic knowledge of how to move through folders using the terminal/command prompt
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
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
.
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"
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
.
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!
Hello,
Thank you for this script. I have done everything you wrote but I am not able to create CSV file. Do you have any idea what is the problem?
Thank you again.
Regards