Google Sheets

1 introduction 1 introduction engati’s integration hub allows integration with external applications to provide added functionality to portal users to build their bots integration of google sheets specifically has facilitated storing the data collected during the bot flow for a user typical use cases where sheets can be used are saving booking information, saving information of leads from the bot flow, saving meeting schedules/appointments and logging support request information/ticket information for the support team google sheets integration is available with the business plan and higher you can add your sheets account by clicking on the integrations tab on your left panel and selecting google sheets 2 connect your google account 2 connect your google account steps to authorize sheets node to access your google sheets step 1 integrations>google sheets>add account step 2 enter the google account id to add and authorize 3 using the sheets 3 using the sheets 3 1 capabilities engati allows the bot builders to get information from the sheet or modify the existing data or add new data 3 1 1 search value this feature will allow the bot builder to search a cell with a particular value in the sheet and retrieve any of the other data points for the record these values can be set as attributes to be used in the bot flow 1\ while adding a new node select google sheets under integrations in the builder tab 2\ you can now choose an already connected account or authorize a new google sheets account 3\ in the ‘select and action’ field, select search row 4\ select the spreadsheet > clicking on "+ browse" will open up a google ui from which you can select your sheet 5\ select the worksheet 6\ search the value in the selected header this is will give the row in which the searched information is present 7\ single search once you select the header you want to search the value in you will be able to see the retrieve tab where you can retrieve any value from the row found in the search 8\ add an attribute to which the selected information is to be added 9\ you can access these attributes in the subsequent flows 10\ multi search in case the searched value matches in more than one row, all the cells data matching with the search crieteria will be added to predefined attribute {googlesheet search} you can use this attribute to further filter the search results 3 1 2 add information this feature allows the user to add certain information to a google worksheet row 1\ while adding a new node select google sheets under integrations in the builder tab 2\ select the connected account or add a new account and select the add row option from the drop down menu 3\ select the spreadsheet > clicking on "+ browse" will open up a google ui from which you can select your sheet 4\ the column headers should be predefined in the worksheet add the attributes in which the information that needs to be passed is stored in the bot flow here is an illustration of how the above setup reflects in google sheets 3 1 3 update information this feature allows the user to search for a value and update the information in that row 1\ click on add new node and select google sheets under integrations 2\ select an already existing account or authorize a new account 3\ select the update row under the select action field 4\ select the spreadsheet > clicking on "+ browse" will open up a google ui from which you ca select your sheet 5 select the worksheet 5\ select a header from the selected sheet (this would be the title of the columns) 6\ search the value in the selected header this is will give the row in which the searched information is present 7\ select the header under which you want to change the value 8\ add the new value to be updated from the update tab, this could be an attribute or a static value note if there is more than one row where searched information matches the new information will be updated in all the rows