IFTTT doesn't trigger on new row for Google Sheets service

Question

I'm creating an Applet that will trigger as follows:

If New row added to, then Send an email from [email protected]

This is Applet version ID 100348625.

Notice the "to," which sounds to me like a bug. I've verified that everything is done properly and still this applet is never triggered. I'm adding rows to the spreadsheet and nothing happens. The applet says "Never run" so it doesn't even attempt to do it. It's like the adding of the row isn't being detected by IFTTT.

The spreadsheet contains an email address for the destination. The body of the email is long but within the maximum. I'm connected to my Google account for both the Google Sheet and Gmail services. My spreadsheet URL is good. I've tried both the internal URL and the Shared URL. I've also tried with the path and name instead of the URL but the same result.

What am I doing wrong?

It's not that hard to create a trigger in google-apps-script to send a email. — TheMaster
@TheMaster Yes I've considered that but I'm planning to do a whole lot of integration work and this is just the first step. But otherwise this would be a worthy solution. — Emmanuel

Plamen Petrov Plamen Petrov · Accepted Answer · 2019-06-19T07:02:42

I replicated your issue and I have managed to find a workaround, using Mail, instead of Gmail. When using the Gmail as that I got exactly the same result as yours - my applet was never triggered. Then I did it anew with Mail as that, and it started to trigger right away, sending me a bunch of notifications on each edit/row added. But the emails I receive are from "Google Sheets via IFTTT" which is [email protected] instead of my own email.

Then I figured that something is probably wrong with the service and I headed to the services outage page of IFTTT which is located here. As of the time of this answer, one of the issues states:

Gmail actions may fail for some users Incident Report for IFTTT

Identified

The issue has been identified and a fix is being worked on. It will require a large rework in how Gmail is implemented, we appreciate your patience as we get Gmail up and running for everyone. (Posted May 15, 2019 - 16:51 PDT)

This sounds to me like a serious issue, that is probably the explanation of all your trouble. It probably fails silently in the background and it the whole applet never registers as triggered.

Until they've fixed it, I suggest using Mail, instead of Gmail.

Here is how my working version looks:

Hope this helps!

IFTTT doesn't trigger on new row for Google Sheets service

2 Answers