I have a Google Sheet that contains ALL client notes and logs, named “Prospect Notes”. I have a lot of zaps that document the zap’s actions into this sheet…. like “Google contact created” or “Gmail label added” as well as all the notes that the sales person adds to their file in Smartsheets. 

Then I have a separate Google sheet for each individual prospect that contains only notes for that prospect. A zap creates this sheet from a template and gives it the title “First name Last name”

I want to automatically copy notes as they are added from the main sheet “Prospect Notes” to each individual prospect’s sheet “First name Last name”

When I create the zap. there is no look up function to find the individual sheet. 

So I just use the event “Create spreadsheet row”

To select the spreadsheet to copy to, instead of selecting from the available spreadsheet options, I used Custom, and entered “First name Last name” from the available fields. See screen shot.

Then to select the worksheet I used custom again and entered the worksheet name “All Notes”

So in theory, the zap should look for the Google Sheet with my prospect’s name as the title “First name Last name” and then look in that sheet to find the worksheet “All Notes” and then copy the new row into this sheet.

It’s not working and not sure how to get the Zap to locate the individual spreadsheet to copy to. If I select a spreadsheet from the available choices, then it won’t work as the individual sheet will be different when the notes are from different prospects.