How I Built & Automated URL2Drive | From Idea to Digital Product

In this video, I take you behind the scenes of URL2Drive and show how I turned a practical problem into a complete digital product and automated delivery system. The original problem was simple: I had around 45GB of files that I wanted to store in Google Drive, but my upload speed made downloading everything locally and uploading it again impractical. That led me to build URL2Drive — a Google Sheets and Apps Script based tool that can transfer supported direct-download files into Google Drive. But this video goes much further than the product itself. I’ll show you how I brought together several of the tools and techniques covered in previous Tech Articles videos to create a complete workflow for selling, granting access to and delivering a digital product. ⏱️ Timestamps / Chapters 00:00 – The problem that led to URL2Drive 00:28 – Why downloading and re-uploading 45GB wasn’t practical 01:04 – Building the solution with Apps Script 01:39 – Turning the script into URL2Drive 02:03 – Bringing previous projects together into one workflow 02:20 – What the URL2Drive product actually is 02:49 – The static website and product delivery setup 03:19 – Checkout form and automatic Google Sheet access 03:51 – Testing the checkout process 04:25 – Craft form, webhooks and the automation backend 04:50 – Inside the FlowMattic workflow 05:09 – Using multiple webhook triggers 05:36 – OnlySheets and automated Google Sheets access 06:05 – Granting access and Discord sale notifications 06:55 – Email delivery and the purchase workflow 07:25 – Testing a real purchase and access email 07:53 – Confirming Google Sheet access 08:16 – Resetting access for another test 08:47 – The TechArticles redemption workflow 09:26 – Unlocking and redeeming URL2Drive 09:50 – Preventing duplicate claims 10:14 – Confirming redeemed access 10:39 – Storing product claims in user metadata 11:12 – Sending both purchase routes through one workflow 11:41 – Making the system reusable for future products 12:11 – The TechArticles backend setup 12:34 – Sending redemption data to FlowMattic 12:57 – How the webhook grants access 13:30 – Resetting and managing redemptions 14:02 – Subscriber access and off-site product redemption 14:28 – Using multiple triggers in one FlowMattic workflow 14:50 – Combining static sites, payments and a secure backend 15:19 – Turning theory into a real-world product 15:43 – Building a reusable backend for multiple products 16:07 – Expanding the same automation approach 16:33 – From experimentation to production 16:59 – Final thoughts In this video, you’ll see how I combined: • Google Apps Script • Google Sheets • A static HTML website • Bunny.net hosting • An embedded checkout form (CraftForms) • FlowMattic automation • Multiple webhook triggers • OnlySheets for Google Sheet access • Email delivery • Discord sale notifications • TechArticles subscriber redemptions • User metadata for tracking claims • A reusable backend designed to support future products The most important part of this project is that the frontend can remain simple and static while the more complex processing, permissions and automation happen securely behind the scenes. Instead of building and maintaining a completely separate WordPress installation and automation stack for every new product, the same backend can potentially support multiple products and different delivery methods. I utilised AI to write the original HTML, create the thumbnails, and write the video descriptions titles too, all from video transcripts which where also AI generated. This project is also a practical example of taking lots of small automation concepts and combining them into a complete, real-world workflow. If you enjoy practical automation, static-site projects, Google Apps Script and building useful tools from scratch, please like the video and subscribe for more.