| Section |
|---|
| Column |
|---|
Let's take a look at how you can update existing values in a sheet. It’s another common scenario that can be used for a variety of tasks (e.g. limiting the number of submissions for a particular form or creating a sequentially increasing counter). We’ll use this sample Google Sheet to discuss. It has a row for each employee: Employee Id, Location and Extension. |
| Info |
|---|
First, it’s important to note that Google Sheets is not a transactional system like a database and results can be unpredictable if multiple users update the same Sheet at the same time. |
|
|
Rule syntax and best practices to follow are discussed in the Writing Rules to Retrieve and Update Data in a Google Sheet topic.
Step 1: Obtain an access token
...
| Insert excerpt |
|---|
| Obtain an Access Token |
|---|
| Obtain an Access Token |
|---|
| nopanel | true |
|---|
|
Step 2: Add the Business Rule
...
- It’s triggered by clicking on the Update Google Sheet button.
- We setup headers and an update query using your access token and spreadsheet key (the long ID in the URL of the Google Sheet). In this example, the name of the Google Sheet tab is Locations. Change the wsname= parameter to the name of your Google Sheet tab if you named the tab something different.
- Add updateparams: we’re updating location and extension with new values.
- Run the update – perform an http.put() and eval the results.
...