Google Sheets: How to update a cell that is not the first column?
Hi gang! This is really simple problem but I have spent hours and hours trying to solve this.
My flow:
Step 1: User inputs a product name in first column in a row
Step 2: I ran Ai automation and fetch the price for that product
Step 3: I want to update column C on that specific row with the price info from step 2
I tried the “Lookup Spreadsheet Row” action so I can get the right row.
After that when I use the “Update Spreadsheet Row” I can only input the row from previous step as target, not the column. If I input the column as target I getn an error.
Page 1 / 1
Hey @Bottiverstas, welcome to the Zapier Community!
No worries—this is a common challenge, and I can see why it’s been tricky to figure out. The issue is that the “Update Spreadsheet Row” action in Zapier targets entire rows rather than specific columns. But there’s a simple way to solve this while keeping the rest of your workflow intact.
The key is to update the entire row, but only change the value of Column C, while leaving the other columns untouched.
To confirm, you want to update the same row that triggered the Zap in the first place, is that right? If that’s the case, you won’t need a “Lookup Spreadsheet Row” step, because the row ID will be available from the trigger output data.
After your step 2 where the AI automation fetches the price for that product, you’ll want to:
add an “Update Spreadsheet Row” in Google Sheets step
Use the row ID from the trigger to select the correct row
Map the data from step 2 into your column C
I hope this points you in the right direction!
Hi Sebastian and thanks for your reply!
I am still missing the part where I can selected specific column / cell:
Hi @Bottiverstas!
Thank you for reaching back out.
By having the correct row selected, you'll automatically be selecting the correct cell within a given column.
To confirm, the header for the column you’re looking to fill in is “Varuste.net” (column C), is that right?
With your current set up, you’ll be filling in the cell of the “Varuste.net” column that’s on row 3.
I hope this clarifies how the “Update Spreadsheet Row” process works in Zapier
Here is the Google Sheet
This is how it outputs the price:
My setup for the first step:
My setup for the last step:
Hi @Bottiverstas,
Thank you for getting back to us!
Would you be able to click refresh on the top right corner?
You should see a field called “Hinta”, matching your column C.
Let me know if this points you in the right direction! If not, I would encourage you to open a ticket with our support team so that we can take a deeper look at what could be going on:
It looks like the first row of the spreadsheet is blank:
Row 1 of the spreadsheet needs to contain the names of the columns (e.g. Tuotteen nimi, Kilpailija, Hinta) in order for the Zap to reference the cells for each row correctly.
Can you carry out the following:
Delete the empty 1st row from the spreadsheet so that row 2 moves up and becomes row 1.
Then click the refresh fields icon in the Zap again.
That should pull in three new fields into the Zap (Tuotteen nimi, Kilpailija and Hinta) where you can then map the necessary values from the Relevance AI action step. If not, you may need to then reselect the spreadsheet and worksheet again to get the fields to load.
Can you give that a try and let us know how it goes?
