google sheet trigger not working automatically

[aj_yogilab]

Your Task History ID

https://connect.pabbly.com/task/history?filter_status=applied&filter_by_workflow_id=IjU3NmQwNTY4MDYzMjA0MzA1MjZmNTUzNyI_3D_pc

Hey, I've created the automation to fetch data from google sheet whenever any row's cell updated. but the problem is it's not triggering automatically, everytime i've to do 'send all data' then it sends all data, this way i lose purpose of automation + my connects. so please help me, it's not working on one hour schedule too.

 

[Arshita]

Hey @aj_yogilab

Could you please confirm whether the response in the Google Sheet is coming from a third-party application or if you are manually entering the data directly into the sheet?

Also, please let me know if you are updating the trigger column in the sheet.

 

[aj_yogilab]

Hey @aj_yogilab

Could you please confirm whether the response in the Google Sheet is coming from a third-party application or if you are manually entering the data directly into the sheet?

Also, please let me know if you are updating the trigger column in the sheet.

3rd party application enters it.

Should the trigger column be changed?

 

[Arshita]

I would like to inform you that If you are entering the data into the Google Sheet manually then you need to set up the Google Sheet extension to "Send On Event" and if the data is coming from a third-party application, however, you may need to choose "Auto Send On Schedule" and "Send on Event," both which will forward the data in exactly one hour.

Also, in order to trigger the Google sheet you need to update a trigger column.

 

[aj_yogilab]

Ok, right now, i've setup the trigger on column "k", does it needs to be last one in the sheet or do you have any other suggestion to make it working?

 

[Arshita]

Yes, you are correct.

If you want to trigger column K, you must enter the correct column in the trigger column while setting up the sheet. It should be the last filled column of the sheet.

For example, if you have 3 columns A, B & C, then you have to enter the C in the trigger column to trigger the workflow. If you are expecting to get the data after column C for eg D, E, and F then these columns will not fetch any data.