Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

  • Home
  • Get Help
  • How Do I
  • How do I dynamically map the record ID and add Google Sheets updated row using custom value?

Good day, nice if you can help me.
1. I have a zap that I use to create a new record in a database when there is a new line in a Google Sheet.
2. If successful, this database returns a recordID.
3. Now I want to add that recordID to my Google Sheet.
4. How do I do that? I see in Zapier that the ID is returned and can be seen in History/Output of a zapier run. But how do I pick up that RecordID?

Thanks in advance for your help.

Best, Jan-Pieter

Hi @Jan-Pieter 

Good question.

Try adding this Zap step: GSheet - Update Row

Hi there, @Jan-Pieter! Thanks for reaching out and welcome to the Community! 🎉

I wanted to add onto Troy’s recommendation since he’s right, you’ll need to add a Google Sheets “Update Row” action. That said, you should be able to dynamically map the recordID from the previous step using custom values!

Here’s a guide on how to set this up:

I hope this helps! Keep us posted if you have any questions!

Thanks @Troy Tessalone and @christina.d, you both helped me do this. The trick is explained in a link in the article Cristina shared Round Robin setup. With this step you can retrieve and use the recordid from the previous step. 

 

In the next step (Step 5) you can update your google sheet by using the RowID of the google sheet in step 1.

I would not have made it out of here without your help. Super thanks.

 

We’re so glad this helped, @Jan-Pieter! And thanks for coming back here to share the last bit of setup you did to get this working. 😊

Terms & Conditions