Thanks @qdmt for this detailed description - this is wonderful inventive stuff!
Does this setup work with the free tier of Pipedream?
And a little suggestion to simplify the setup a bit: You can schedule a Logicblock run natively in Apilio (which saves you the first IFTTT applet). Here’s the documentation link: