• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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.
 
A

Arshita

Guest
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?
 
A

Arshita

Guest
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?
 
A

Arshita

Guest
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