GHL TO SPREADSHEET WONT FETCH DATA

[Mark Francis]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NmQwNTZlMDYzMDA0MzY1MjY5NTUzMiI_3D_pc

Your Task History ID

IjU3NjAwNTZmMDYzMzA0MzU1MjY0NTUzMDUxMzI1MTYxNTQzOSI_3D_pc

Hi guys, I have a problem. The scenario is this, we have 4 landing pages with different forms. I want the name of the form to be fetch on my spreadsheet everytime a prospect client fill out a form so we will know which landing page did he submitted from.
I tried Lead connector & Highlevel(Legacy) as trigger and Im still getting the same error.
I just want values of 1 column updated. this is the link where I followed the tutorial (

)
This is the error : Required field Row Index missing

 

[Pabblymember11]

Hey @Mark Francis

It appears that you might have in the "LookupSpreadSheet" action step the data you have passed wasn't present in your Google Sheets. As a result, it has provided no data in the response whereas, in the "Update Row" action step, you must pass the Row Index which comes from the LookupSpreaSheet action step.

And because of that it has shown the "Required field Row Index missing" message. So as a solution, we recommend you use a filter action step to avoid such conditions which will only run when the "LookupSpreadSheet" action step gets the data.

 

[Mark Francis]

What should I do?

 

[Mark Francis]

I see that you added a filter action step. Should it be does not exist? or does exist?

 

[Pabblymember11]

Hey @Mark Francis

Kindly select "Exist" in the filter type.