About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Update existing row in Google Sheet

  • 24 June 2021
  • 7 replies
  • 306 views
M

Hi everyone ! 

I am trying to do a zap with Google sheet. Indeed my Google sheet has 2 columns headers. The first one is already filled with Names and I would like to fill automatically (with a zap) the second columns with Names. 

It is important for me that the 2 datas are on the same rows so I cannot use the “add rows” and i have at least 50 names therefore I cannot use the “update a row” action too. 

Do you know what can I do to filled this second column to have my datas of my two columns on the same rows ? 

Thank you all for reading, 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Mathiilde 

Can you post a screenshot of how your GSheet is configured?

 

Try this…

Action: GSheets - Find/Lookup Row

Action: GSheets - Update Row

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M

Sure ! 

The column A is already filled and my zap allows me to access to the LinkedIn URL data I want to put in column B. Unfortunately, I have just succeed to add rows that put the LinkedIn URL below row 9 and I want them to be on B2:B9. 

Thank you a lot for your help !

Troy Tessalone
Userlevel 7
Badge +14

Hi @Mathiilde 

Did you try this?

Try this…

Action: GSheets - Find/Lookup Row

Action: GSheets - Update Row

Map the Row ID found in the Find/Lookup Row step to the Update Row step.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M

Hi @Troy Tessalone 

I have tried but I do not succeed to set up step 3 and 4 correctly. Indeed, my step 1 get the LinkedIn URL data, step 2 add it to another Google sheet and I would also like these to be added in another google sheet in the next column. 

I do not know what to put in the following blank : 

Thank you for your help I appreciate it :) 

Troy Tessalone
Userlevel 7
Badge +14

@Mathiilde 

Lookup column A

Map in the lookup value from a previous Zap step.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M

Hello @Troy Tessalone 

Thank you for your answer 
I have tried it and that is what I obtain : 

I have 2 issues : 

The first one is that it has replace the header of column B I wanted to have my data from B2.

The second issue is that the linkedIn URLs are in the same cell and I wanted them to be one under the other in column B. 

Do you have an idea if these issues are from my settings or if I have to add another function ?

Thank you very much!

Troy Tessalone
Userlevel 7
Badge +14

@Mathiilde 

Please provide screenshots of how your Zap steps are configured?

In the Update Row step, the Row value should be a mapped value with the Row ID from the previous Find/Lookup Row step.

Help article: https://zapier.com/help/create/basics/set-up-your-zap-action#set-up-your-action

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions