Update Data Operation
You can create automated workflows that can update data in a google sheets document.

Simply choose the Update Data operation, mention the document ID and the name of the sheet.
Note: To determine the Sheet Name please refer to Create Sheet operation.
Note: You get the document ID from the URL of the file. For example, if the URL of a file is docs.google.com/document/d/1LQ_zgy0QDy/edit , the document ID is 1LQ_zgy0QDy.
- The range is to determine where the data updating starts and where it ends.
- Rows determine which row to update starting from first till last, Row 1 that means the first row that is mention in the range section.
- Cells determine the first cell and the last cell in the row and each cell has text tab to change the data in it.

Note: you can add as much rows as you stated in the range sections and add cells to match the amount of each row.
Updated 5 months ago