Automation Trigger Issue

[Jayant Batra]

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.

 

[AutoEx]

Enable "Auto send on schedule" in your Google sheet.

 

[ArshilAhmad]

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

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

 

[Jayant Batra]

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]

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.

 

[Jayant Batra]

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.

 

[Jayant Batra]

Hi,

I got the message exactly after 1 hour. Is there any way to speed up to instant?

 

[Arshita]

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:

Google Sheets (1 Minute Trigger)

Copy and Paste the entire Apps Script code in your Google Sheets App Script. No need to change anything in the code. Make sure that you copy and paste the entire code as it is. Full Tutorial here...

forum.pabbly.com

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

Google Sheets (1 Minute Trigger) Send New rows in every 1 minute.

In this tutorial, we will see how can you set up Google sheets trigger "New or Updated Spreadsheet Row" in Google Sheet so that you can capture data every minute. Please note: We also offer a Pabbly Connect Webhooks addon for Google Sheets. The current limitations of the Google Sheets trigger...

forum.pabbly.com

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