GHL TO SPREADSHEET WONT FETCH DATA
Status: Closed · Asked by Mark Francis on · 0 views
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 (
youtube.com/watch?v=T_IKCubDNfU
)This is the error : Required field Row Index missing
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.
What should I do?
I see that you added a filter action step. Should it be does not exist? or does exist?
Hey @Mark Francis
Kindly select "Exist" in the filter type.
