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
Best answer by christina.d
Hi there,
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!
+14Hi
Good question.
Try adding this Zap step: GSheet - Update Row
+9Hi there,
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
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.
+9We’re so glad this helped,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
