Particle to IFTTT to Google Sheet integration missing

[blshaw45]

Several years ago I created a Photon-based app for a neighbor who wished to monitor the water level in his residential 1000 gallon water storage tank. The application populated a Google sheet via IFTTT. Worked great. Then he sold his house 4 years ago. The new owner just contacted me to ask how to get the system back in operation (he had implemented a new WiFi network and the Photon knew nothing about its credentials).

In my efforts to resuscitate the system I verified that the associated Particle account is still active as is the Google sheet account, but the IFTTT account, while still in existence, had been deactivated (probably due to the inactivity). I updated the WiFi credentials on the Photon.

Now I am trying to get IFTTT back in operation but the applet I had created for the purpose has disappeared. I seem to recall that IFTTT used to have an applet type “Particle” but I can’t find it now. Nor can see anything in the Particle account’s Integrations or anywhere else that explains how I got the incoming data from the Photon passed onward to IFTTT. I am almost certain that I did not use a Webhook at that time.

Can anyone help me recall how this would have been set up back in the “old days” and whether I can recreate the earlier scenario? I’d like to avoid a new Webhook using a JSON payload since IFTTT now requires an expensive “Pro” account to support that approach.

[gusgonnet]

Hey, after the deprecation of IFTTT:

IFTTT Deprecation Notice

Thank you all for building cool things with Particle! Unfortunately, as Particle grows we have to reevaluate our integrations so we can maintain quality across the board. As such, Particle is discontinuing IFTTT support, effective the week of Aug 29, 2022. Particle is committed to an excellent user experience. While you will no longer be able to run your applets through the Particle integration, you can use the Webhook integration to keep your Applets running smoothly with Particle Devices. Pl…

They mentioned that Zapier is a choice:

Zapier | Integrations

Another option that came out was this:

Publish to Google Sheets | Integrations

Best,

[blshaw45]

Wow; how did I miss that?? But thanks, Gus, for the heads up! I will check the Webhooks options.

[PaulAugood]

I am currently using the publish to google sheets integration to record daily data to a google sheet - for a novice the tutorial was very easy to follow.

[blshaw45]

Thanks Paul; I have it working flawlessly. I just wish there was a way to delete old rows from a sheet to prevent it from reaching the 2000 row point that results in the automatic creation a new sheet. For example, in my particular application, I’d like to delete - upon every newly-arriving post - any entry with a time stamp older than 48 hours.