• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

google sheet trigger not working automatically

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

Moderator
Staff member
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.
 
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

Moderator
Staff member
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.
 
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

Moderator
Staff member
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.

1684474364305.png
 
Top