{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["User Standing Data","Instructions","Setup","Send","Groups Data","ADMIN - SECUIRTY DETAILS","User Manual"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":4,"defined_names":37,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User Standing Data","index":0,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Primary email","Identifier","Entity user xref uuid","First name","Last name","Job title","Status","Enum profile id","Active","Created at","Is staff","Is bot"]
["admin+demo1@qwil.io",null,"003606a9-3e64-45ed-a472-c95333f17737","Qwil","Admin","System Administrator",-1,1,false,"2019-10-23T15:48:56.210220Z",true,false]
["nima@qwil.io","Nima","00360ae4-9342-4bdd-a71a-d8db98424124","Nima","Akbari","Intern",1,1,true,"2019-11-28T12:05:07.358911Z",true,false]
["nima+sam.brown@qwil.io","brownsam","00360982-4230-44c5-8d7c-bfc15b13dea1","Sam","Brown","Compliance Officer",1,20,true,"2019-11-28T13:01:26.839321Z",true,false]
["nima+james.harrow@qwil.io","harrowja","00360939-c4a1-47e6-a2d5-0ba049f3253c","James","Harrow","FX Specialist",1,20,true,"2019-11-28T13:01:26.848836Z",true,false]
["nima+laurent@qwil.io","guyotlau","003605f6-0d06-4d93-9e0e-06ee0117f0d5","Laurent","Guyot","Portfolio Manager",1,20,true,"2019-11-28T13:01:26.850772Z",true,false]
["nima+ophelia.chambers@qwil.io","chamberso","003608b9-e950-4140-80ce-c612663b61ed","Ophelia","Chambers","Relationship Executive",1,20,true,"2019-11-28T13:01:26.850821Z",true,false]
["nima+peter.chan@qwil.io","chanpete","00360b58-e919-46b3-a0c5-cb3e915e84a8","Peter","Chan","Relationship Manager",1,20,true,"2019-11-28T13:01:26.899015Z",true,false]
["nima+sarah.smith@qwil.io","CRM9878778","00360f9e-1668-4d6a-b28f-288b9c66b4be","Sarah","Smith","Client",2,100,true,"2019-11-28T13:12:07.842084Z",false,false]
["nima+sarah.pound@qwil.io","CRM0090981","0036038e-cbcc-4b0d-b4f1-d20e53d02307","Sarah","Pound","Client",-2,100,false,"2019-11-28T13:12:07.843401Z",false,false]
["nima+raj.patel@qwil.io","CRM0090989","003600a6-a09b-4a9c-b7bf-d1cd3de5c632","Raj","Patel","Client",1,101,true,"2019-11-28T13:12:07.846997Z",false,false]
["nima+robert.pound@qwil.io","CRM0920092","00360a85-d09d-4af4-89bf-383fee953400","Robert","Pound","Client",-2,100,false,"2019-11-28T13:12:07.863858Z",false,false]
["nima+tony.smith@qwil.io","CRM0989899","00360e8e-07a3-46ff-ae42-f327165497f0","Tony","Smith","Client",1,100,true,"2019-11-28T13:12:07.868519Z",false,false]
["nima+mina.patel@qwil.io","CRM0898787","00360835-2bad-4041-a590-084e6b33094a","Mina","Patel","Client",2,100,true,"2019-11-28T13:12:07.873321Z",false,false]
["lindseyalpaugh@gmail.com","lindsey","0036044a-8572-4f1f-bec9-ab1cf862bc11","Lindsey ","Alpaugh","non-executive big dawg",-2,100,false,"2019-11-28T17:31:09.088942Z",false,false]
["yazgul_c@hotmail.com","Nezahat","00360dcc-4e21-4a83-a6e3-d812280a0919","Nezahat ","Cihan","Client",-2,100,false,"2020-02-19T18:45:54.768786Z",false,false]
["test@test.test","test","00360ac9-ca2c-4851-939e-da27370f4900","test","test","testing",0,100,false,"2020-03-17T12:37:38.372352Z",false,false]

{"sheet":"Instructions","index":1,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":true,"merged":[[31,2,31,3],[22,2,22,3],[25,2,25,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[26,2,26,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[15,2,15,3],[16,2,16,3]]}
[]
[null,null,"Qwil Messenger"]
[null,null,"Chat Butler Automated Messaging Tool Usage Instructions"]
[]
[]
[]
[]
[null,null,"Step 1 - Populate the messages you want to send"]
[]
[null,null,"·       Select between “Text” and “File” dropdowns in the “Message Type” field for every message you would like to send. You can enter up to 10 messages at one time."]
[null,null,"·       Enter your message in the “Message Content” field. If your message is a file, please enter the full file path. On windows, hold shift and right click on a file then click \"copy as file path\"."]
[null,null,"·       Tip: You can send a message in the format <First Name> or <Last Name> and the Butler will inserts individual names."]
[]
[]
[null,null,"Step 2 - Compile the recipient list"]
[null,null,"In the Send To field, select one of the following options from the drop down list:"]
[null,null,"·       “Send to All” – populates the Send sheet with all active users."]
[null,null,"·       “Send to Staff” – populates the Send sheet with all active staff users."]
[null,null,"·       “Send to Clients” –  populates the Send sheet with all active client users."]
[null,null,"·       “Send to Group” –  populates the Send sheet with individuals in the selected groups."]
[null,null,"·       “Custom List” –populates the Send sheet with all active users, which you can then edit by deleting rows that are not required. "]
[null,null,"After choosing your recipients, click the \"generate list\" button to take you to the \"Send\" tab"]
[null,null,"Note: When choosing “Custom List”, ensure you delete the row, not just clear the cells. There must be no blank spaces between recipients."]
[]
[null,null,"Step 3 - Send your messages"]
[null,null,"·        You will be directed to the “Send” when you select your recipient list option. "]
[null,null,"·    Confirm the list is correct. You can delete any recipient rows that you do not want to receive the message BEFORE pressing the SEND button. However, please do not leave any spaces between rows."]
[null,null,"·       Once you are ready, press the Send button. The workbook sends each of the messages in order, every 2 seconds. Depending on the number of recipients you have, this may take some time to complete."]
[null,null,"·       Delivered messages will show as a green “Delivered” cell, if a message cannot be delivered, the process will stop and prompt you to retry or cancel. "]
[null,null,"·       If you encounter issues, wait a few seconds and click retry to resume sending. If the message still hasn’t delivered, click cancel and check your internet connection, the recipient details and  file paths."]
[null,null,"·       Messages may also not send due to revoked system and user API keys. Check whether you are using the most recent version of the tool with your administrator."]
[null,null,"·       Once all your messages have been sent, a message will appear confirming the total number of messages sent."]

{"sheet":"Setup","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[[4,1,4,7],[17,1,17,7],[18,1,18,2]]}
[]
[null,null,"Qwil Messenger"]
[null,null,"Chat Butler Automated Messaging Tool"]
[]
[null,"STEP 1: Write your messages"]
[null,"Message #","Message Type","Message Content"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[null,"STEP 2: Compile a list of recipients"]
[null,"Recipients"]
[null,"Send To:","Send To Group"]

{"sheet":"Send","index":3,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":true,"merged":[[4,1,4,4],[4,5,4,14]]}
[]
[null,null,"Qwil Messenger"]
[null,null,"Chat Butler Automated Messaging Tool v.1.1.2"]
[null,"STEP 3: Click Send"]
[null,"Recipients",null,null,null,"Messages"]
[null,"First Name","Last Name","Primary email","UUID",1,2,3,4,5,6,7,8,9,10]

{"sheet":"Groups Data","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Group uuid","Group name","Group member count"]
["00360516-e233-420f-ac4d-e34bc161d6ad","Smith Relationship",6]
["003606e9-6e3d-4697-93fd-eeccf107fc77","London Relationship Management Team",5]
["0036085b-370b-4796-bba5-293549a3fc29","Patel Relationship",5]

{"sheet":"ADMIN - SECUIRTY DETAILS","index":5,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":false,"merged":[[18,1,18,2],[6,1,6,2],[8,1,8,2],[10,1,10,2],[16,1,16,2],[11,1,11,2],[13,1,13,2],[14,1,14,2]]}
[]
[null,null,"Qwil Messenger"]
[null,null,"Chat Butler Automated Messaging Tool v1.1.2"]
[]
[]
[]
[null,"Organisation Name",null,"test"]
[]
[null,"Organisation Region",null,"mercutio"]
[]
[null,"Master User API Key ID",null,"NNIMfivJtutFXML7I8ZBemVGs"]
[null,"Master User API Key Secret",null,"HPuuFdsXaZDd8sP5LKMK3RjNaYdjWypNAGmKP2BJRky98NIoG5xp5pciRElT28Rs9u7AK2l9"]
[]
[null,"System API Key ID",null,"ELkHrhXFraQUAUUWZmHUZ5lyR"]
[null,"System API Key Secret",null,"DagL7lBhjeJ4rPxB6er7L4Yd46Pmv66OFODyDkie5yn6H2JwonPiJj5ravmCWYuV4PqAO2tv"]
[]
[null,"Workbook User Password",null,"test"]
[]
[null,"Admin UUID",null,"00360ae4-9342-4bdd-a71a-d8db98424124"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Send To All"]
[null,null,"Send To Staff"]
[null,null,"Send To Clients"]
[null,null,"Send To Group"]
[null,null,"Custom List"]

{"sheet":"User Manual","index":6,"n_rows":56,"n_cols":4,"rows_kept":56,"cut":false,"hidden":true,"merged":[[46,2,46,3],[19,3,20,3],[21,3,22,3],[50,2,50,3],[51,2,51,3],[45,2,45,3],[44,2,44,3],[43,2,43,3],[42,2,42,3],[25,2,25,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[47,2,47,3],[15,2,15,3],[34,2,34,3],[41,2,41,3],[36,2,36,3],[35,2,35,3],[30,2,30,3],[29,2,29,3],[28,2,28,3],[16,2,16,3],[37,2,37,3]]}
[]
[null,null,"Qwil Messenger"]
[null,null,"Chat Butler Automated Messaging Tool User Manual"]
[]
[]
[null,null,"Contents"]
[null,null,"Configuration (Admin only)"]
[null,null,"Compiling A Message"]
[null,null,"Compiling A Send List"]
[null,null,"Sending A Message"]
[]
[]
[null,null,"Configuration (Administrator guide)"]
[null,null,"This is a powerful tool and access should be restricted and the administrator version should not be distributed."]
[null,null,"Setting up the tool:"]
[null,null,"·       Upon opening the workbook for the first time, you will be encountered by the \"ADMIN - SECURITY DETAILS\" tab."]
[null,null,"·       This tab contains the following parameters:"]
[null,null,"Organisation Name","The name of your organisation"]
[null,null,"Organisation Region","Hosting region, this can be found in the Desktop Qwil app under Administration>Settings>API "]
[null,null,"Master User API key ID","Master User API keys and secrets may be found or created in the desktop Qwil App under Administration>Master API keys>Create New"]
[null,null,"Master User API Key Secret"]
[null,null,"System API Key ID","Master User API keys and secrets may be found or created in the desktop Qwil App under Administration>System API keys>Create New"]
[null,null,"System API Key Secret"]
[null,null,"Workbook User Password","Set the password staff will require to open the butler app"]
[null,null,"Admin UUID","Enter an admin UUID. This is required to test the API keys. This can be found in the Qwil app by accessing a user account and copying the UUID listed next to the <> icon."]
[null,null,"Once the above parameters are complete, test the keys by clicking the \"Test Keys\" button. If there is an error, double check the API keys and the Admin UUID"]
[]
[null,null,"Distribution:"]
[null,null,"·       After the set-up stage, click the button labelled \"Create App\". This will create and open a restricted version of the tool for distribution. The password selected previously will be required to open the document."]
[null,null,"·       The new Excel tool will automatically open. This is now ready for use and saved in the same folder as the Butler Admin excel file. "]
[null,null,"·       The tool ready for distribution to trusted staff users, please send the file and password separately."]
[]
[null,null,"Compiling A Message"]
[]
[null,null,"·       Once opening the excel tool, enter the password provided to you by your system administrator, enable macros and use in read-only mode."]
[null,null,"·       Select between “Text” and “File” dropdowns in the “Message Type” field for every message you would like to send. You can enter up to 10 messages at one time."]
[null,null,"·       Enter your message in the “Message Content” field. If your message is a file, please enter the full file path. On windows, hold shift and right click on a file then click \"copy as filepath\"."]
[null,null,"·       Tip: You can send a message in the format <First Name> or <Last Name> and the Butler will inserts individual names."]
[]
[]
[null,null,"Compiling A Send List"]
[null,null,"In the recipients field, select from the drop down whether you would like to:"]
[null,null,"·       “Send to All” – send your messages to all active users."]
[null,null,"·       “Send to Staff” – send your messages to all active staff users."]
[null,null,"·       “Send to Clients” – send your messages to all active client users."]
[null,null,"·       “Send to Group” – send your message to individuals in selected groups."]
[null,null,"·       “Custom List” – this will present you with a list of all active users, you are then able to edit this list by deleting rows that are not required. "]
[null,null,"Note: When choosing “Custom List”, ensure you delete the row, not just clear the cells. There must be no blank spaces between recipients."]
[]
[null,null,"Sending A Message"]
[null,null,"·       The “Send” tab will automatically open upon compiling a send list. "]
[null,null,"·       You can now double check the recipients and click “send”. "]
[null,null,"·       Delivered messages will show as a green “Delivered” cell, if a message cannot be delivered, the macro will stop and ask whether you would like to retry or cancel. "]
[null,null,"·       If you encounter this issue, wait a few seconds and click retry to resume sending. If the message still hasn’t delivered, click cancel and check your internet connection, the recipient details and and file paths."]
[null,null,"·       Messages may also not send due to revoked system and user API keys. Check whether you are using the most recent version of the tool with your administrator."]
[null,null,"·       Once all your messages have been sent, the “Send” Tab will automatically close and return you to the “Butler Message” tab."]