{"id":"dcd76f97-d238-4619-82e5-99bf69f060cc","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets","description":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets is aimed at specialists and managers aged 25–44 who need a structured upgrade they can apply quickly at work. Across 9 lessons and about 22 hours, the course focuses on course orientation and outcomes, foundations and working vocabulary, and API design; the capstone is an automation scripts pack built with Apps Script and GitHub Actions.","contentLanguage":"en","coverUrl":null,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.481Z","durationSeconds":79200,"authorId":"971bd9f0-d9a9-4020-ac14-5daa82b5b676","rating":4.313432835820896,"reviewCount":67,"expectedLessonsCount":9,"trailerUrl":null,"faq":[{"answer":"A minimal base is recommended, but the opening block still aligns terminology, tools, and expectations before practice.","question":"Do I need prior experience?"},{"answer":"A comfortable pace is 4–6 hours per week. In total, the course includes 9 lessons and about 22 hours of guided work.","question":"How much time should I set aside each week?"},{"answer":"You will finish with an automation scripts pack plus reusable materials built around Apps Script and GitHub Actions.","question":"What will I finish the course with?"}],"learningOutcomes":null,"requirements":null,"levels":["advanced"],"firstLessonFreePreviewEnabled":false,"certificateEnabled":true,"isPlatformCourse":false,"pricingTiers":[{"id":"standard","name":"Standard","price":109,"features":[],"highlighted":true}],"minPricingTierPrice":109,"bonuses":[],"status":"READY","archivedAt":null,"categoryId":"8e0aeee0-d6ea-4986-8984-0456bf39b9b8","lessons":[{"id":"42772166-acfa-477a-a619-95737f541134","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — course orientation and outcomes","description":"Lesson 1 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through course orientation and outcomes and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":0,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"7a918c3f-94d0-4160-884e-dd3118197ced","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — foundations and working vocabulary","description":"Lesson 2 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through foundations and working vocabulary and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":1,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8904330c-9c3d-4585-9a1a-50c8baf1bcd2","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — API design","description":"Lesson 3 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through API design and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":2,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0ee947c3-5dda-4b7e-92d0-6279d101da20","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — next-step roadmap","description":"Lesson 4 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through next-step roadmap and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":3,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"5ad99d6e-0b14-4e8e-8b12-91359e8ce246","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — deployment flow","description":"Lesson 5 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through deployment flow and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":4,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"0458f85d-20bb-48af-8b7f-ba22be7925ac","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — quality, review, and risk control","description":"Lesson 6 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through quality, review, and risk control and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":5,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"f8ee52e5-a635-4eaf-853b-118328de35ae","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — portfolio packaging","description":"Lesson 7 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through portfolio packaging and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":6,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"8e48ef98-62c9-4191-b552-db7080898f52","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — handoffs and documentation","description":"Lesson 8 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through handoffs and documentation and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":7,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null},{"id":"232396b7-128c-431c-98bd-6c4ccab89ef0","title":"Automation with Google Sheets and Apps Script: Residency — Research to Production Assets — debugging routines","description":"Lesson 9 of 9 in Automation with Google Sheets and Apps Script: Residency — Research to Production Assets: work through debugging routines and convert the result into a reusable part of the final automation scripts pack using Apps Script and GitHub Actions.","videoUrl":null,"videoFileName":null,"duration":8800,"position":8,"createdAt":"2026-05-26T07:50:14.316Z","updatedAt":"2026-05-26T07:50:14.316Z","courseId":"dcd76f97-d238-4619-82e5-99bf69f060cc","attachments":null,"dripDelayDays":null,"isFreePreview":false,"previewStartSeconds":0,"previewEndSeconds":null,"prerequisiteId":null,"unlockAt":null,"availablePricingTierIds":null}],"author":{"id":"971bd9f0-d9a9-4020-ac14-5daa82b5b676","name":"Benjamin Lane","avatarUrl":null,"bio":null,"socialLinks":null,"isPlatformRepresentative":false},"hasTeamOffer":false,"teamOfferSummary":null}