DialogFlow CX agent and Google Sheets

We will create a conversation agent to answer users’ queries using information maintained in a Google Sheet.

Sample use case: User would like to know the current availability of a facility.

Steps:

1. Create agent to extract relevant information such as facility name from the conversation.
2. Create a Google sheet to store information on current availability of each facility. Ensure the DialogFlow CX agent has read access to this sheet.
3. Write a function that the agent will call via a webhook. The function will reside in Google Cloud Run and its purpose is to take the facility name extracted from the conversation and search for its availability in the Google sheet. Once found, the answer will be returned to the agent which will display the answer to the user.

Leave a comment if you need more information on specific steps.