Skip to main content
Best answer

Trying to update another Google Sheet when a column is updated on my master list

  • September 5, 2020
  • 1 reply
  • 71 views

Im trying to create a zap off my master list.

 

  1. Column “V” gets updated with “Elvin” in Master_List.
  2. Send whole row that’s in Master_list to google sheet “Elvin_Leads”.
  3. Create new row with data.

Best answer by steph.nBest answer by steph.n

Hi there @ElvinZaps - Thanks for the question! You can check our Zap triggers and actions here: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions. If you check out the Actions tab, you can see Create Spreadsheet Row, and do a Search step for “Elvin_Leads” as a target, then Create Spreadsheet Row(s) that has line-item support. Give this a try and let us know if you still need help.

P.s. The suggestion here is if you have both sheets in the same workbook. You may have consider a workaround if you’re trying to do it in between different Google Sheets that don’t host the same sheets on the same file.

Thanks!

 

View original
Did this topic help you find an answer to your question?

1 reply

steph.n
Forum|alt.badge.img+8
  • Builder
  • 899 replies
  • Answer
  • September 22, 2020

Hi there @ElvinZaps - Thanks for the question! You can check our Zap triggers and actions here: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions. If you check out the Actions tab, you can see Create Spreadsheet Row, and do a Search step for “Elvin_Leads” as a target, then Create Spreadsheet Row(s) that has line-item support. Give this a try and let us know if you still need help.

P.s. The suggestion here is if you have both sheets in the same workbook. You may have consider a workaround if you’re trying to do it in between different Google Sheets that don’t host the same sheets on the same file.

Thanks!

 


Reply