Need Help Updating Specific Column in Sheet Row | Clay

Need Help Updating Specific Column in Sheet Row

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.

7 comments

Channeled
APP
·
·
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.
Sources: Google Sheets integration overview | Documentation | Clay University Lookup, Add, or Update Row with Google Sheets
Gaurav S.
·
·
Hey Hi,
Gaurav S.
·
·
"Lookup, Add, or Update Row". cant find ?
Channeled
APP
·
·
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.
Sources: Google Sheets integration overview | Documentation | Clay University Google Sheets integration overview | Documentation | Clay University Lookup, Add, or Update Row with Google Sheets
Gaurav S.
·
·
I am writing to other clay table not the google sheet
LuisArturo
·
·
Hey there Gaurav thanks for reaching out, do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Channeled
APP
·
·