• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Google Sheet Send on Event Not Working

Status
Not open for further replies.

nazmo13

Member
I have leads coming from facebook to a gsheet and then going to High Level. I went through the Pabbly Extension 'Initial Setup' and the webhook worked -the data flowed to high level. I then switched the gsheet extension to 'Send on Event' and now the data is not flowing to high level?
 

ArshilAhmad

Moderator
Staff member
Hi @nazmo,

Based on the workflow you have shared, it seems like you haven't set up your Google Sheets trigger step as I couldn't see any response. Please follow the steps given in the video attached below to understand how you can set up your Google Sheets trigger event.
1692398584856.png

Only the first half is relevant to your use case:
 

nazmo13

Member
Hello, I reviewed the video and I have done all of that I believe - attached is a screenshot of my workflow - thanks!
Screenshot 2023-08-19 at 12.55.38 PM.png
 

ArshilAhmad

Moderator
Staff member

Based on the workflow you have shared, I can see that you still haven't set up your Google Sheets trigger step. Please follow the exact steps given in the video shared above to setup Google Sheets as your trigger and capture the response.
1692473395952.png


Make sure to click on the "Send Test" button, as shown in the video at 2:29.
1692473651246.png


 

nazmo13

Member
Hi - thank you. I went ahead and reinstalled everything and started over. It looks to be working now. However in my 3rd step I am getting the attached error from LeadConnector 'Can not create duplicate opportunity for the contact'. In step 2 I am creating/updating a contact. So I am confused about why it says duplicate opportunity when an opportunity is not being created in step 2? Thank you!
Screenshot 2023-08-20 at 4.48.33 PM.png
 

ArshilAhmad

Moderator
Staff member
In the 'Create Opportunity' action step, enable the Contact ID mapping button and then proceed to map the Contact ID from step 2. Additionally, make sure to enter the Stage ID instead of the Stage Name. Make a test submission and let me know if this fixes the issue for you.
1692573546156.png
 
Status
Not open for further replies.
Top