Google Sheet

Google Sheet is an extremely powerful CMS for managing customer and order information. Normally, if you want to save or retrieve data from a sheet into a chatbot, you will have to use a third party like zapier or ifttt. Either way is costly, or limited to data. So we developed AhaChat to make this job very simple and completely free.

1. Save to Google Sheet

You can integrate AhaChat directly with your Google account to export user information to Google Sheet.

To use the Google Sheet Integration, go to add a new block and select 'GOOGLE SHEET > CREATE NEW SHEET'

You will be asked to integrate your google account. Make sure to connect to the correct Google account that will use the spreadsheet.

After you complete the registration, you can add what user attributes you want exported every time a reachable user interacts with a bot.

The data will be exported to the Google Sheet file automatically once you set it up!

2. Update Google Sheet Data

You can integrate AhaChat directly with your Google account to update the user information available on Google Sheet.

To use the Google Sheet Integration, go to add a new block and select 'GOOGLE SHEET > UPDATE EXISTING SHEET'

You will be asked to integrate your google account. Make sure to connect to the correct Google account that will use the spreadsheet.

Select the Sheet, the Lookup Column, and the Lookup Value so that they correspond to the column and the Attribute that were used in the initial action.

2.1 Insert new Rows

The data will be exported to the Google Sheet file automatically once you set it up!

2.2 Update existing Rows

This feature allows you to update the information in a Google Sheet you had already filled before, using a column and a Attribute as the lookup values.

The data will be updated to the Google Sheet file automatically once you set it up!

2.3 Save rows to Attributes

And it basically works like this: AhaChat takes value 1001, looks for the number in the in the Google Sheet Column "id" — this is Lookup Column and saves it in the specified Attributes, "win_code" and "color" in our case.

For example, value of "coupon_id" is now 3 — this will be Lookup Value. And then AhaChat goes and looks for "3" in the Google Sheet Column "ID" — this is Lookup Column.

It will find a Row with "CKMP" code and "bf3a3a" color then map it to the chosen Attributes.