Not able to send data to LSQ

[Bhaskar]

Hi Team,

I am passing on data from Google Sheets to LSQ and it is giving me this error. I have the admin access of LSQ account! Please help!

 

[ArshilAhmad]

Hi @Bhaskar,

Could you please share the Workflow URL where you have this concern?

 

[Bhaskar]

Hi @ArshilAhmad, here is the URL:

Pabbly

connect.pabbly.com

 

[Preeti Paryani]

Hello @Bhaskar,

Could you please share a screenshot of your LeadSquared dashboard showing the lead fields while you are trying to create the lead? In the meantime, we recommend trying the Create or Update Lead with Custom Fields action and let us know if that works for you.

 

[Bhaskar]

Hello @Bhaskar,

Could you please share a screenshot of your LeadSquared dashboard showing the lead fields while you are trying to create the lead? In the meantime, we recommend trying the Create or Update Lead with Custom Fields action and let us know if that works for you.

View attachment 60445

Here you go:

Moreover can we connect on a call to get this done quickly!

 

[ArshilAhmad]

As mentioned previously, please try using 'Create or Update Lead with Custom Fields' action step instead.

 

[Bhaskar]

As mentioned previously, please try using 'Create or Update Lead with Custom Fields' action step instead.
View attachment 60463

Hi Arshil, we have tried this and we were successful but whenever we are adding new value in Google Sheet, it is not fetching the data, what could be the reason?

 

[Preeti Paryani]

Hello @Bhaskar,

Could you please confirm how the data is getting added to your Google sheets?

When entering the data into your Google Sheets, make sure to add the data to your trigger column as well in order to trigger the workflow.

To make your automation work, you need to enable 'Send On Event' if you're manually entering data into your Google Sheets. If the data added to your Google Sheets comes from another API or third-party application. Follow the steps below to set the webhook:

• Log into a single Google Sheets account.
• Open the spreadsheet from where you wish to send data. Make sure your sheet has a header column and at least one row of data in it.
• Navigate to "Extensions" in the Sheets menu and click on "Apps Script" to open the Apps Script editor.
• Remove any existing Apps Script code visible in the Code.gs file. Paste the entire App Script code from this link: Webhook Custom App Script. Save the project and close the Apps Script page.
• Reload the spreadsheet. A new menu called "Pabbly Webhooks" will appear in the menu bar. Click on "Pabbly Webhooks" and select "Send rows every minute".
• Authorize the script when prompted by Google. Once authorization is complete, navigate again to "Pabbly Webhooks" and click "Send rows every minute".
• Enter your Pabbly Connect webhook URL in the dialog box that appears. You can also add the webhook URL and trigger column name separated by a comma. Click "Yes" to confirm the setup.