How to edit a row in google sheet?

[rajeswernaidu]

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)?

 

[ArshilAhmad]

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]

Thank you. Will create the flow as explained