Google Spreadsheet

1 Setup Google Spreadsheet
2 Manage Spreadsheet in Action Step
- 2.1 Insert Row
- 2.2 Get Row by Value
- 2.3 Get Multiple Rows
- 2.4 Update Row

With Google Spreadsheet, you can add, update and look up your data in a spreadsheet as well as process the data with various built-in tools with Google.

Setup Google Spreadsheet

Follow steps 1 to 4 to connect to your Google account. Allow UChat to access your Google spreadsheet. When you come back, if nothing changed, click step 1 to 3 again to refresh and you will see this:

Create a new spreadsheet or make sure you have one in the Google account that you just connected to.

Name the spreadsheet and worksheet properly at area 1 and 2. You will need them when you manage your data in the Action step.

WARNING - Importantly, remember to give column names for the worksheet in the first row (see area 3 in the above picture). You must do this by manually type in what fields do you need. For example, this is a product worksheet and each product has a name, a price and a description.

Later when you manage your data, this is how it looks like when the column names are set correctly (area 1,2,3 in the above picture are correspond to 1,2,3 in the following picture):

Manage Spreadsheet in Action Step

In an Action step, follow steps 1 to 3 in the above picture. Then you will see a list of functions.

Insert Row

Get Row by Value

Get Multiple Rows

Update Row

IN PROGRESS - text tutorial about this page is in progress. Please check Google Sheet and Google Sheet 2 for guidance. Sorry for any inconvenience.