Selecting "add new row" from a "Specific sheet" within a Google sheets as Trigger

Status: Closed · Asked by Pabbly Noob on · 0 views

Pabbly Noob — Question ·

Hi,

I have two sheets in my Google Sheet. First sheet is "All Visits". Second sheet is "Unique Visitors". I have used "Unique" formula in Google Sheets to automatically update "Unique Visitors" sheet, based on entries in "All Visits"

I want use "add new row" in "Unique Visitors" as a trigger, to add a "Google Contact". But it is always taking "add new row" in "All Visits" as the trigger, and data from "All Visits" as response. I tried to change the order of sheets, created a new workflow, and used a new webhook URL. But nothing worked.

Anyway to make this happen, and read off from "Unique Visitors" sheet instead?

Thanks in advance.

Fagun Shah — Reply ·

Pabbly Google Sheet Addon only supports 1 sheet inside spreadsheet, so do not use multiple sheets in a spreadsheet if you're planning to use one the sheets as trigger.

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/
Pabbly Noob — Reply ·
Pabbly Google Sheet Addon only supports 1 sheet inside spreadsheet, so do not use multiple sheets in a spreadsheet if you're planning to use one the sheets as trigger.

Thank you!

Back to all forum threads · Log in to reply