response = Map(); response.put("action","reply"); startList = {}; /***to connect your google spreadsheet, replace the sheet id and connection name url:"https://sheets.googleapis.com/v4/spreadsheets/your-spreadsheet-id-goes-here/values/Sheet1!A2:B30?majorDimension=ROWS" connection:your-connection-name-goes-here ***/ apiresponse = invokeurl [ url :"https://sheets.googleapis.com/v4/spreadsheets/15sRy5rN5wFKmemzuA8qCv7ZTW9aRbZfsQVUHI_OMVso/values/SalesIQ-ZobotSheet!A2:A26?majorDimension=ROWS" type :GET connection:"googlespreadsheet" ]; info apiresponse; recordList = apiresponse.get("values"); for each rows in recordList { menuOption = rows.get("0"); if(!startList.contains(menuOption)) { startList.insert(menuOption); } } response.put("replies",{"Hey there :)","Choose an option below to post your queries"}); response.put("input",{"type":"select","options":startList}); return response;