Hi Team Clay, Add row to other sheet option we are using, need help to update (NOT REWRITE ) a specific column of the row in next run.
To update a specific column of a row in another sheet without rewriting it, you can use the "Lookup, Add, or Update Row" action instead of "Add row to other sheet". Here's how: 1. Use the "Lookup, Add, or Update Row" action in your workflow. 2. Specify the Google Spreadsheet URL you want to update. 3. Set the Lookup Column and Value to find the specific row you want to update. 4. Map only the column you want to update from your Clay table to the corresponding column in Google Sheets. 5. Configure the run settings as needed. This action will find the existing row based on your lookup criteria and update only the specified column, leaving other data intact.
Hey Hi,
"Lookup, Add, or Update Row". cant find ?
To update a specific column of a row in another sheet using the "Lookup, Add, or Update Row" action without rewriting it, follow these steps: 1. Select the "Lookup, Add, or Update Row" action in your workflow. 2. Paste the Google Spreadsheet URL you want to update. 3. Specify the Sheet ID where the row is located. 4. Set the Lookup Column and Value to find the specific row you want to update. 5. Map only the column you want to update from your Clay table to the corresponding column in Google Sheets. 6. Toggle "Update row(s) if existing rows are found" to modify existing rows that match the lookup value. 7. Configure the run settings as needed. This action will find the existing row based on your lookup criteria and update only the specified column, leaving other data intact.
I am writing to other clay table not the google sheet
Hey there Gaurav thanks for reaching out, do you mind sending the link (url) to the table so we can take a look?