Issue In google sheet Integration

[tarunsanty]

I created a flow in which pabbly need to keep eye for a new row added or update.
I setup everything correct If am updateing sheet mannualy I am getting data and test is also passed.
Issue is that Pabbly webhook not getting fired if a nother integration added a new row to sheet, like for now I am getting data into sheet from tally form
How can I get the data from sheet which is added by tally, I don't need to use webhook method as its complicated to manage data, sheet is easy.

Thanks

 

[Preeti Paryani]

Hello @tarunsanty,

To make 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, you also need to enable 'Auto Send on Schedule'.

Note: If your data is being added from an external source/API, your workflow will take up to 1 hour to get triggered.

 

[tarunsanty]

1 Hour is too late, max I wait for data is 5 min. Give me another solution.

 

[Preeti Paryani]

Hello @tarunsanty,

Please refer to this tutorial and thread to trigger the workflow in 1 minute in case data is inserted into Google Sheets from an external source/API - https://forum.pabbly.com/threads/google-sheets-1-minute-trigger.12927/.

 

[tarunsanty]

Thanks for solution, so according to above solution, If I don't want to add last column, will webhook still get triggered and send complete row to webhook. or it must to have last column?

 

[Preeti Paryani]

Hello @tarunsanty,

Please ensure that data is entered into the trigger column of your Google Sheet, as the workflow will not be triggered otherwise. Only the data up to the trigger column will be sent to Pabbly Connect.

For example, if your Google Sheet has eight columns and you have designated the 5th column as the trigger column, only the data from the 1st to the 5th column will be sent to Pabbly Connect when the 5th column is filled in.