elementor to googlesheet to whatsapp

[avismohitr]

I've integrated an Elementor form on my site https://rremediumspecialitiies.com/appointments, and the form data is successfully being sent to Google Sheets. This automation works perfectly. I've also set up a second automation that uses the same Google Sheet to trigger a message to be sent via WhatsApp using AiSensy.

However, I've encountered an issue: when the data is manually entered into the Google Sheet, the automation works without any issues. But when the data is received through the Elementor form, the automation doesn't trigger as expected. I understand that if changes are made through an external platform (other than Google Forms), the trigger might only be sent once every hour.

How can I overcome this problem and ensure that the automation triggers immediately when the data is added via the Elementor form?

---

This should give you some helpful responses from the forum community.

 

[ArshilAhmad]

Hi @avismohitr,

Although not immediate, you can use App script to reduce the waiting time to 1 minute. To assist you in sending new rows every minute, I have included a link to the relevant thread.

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