Skip to main content
Best answer

Do I have to create a new Zap for each sheet or is there a way to set up a trigger for multiple sheets?


Hi all. So here is what I am trying to do. I have a Google Spreadsheet with a sheet A and a sheet B. What I would like to do is when Sheet A or Sheet B has a row added the Zap will send that info to a database. 

 

How do I set up the trigger so that when data in either sheet is added the trigger is initiated. Currently when I use a google sheet as a trigger I can only select one sheet. Do I have to create a new zap for each sheet or is there a way to setup a trigger for multiple sheets? 

 

Best answer by EJRBest answer by EJR

Hi @joester1976,

Thank you for posting in the Zapier Community! Happy to help here.

To support what @MohSwellam said above, yes, you’ll need to have two separate Zaps to achieve your end goal. At present, we can only set up one (1) Google Sheets per trigger step -- so creating two separate Zaps for each sheet is needed in this scenario.

The Zap workflows would look like this: 

Zap 1:

  1. Google Sheets: New Spreadsheet Row (Sheet A)
  2. The Database app of your choice: Create Database Record 

Zap 2:

  1. Google Sheets: New Spreadsheet Row (Sheet B)
  2. The Database app of your choice: Create Database Record 

Does that point you in the right direction? Let me know your thoughts! 

View original
Did this topic help you find an answer to your question?
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

MohSwellam
Forum|alt.badge.img+8
  • Zapier Expert
  • 840 replies
  • August 22, 2022

Hi, 

 

Yes, you need to use a separate zap for each sheet. 


EJR
Forum|alt.badge.img+3
  • Zapier Staff
  • 35 replies
  • Answer
  • August 25, 2022

Hi @joester1976,

Thank you for posting in the Zapier Community! Happy to help here.

To support what @MohSwellam said above, yes, you’ll need to have two separate Zaps to achieve your end goal. At present, we can only set up one (1) Google Sheets per trigger step -- so creating two separate Zaps for each sheet is needed in this scenario.

The Zap workflows would look like this: 

Zap 1:

  1. Google Sheets: New Spreadsheet Row (Sheet A)
  2. The Database app of your choice: Create Database Record 

Zap 2:

  1. Google Sheets: New Spreadsheet Row (Sheet B)
  2. The Database app of your choice: Create Database Record 

Does that point you in the right direction? Let me know your thoughts!