External Integrations Section - Google Sheets

Basics & Overview

1. What is the Google Sheets block used for?

The Google Sheets block allows your chatbot to read data from and send data to a Google Sheet. It's a powerful tool for automating data management, tracking user information, and building a simple database directly within your bot's flow.

2. How does the Google Sheets block help my chatbot?

It gives your chatbot a memory and a data source. You can save user inputs (like a name or email) to a sheet, or you can use data from a sheet to personalize a conversation or answer a user's question.

3. What can I do with the Google Sheets block?

The block supports two main actions:

• Read data from sheet: Your chatbot can search for and retrieve information from a Google Sheet.

• Send data to sheet: Your chatbot can add new information to a Google Sheet.

4. What do I need to use the Google Sheets block?

You need to have a Google account connected to your chatbot, a Google Sheet created, and its unique ID ready to use.

5. How do I find the Google Sheets "Spreadsheet ID"?

The Spreadsheet ID is a unique string of letters and numbers found in the URL of your Google Sheet. It's the part of the URL between /d/ and /edit.

Action: Read Data From Sheet

6. How do I get data from a Google Sheet using the Google Sheets block?

First, select "read data from sheet" from the "Select Type" field. Then, enter the Spreadsheet ID, the name of your specific sheet, and define any filters you want to use.

7. What is the purpose of Filters in the Google Sheets block?

Filters allow you to search for specific data in your sheet. You can specify a Column and a Value to find a matching row.
For example, you can filter for a user's order number to get their order details.

8. Can I apply multiple filters in the Google Sheets block?

Yes, you can add multiple filters to narrow down your search even further.
For example, you can filter by Column: “Status” and Value: “Pending” to find all pending orders.

9. What happens if no matching data is found in the Google Sheets block?

If no data matches your filter criteria, the block will not return any data.
You can program your chatbot to respond accordingly (e.g., “Sorry, I couldn't find that information.”).

10. How can I use the data read from the Google Sheets block?

You must use the “Store the response in variable” field.
This saves the retrieved data into a variable, which you can then use in a Text block to display the information to the user or use it in another block.

11. Does the Google Sheets block automatically update the sheet?

No. This action is for reading data only.
To update the sheet, you would need to use a different action.

12. In what format is the data stored in the Google Sheets block?

The data is typically stored as a JSON object or an array of objects, with each object representing a row of your sheet that matched the filter.

Action: Send Data to Sheet

13. How do I send data from my chatbot to a Google Sheet using the Google Sheets block?

Select “send data to sheet” from the “Select Type” field.
You will then provide the Spreadsheet ID, the sheet name, and set up your Variable Mapping.

14. What is Variable Mapping in the Google Sheets block?

Variable Mapping connects the data you've collected in your chatbot to the correct columns in your Google Sheet.
It tells the system where each piece of information should go.

15. What is the difference between Partner Variable and ChatMaxima Variable in the Google Sheets block?

• Partner Variable: Represents a column in your Google Sheet (e.g., “Email” or “Name”).

• ChatMaxima Variable: Represents the variable in your chatbot’s workflow where the data is stored (e.g., {{user_email}} or {{user_name}}).

16. How do I make sure the data goes to the right column in the Google Sheets block?

Ensure correct mapping of the Partner Variable (column name) to the corresponding ChatMaxima Variable.
This creates a precise connection.

17. Can I send data to a new row in the Google Sheets block?

Yes. The “send data to sheet” action will automatically add a new row to the end of your sheet with the data you have mapped.

18. Can I update an existing row using the Google Sheets block?

The primary function is to send new data.
To update a record, you would need to use a different action or integration, as this block focuses on adding new rows.

Practical Use Cases

19. How can I use the Google Sheets block for lead generation?

You can use the “send data to sheet” action to automatically save a user's name, email, and phone number to a Google Sheet as a new lead, which you can then follow up on later.

20. How can I use the Google Sheets block for product lookup?

You can use the “read data from sheet” action to find product information.
The user gives you an item number, you filter the sheet by that number, and the bot retrieves the price and description.

21. Can I create a simple CRM using the Google Sheets block?

Yes. By using the “send data to sheet” action to add new contacts and the “read data from sheet” action to retrieve their information, you can create a simple, no-code CRM.

22. How can I use the Google Sheets block for a survey?

You can ask a series of questions in your bot, save the user's answers in variables, and then use the “send data to sheet” action to save all the responses to a single row in your sheet.

23. How can I use the Google Sheets block for order tracking?

You can read data from a sheet to find a user's order status by using a filter on their order ID.

24. What happens when I click Submit in the Google Sheets block?

Clicking Submit saves the block in your workflow.
The action you configured will run automatically when the bot reaches this block in the conversation.

Location & Tutorials

25. Where can I find the Google Sheets block in ChatMaxima?

You can find the Google Sheets block in the External Integrations section of your chatbot builder.

26. Where can I find the video tutorial for the Google Sheets block?

You can find the video tutorial at:  https://chatmaxima.com/video-tutorials/integrating-google-sheets-node-in-chatmaxima/.

Advanced Questions

27. What if the data from the Google Sheets block is not in the correct format?

You may need to use a Code block or Variable block to format the data after it's retrieved, before it is displayed to the user.

28. Are there any security concerns with the Google Sheets integration?

The integration relies on your Google account’s permissions.
It’s important to only grant the chatbot access to the specific sheets it needs to interact with to protect your data.

29. Can I use a variable to select the Spreadsheet ID or Sheet Name in the Google Sheets block?

Yes. You can use variables in these fields to make your bot even more dynamic, allowing it to work with different sheets based on user input.

30. How many rows can the Google Sheets block read at a time?

The limit depends on the platform’s constraints.
You should use filters to narrow down results to avoid fetching too much data at once, which could slow down the bot.

31. Can I use the Google Sheets block to fetch data from a public sheet?

Yes, as long as the sheet is shared and accessible to the account you've integrated with, the chatbot can read from it.

32. Can the Google Sheets block work with multiple sheets at once?

No, each block is configured to interact with only one sheet at a time.
To interact with another sheet, you would need to use a new block.

33. What is the role of an Exit Clause in the Google Sheets block?

The provided information does not mention an “Exit Clause” field for this block, but if it were an option, it would control when the chatbot should move to the next part of the flow after the action is complete.