• 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 $249 (🏆Lifetime Access) - View offer

Automation Trigger Issue

Your Task History ID
IjU3NmMwNTZhMDYzMTA0MzE1MjZkNTUzYzUxM2E1MTYyNTQzMiI_3D_pc
Hi Everyone,

I am trying to trigger a very basic automation. When someone fills out an inquiry form on my website, that data is captured in a Google Sheet, and I want a welcome message to be sent via WhatsApp, which I have initiated with Aisensy.

The problem is that when that data is entered automatically, automation is not being triggered, but when I fill in the data manually, it triggers. Can someone tell me how to solve this issue?

Thanks.
 

ArshilAhmad

Moderator
Staff member
Please try enabling the 'Auto Send on Schedule' feature in your Google Sheets spreadsheet and see if that fixes your issue.
1717024784184.png


Note: If the data is added to your Google Sheets automatically, it may take upto 1 hour for your workflow to get triggered.
 
Hi,

I tried, but it was still the same. When i fill the row manually it triggers the automation but when i fill the form it dosent.
 

Arshita

Moderator
Staff member
Hey @Jayant Batra

While setting up the Google Sheets, if you are getting the data from a third-party application then you might need to select "Auto Send On Schedule" and "Send on Schedule" which will take exactly 1 hour to forward it.

Also, check whether the data was getting filled till your triggering column or not.
 
Hi @Arshita

I am getting the data from my landing page, and as suggested by @AutoEx i changed the setting to "Auto Send On Schedule" still nothing happened. I have re-filled out the inquiry form and will wait for an hour to see if it happens.

Yes data was filled till the last trigger column, as we have all the filed mandatory for contact form.

Can this issue be in any way related to the contact form we are using? We are using Contact Form 7.
 

Arshita

Moderator
Staff member
Yes, to reduce the trigger interval time from 1 hour to 1 minute, you'll need to add an App Script to your Google Sheet. This script will change the triggering frequency accordingly.

Please refer to the following threads to learn how to set up the App Script in your Google Sheet to trigger it every 1 minute:

Here is the App Script:


You can read this document to understand how you can add the app script to your Google Sheets.


I hope this can be helpful for you. Also, if you use this app script, remember to opt out of the "Send On Event" and "Auto Send On Scheduled" options".
 
Top