The workflow does not run even when new rows are added to the spreadsheet.

[hong]

Your Workflow URL

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

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

I set up a workflow from Google Sheets to Asana.
During testing, it works normally, but it doesn't function when actual data is entered.
Why is that?
Notes:
1. The Google Sheet is a shared file.
2. I have full editor permissions for the spreadsheet.

 

[Preeti Paryani]

Hello @hong,

Could you please clarify how the data is being added to your Google Sheet? Is it done manually, through a first-party application (like Google Forms), or via third-party applications?

Additionally, could you kindly share a short screencast of your current Google Sheets webhook setup?

 

[hong]

Hello @hong,

Could you please clarify how the data is being added to your Google Sheet? Is it done manually, through a first-party application (like Google Forms), or via third-party applications?

Additionally, could you kindly share a short screencast of your current Google Sheets webhook setup?

When customers submit a lead form through Meta Ads, the data is received in a Google spreadsheet.
We're using a Make automation tool to connect it.

 

[Preeti Paryani]

Hello @hong,

Thanks for the details. Could you please confirm if you have followed the steps below to add a webhook under the Google Sheets? If not, kindly follow them and let us know if you're able to capture the data under the workflow.

• Log in to 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.