select * where zipcode = 100000 is an invalid query. User-specified column names are not supported.The sheet name you specify is used to run the query. Use these variables to call in any part of the chatbot conversation. save_to_var : Name of the variable in which you wish to load the data.Generally, spreadsheets exist in row format, which is what you would be using most of the time. format : Specifies if the data needs to be read in a row or column format.Accepted values are 0 (for No headers) and 1 (for headers in the first row). headers : Specify if data has a header row or not.Here is the reference documentation for the SQL query. query : Specify the SQL query which should be run in the given sheet.A range is defined by the reference of the upper-left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range. range : Specify the range of cells (in the spreadsheet above) from where data needs to be sourced.sheet_name : Specify the name of the sheet from where data should be sourced.If the sheet already exists within your chatbot spreadsheet, just say “this” url : You can specify url of another Google spreadsheet here.config : Helps you to specify the path of the spreadsheet and name of the sheet that you need to access.Supported formats are spreadsheet (Supports any Google spreadsheet) for now. type : Lets you define the type of data source it is.So, suppose you can get some data from a spreadsheet and some from a remote database from : Lets you get data from multiple sources, shall there be a requirement.Simply replace the range parameter with a query parameter and its value with a SQL query. The SQL query is powered by the Google Charts Query Language. This command can also be used to run SQL queries within sheets to get the required result. Technically, you can use the same LoadData chatbot tag to do it. Test Drive this chatbot here: Get the Chatbot Template for Zippy (Spreadsheet as Database Chatbot Demo) How to use Google Spreadsheet as Database for Chatbot: Here is an example chatbot created that remembers all 33,000 Zip codes in the United States and can fetch details about it using Database loaded in the Chatbot spreadsheet itself. But now, you can use a simple spreadsheet as a database within your chatbot that both Sales team and Chatbot can interact with easily, to enable perfect co-bot synergy (where humans and bots work together) Meet Zippy: Chatbots can also be connected directly to any SQL Database to perform any query. Hybrid.Chat already allows you to use Google spreadsheet as a CMS ( content management system ) for your chatbot. And why not? Spreadsheets are easy to use, edit and quickly collaborate on with not much learning curve. We see a lot of sales and business teams using spreadsheets as a database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |