Skip to main content

[Extension] How to use Google Sheets as your chatbot's database in Blip

  • Updated
  1. Introduction
  2. How to configure reading in the flow
  3. Support

 

Brief description: Read entire ranges from a Google Sheets spreadsheet during the conversation, such as price tables, catalogs, and lists of options, and use the data in the bot flow without creating an API.

 

Introduction

Keeping prices, catalogs, and lists of options directly in the bot flow is time-consuming: every change requires editing and republishing the flow. With the Google Sheets extension, you keep this data in a spreadsheet, and the bot reads the range during the conversation. The spreadsheet becomes the chatbot's database, and the person responsible for the content can update the spreadsheet without changing the flow.

The Get values from a range action reads a range of cells that you define and returns the content to a flow variable. It can be used to look up a price table, list products from a catalog, or build menu options from the spreadsheet, all without creating an API or relying on development. To retrieve the row of a single record by a value, see the row search pill.

Before you start

Make sure you already have:

  • The Google Sheets extension enabled in the bot. Enable Google Sheets in the Blip Store.

  • Signed in with your Google account on the extension's Settings screen, with spreadsheet permissions granted.

  • The Builder browser extension installed. It adds the New integration button to Builder and has the Install extension link on the extension's Settings screen.

  • A Google Sheets spreadsheet with the data organized in rows and columns. The connected Google account must have access to this spreadsheet.

  • The spreadsheet ID and the range you want to read (for example, the range of a price table).

 

How to configure reading in the flow

The integration runs as a block exit action. Place the block at the point in the flow where you need the spreadsheet data.

  1. In Builder, click New integration to add an integration block to the flow.

  2. Open the block and, on the Integration tab, select Google Sheets.

Bloco de integração no Builder com Google Sheets selecionado no campo Integração

  1. In the Action field, choose Get values from a range.

  2. In Spreadsheet ID, enter the spreadsheet identifier. It is in the URL, between /d/ and /edit.

  3. In Range, enter the sheet and the range of cells you want to read, for example Sheet1!A2:C10 for a list of products.

Formulário da ação Pegar valores de um intervalo com ID da planilha e intervalo preenchidos

  1. In Save response, enter the Result variable. It receives the range content as a list of rows, and each row is a list of the cells in that row.

  2. Publish the flow and run a test to check the response. Use the result variable in the next blocks, referencing the rows and columns by their positions.

Retorno da leitura do intervalo salvo na variável de resultado durante o teste do fluxo

Important

The range must be correct, and the connected Google account must have access to the spreadsheet. If the range is incorrect, empty, or outside the specified sheet, the result variable will not return the expected data. Check the sheet name and cell range before publishing.

 

Support

If you have questions or problems with the extension, contact us at support@wiv.com.br.


 

Need more help? Explore our content on Blip Academy or Blip Community, watch tutorials on our YouTube channel or get your questions answered through our support channel 😃

Related articles