Note:  The Google spreadsheet where the Question and answers are stored should be named as ‘ SalesIQ-ZobotSheet '. And the columns should be populated in the following order:                                                                   

• Column 1: Question department (the menu option)
  
• Column 2: Question
  
• Column 3-7: Response 
  

Note : You should create a separate spreadsheet to collect the unknown question and name the sheet as ' SalesIQ-ZobotSheet-UnknownQuestions' . The sheet will be populated in the following order: 

• Column 1: Unknown question
  
• Column 2: Date and time in which the question was asked 
  

• If you wish to add more questions to the bot or to remove the existing question, you don't have to make any changes to the code. You can just reflect the changes in the google spreadsheet or your Dialogflow account.
  
• We have constructed this bot to read only the first 26 rows of the synced spreadsheet (SalesIQ-ZobotSheet.) If you wish to add more questions to the spreadsheet you can extend the limit by changing the upper limit in each Google spreadsheet connection URL.
  

Bot flow:

The bot initiates the chat with a welcome message and the main menu. Once, the visitor responds by choosing an option, and the flow continues as depicted

How to create the bot? 

• Navigate to  Settings > Zobot > Add . Provide the required information and choose the  SalesIQ Script platform. 
  
• Now, copy the script from  here  and paste in the Message Handler section.
  

To integrate with your  Dialogflow account  and Google spreadsheet you've created, make the changes marked in red in the message handler code: