Question

Link value from row of database/spreasheet row to Docusign template field


Userlevel 2

Does anyone know how I can use a lookup feature from excel or google sheets to take the next available value in column A row 1?

To be specific have a set list of preassigned account numbers that are listed in column A and just have the zap select the next row down each time it triggers to reference to my docusign template field? 

I want to eliminate the manual entry if possible.

 

If Excel or Google sheet is not a viable solution for this, can anyone recommend anything?


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

2 replies

Userlevel 7
Badge +14

Hi @Luke B 

Try this, in Column B add a static value of “Available”, then use a GSheets Lookup Row step in your Zap to search for “Available”, which will find the first matching row, then follow that with a GSheets Update Row step in the Zap to replace the “Available” value with an “Assigned” value.

https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

Userlevel 7
Badge +10

@Luke B 
Just checking in to see if you still need help with this?