Is anyone using the IFTTT recipe “Track watering in a Google spreadsheet”? I’ve got this enabled, but I’m not seeing a spreadsheet created/appended when I run my zones (I’ve manually ran a few cycles for some adjustments to my nozzles).
I realize this isn’t an IFTTT forum, but hoping some folks here my have experience with this. I’m new to IFTTT (this is my first time using it), so this may well be something I’ve not set up correctly. Any ideas on what to check?
Perhaps it works only for regularly scheduled watering times, not for manual zone activations?
Hi @franz, I’m not sure it’s working for scheduled runs, either. My regularly scheduled (Thursday morning) watering times ran this morning. This is all I’m left with in the spreadsheet:
@ramblinwreck So I ran a 5 minute schedule and am seeing expected results.
Here is my recipe (write a row to Google Spreadsheet every time a schedule stops). I see the 5 minute duration and the date/time and name of the schedule.
My recipe is pretty much the same (i.e. I used the defaults that came with the recipe). Only thing different is my path, I just have {{DeviceName}} without the “Rachio” directory name above it. But I doubt that’s the problem. In any case, I’ve just changed it to the way you have it and will report back next Thursday when my WTs run again.
Not sure if the complexity of the schedule matters here? I’ve got 2 WTs covering multiple zones each, with Smart Cycle enabled.
Anyhow, this is low priority. I’ll let you know my results after next Thursday’s run. We are on 1-day a week restrictions here in Central Texas so won’t have another chance until then.
(1) None of my Watering Times are named “Every Thursday at 1:00AM” (as shown in above spreadsheet I linked). That texts happens to be what I see below the Watering Time Name on my watering Times page. It’s like it’s pulling from the wrong field. See here:
A thought… On the Watering Time setup page for each of my WTs, I left the NAME field blank. The Iro seems to assign (or at least display) a default name “Water [zones…]” (as shown above). Is this the problem? That is, perhaps I need to assign an explicit name for my WTs in order for this recipe to work, rather than relying on the default name that Iro is showing? Maybe this causes the recipe to grab the wrong field/string since the NAME field is blank? I had assumed it would use the one Iro is showing me, but maybe a bad assumption.
(2) I have two WTs (shown above) that ran this morning, yet only one entry in the spreadsheet. I was expecting two entries in the spreadsheet, based on the “this trigger fires every time a watering time stops…” description for the recipe. The 40 minutes figure in my spreadsheet corresponds to my 2nd watering time. This suggests that either no entry was created for the first one, or one was created for the first one, but was then overwritten by the second one. Maybe this is because it thinks the name for both of them is “Every Thursday at 1:00AM”?
I’ll add an explicit name for both my watering times. I’ve got a feeling this will fix the problem. Will confirm next Thursday.