Best answer

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

  • 5 September 2020
  • 1 reply
  • 67 views

Userlevel 1

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.
icon

Best answer by steph.n 22 September 2020, 23:40

View original

1 reply

Userlevel 7
Badge +8

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