PROBLEM WITH NEW SPREADSHEET ROWS TRIGGER

[AntiSocialLab]

Hi everyone I've setted up as trigger the fulfillment of new rows in Google sheet (INSTANT)

(I've set up correctly the webhook through the Pabbly sheet extension and tried it: webhook send data and Pabbly recive them)

Now my process:

I have a scraper that put all new items in specific research into the sheet. It puts 5 rows/time in it and I can't do in other way.

The problem is that Pabbly doesn't process the new rows and don't start the workflow.

Anyone can help me?

I've attached a clone of my workflow

 

[Supreme]

Hey @AntiSocialLab

Can you please record a short video on how you have configured the webhook URL and captured the webhook response?

 

[AntiSocialLab]

Hey @AntiSocialLab

Can you please record a short video on how you have configured the webhook URL and captured the webhook response?

Yes sure: https://www.loom.com/share/f9e32d1a074f4762b365f500acaf8f55

 

[Supreme]

The Google Sheets platform is by utilizing straightforward data management techniques. However, it's important to note that incorporating app script or formulas is not allowed in this context. The data can only be transferred through Google Sheets to Workflow without any additional script or formula implementations.

 

[AntiSocialLab]

The Google Sheets platform is by utilizing straightforward data management techniques. However, it's important to note that incorporating app script or formulas is not allowed in this context. The data can only be transferred through Google Sheets to Workflow without any additional script or formula implementations.

Actually, I want the rows from sheet 2 to be imported into Pabbly: from the test, it works.

The process that filters the data from sheet 1 and imports them into sheet 2 happens first and should not affect the proper import of data from sheet 2 carried out by Pabbly.

 

[CNLPRO]

The Google Sheets platform is by utilizing straightforward data management techniques. However, it's important to note that incorporating app script or formulas is not allowed in this context. The data can only be transferred through Google Sheets to Workflow without any additional script or formula implementations.

Hi, just posted a thread but its getting no views or responses, can I get some help ?

 

[Supreme]

Please check your thread, we have replied over there.

 

[AntiSocialLab]

The Google Sheets platform is by utilizing straightforward data management techniques. However, it's important to note that incorporating app script or formulas is not allowed in this context. The data can only be transferred through Google Sheets to Workflow without any additional script or formula implementations.

I have as Trigger for a workflow "new row in google sheet". I have a couple of questions and I'll be glad if anyone will help me. 1) Gsheet is updated/populated by a scraper that put 3/4 rows to each update. Will Pabbly keep each of these rows?

2) There is a way to know if the content of a specific column (of each of the new rows) already exist in that column in any of the previous rows?

I had I fantastic array formula that filter all the data in worksheet1 and put only needed data in worksheet2. Unfortunately I don't know how to keep data from this worksheet because Pabbly Addon can't consider new rows putted by formula as new rows. (If there is any workaround I'll be happy to know that).

 

[Supreme]

I have as Trigger for a workflow "new row in google sheet". I have a couple of questions and I'll be glad if anyone will help me. 1) Gsheet is updated/populated by a scraper that put 3/4 rows to each update. Will Pabbly keep each of these rows?

From where and how you are getting the data in the Google Sheets along with that is there any formula imported?

2) There is a way to know if the content of a specific column (of each of the new rows) already exist in that column in any of the previous rows?

I had I fantastic array formula that filter all the data in worksheet1 and put only needed data in worksheet2. Unfortunately I don't know how to keep data from this worksheet because Pabbly Addon can't consider new rows putted by formula as new rows. (If there is any workaround I'll be happy to know that).

I regret to inform you that the possibility of initiating data retrieval from Google Sheets using a formula or Apps Script is not within the scope of support we can offer.