lookup not working for bump purchase thrivecart

[lmotech]

Your Task History ID

IjU3NjYwNTZhMDYzMzA0MzA1MjZmNTUzMjUxMzIi_pc

I've just created this workflow that works:
Trigger: Thrivecart - Product Purchase
Action: Google Sheets - Lookup Spreadsheet Rows V2
Action: Google Sheets - Update Row
Action: Lead Connector V2 - Create or Update a Contact

Basically, the premise is that after the Main Product Purchase on Thrivecart, I would need to lookup and update my spreadsheet in Google Sheets and then transfer the a code to GHL via LeadConnector. This works fine.

This is the Task History ID: https://connect.pabbly.com/task/his...=IjU3NjYwNTZhMDYzMzA0MzA1MjZmNTUzMjUxMzIi_pc#

---
Now, I have the same product offered as a bump and upsell. I'm creating a new workflow but Trigger will be: Thrivecart - Bump Purchase. In the first Action: Google Sheets - Lookup Spreadsheet Rows V2 → I'm getting Data not Found

How do I resolve this? Here's the workflow which has the issue: https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTZhMDYzMzA0MzI1MjY0NTUzMzUxMzAi_pc

I just tried with Trigger: Thrivecart - Upsell Purchase and I'm experiencing the same thing as well.

 

[Preeti Paryani]

Hello @lmotech,

Upon checking the workflow, it appears that we’re receiving a “data not found” response. To help us investigate this further, could you please share a screenshot of your Google Sheet, specifically showing whether Column H contains the value “false”?

This will help us better understand the issue and assist you accordingly.

 

[lmotech]

Column H has FALSE listed. So for the action, it will lookup the value "FALSE" then updates that row with Date, Name, Email, TRUE for USED. Then we would be passing the access code to GHL.

 

[lmotech]

Hello @lmotech,

Upon checking the workflow, it appears that we’re receiving a “data not found” response. To help us investigate this further, could you please share a screenshot of your Google Sheet, specifically showing whether Column H contains the value “false”?

This will help us better understand the issue and assist you accordingly.

any update? I posted my reply to to your query above with the screenshot. Thanks!

 

[Preeti Paryani]

Hello @lmotech,

Thank you for sharing the screenshot, and apologies for the delayed response.

To help us investigate the issue further, could you please grant edit access to the Google Sheet in question? Kindly share it with [email protected].

Additionally, we would appreciate it if you could provide permission to access your Pabbly Connect account and make changes if required. You can do so by stating the following in your next reply:

"You have access to my Pabbly Connect account and the Google Sheet. You may make changes if required."

Looking forward to your confirmation.

 

[lmotech]

Hello @lmotech,

Thank you for sharing the screenshot, and apologies for the delayed response.

To help us investigate the issue further, could you please grant edit access to the Google Sheet in question? Kindly share it with [email protected].

Additionally, we would appreciate it if you could provide permission to access your Pabbly Connect account and make changes if required. You can do so by stating the following in your next reply:

"You have access to my Pabbly Connect account and the Google Sheet. You may make changes if required."

Looking forward to your confirmation.

Granted access to your email: [email protected]

You have access to my Pabbly Connect account and the Google Sheet. You may make changes if required.

 

[Preeti Paryani]

Hello @lmotech,

It appears that the issue was due to an extra space in the value "False" being added to the cells. I’ve removed the space, and the action is now retrieving the data correctly.

I recommend ensuring that the value "False" in Column H does not contain any leading or trailing spaces. This should resolve the issue moving forward.

Please refer to the attached image for better understanding. Let us know if you need further assistance.