How to edit a row in google sheet?

Status: Open · Asked by rajeswernaidu on · 0 views

rajeswernaidu — Question ·

Is there a way to use the data entered in google form, retrieve existing data from google sheet, edit/store new data in the same existing row (not to add a new row)?

Arshil Ahmad — Reply ·

You can set up your workflow in this manner to achieve this use case:

  1. Use the Google Forms trigger step to capture form responses.
  2. Then, use the 'Lookup Spreadsheet Rows' action step to retrieve the data.
  3. Finally, use the 'Update Row' action step to update the data in that row.

rajeswernaidu — Reply ·

Thank you. Will create the flow as explained

Back to all forum threads · Log in to reply