Hi Community,
I am frankly desperate with this issue because I think it should have an easy solution, but so far I can’t find it.
My problem is that the Watch New Rows module reads rows without data but with formulas inside. Let me explain so that you can see the sense of it all.
Step 1: Contactform 7 registers forms in my web. These are contacts that download ebooks after filling out a form.
The goal is to automate the generation of leads in Pipedrive from all the forms that are filled out on the web.
Step 2: I dump each form record in Google Sheet.
Step 3: In the same workbook but different sheet, I make an enrichment of the form information. For example, the “province” field allows me to create a new custom field called “zone”. The zone is a group of provinces that will allow me to assign each lead to each sales office.
Before jumping to step 4, let me tell you that this new “rich sheet” is automatically generated with formulas that “read” from the original sheet. At first glance it looks like a blank sheet with just headers but it has a matrix of formulas with 2000 rows and 12 fields filled with formulas.
I continue:
Step 4: The problems begin… 
Through the Gsheet Watch new Row module, I connect that sheet with Pipedrive. This way, when a new Contactform 7 record is added, it will be exported as Deal to my Pipedrive.
Oooh, it all sounds great doesn’t it?
It doesn’t. 
What happens? Well, this module is theoretically triggered when new rows are added at 15 minute intervals.
The thing is that, as there are hidden formulas, it understands that they are exportable records and tries to export empty rows to Pipedrive.
As you will understand, there are certain fields that are “mandatory” (e.g. in organization name) and being empty, they cause the flow to break and the error to occur.
Attempted solutions:
I have tried with a filter before exporting to Pipedrive but it happens that the reading of records will advance in number of rows (one row every fifteen minutes) and will leave records to be exported when these occur.
Can you think of a way to solve this? Surely it exists since this scenario must be very common among marketers.
Thank you very much in advance
Diego