Blogs
on September 25, 2025
Build a 12-month date grid with live week numbers
Add a new tab named YearGrid. In A1 type =ARRAYFORMULA(DATE(YEAR(TODAY()),1,1)); in B1 =A1+1; extend B1 right until you reach 365 cells (366 for leap year). Highlight row 1 → Format → Number → Custom → dd-MMM. Row 2 shows ISO week numbers: in A2 paste ISOWEEKNUM(A1) and drag across. Fix first two rows.
Copy the document hash from the 33-character string that sits between "/d/" and "/view" in the URL field. Paste it at the end of "https://drive.google.com/uc?export=view&id=";. That one-liner becomes a direct-feed URL that leapfrogs the player page and drops straight into the raw MP4, ready for Slack or any embed field that digests HTTPS video.
Row 42 holds the reuse library: 40 text stubs harvested by the XML import from your highest-traffic articles. Each stub auto-slices at 280 characters and tags on a trackable Bitly link that auto-pastes into the matching Facebook column. Set conditional formatting to flag the cell scarlet if the same link appears twice within 7 days–kills accidental duplicates without scrolling.
Launch the original item → Permissions → "Link sharing on" → Read-only role.
Add ?authuser=0 to bypass multi-login conflicts.
If the asset resides inside a corporate folder, move it to a individual folder first; company workspaces often block hotlinking.
Verify server response before pushing to prod:
Switch Google Drive Share Setting to "Anyone with the link"
Secondary-click the file → "Share" → "Change to anyone with the link" → set role to "Viewer" → "Done". The link now ends in /file/d/FILE_ID/view; exchange /view for /uc?export=view&id=FILE_ID to grab a permanent hotlink. No sign-in needed. <a href="http://www.s460554122.websitehome.co.uk/">Direct Link Generator For Google Drive</a>
Throttle guard: wrap the formula in IF(ISERROR(IMPORTDATA(..)),"retry",IMPORTDATA(..)) and limit ten rows max per request. Schedule a 2-minute Apps Script timer to freeze values → insert as text in a parallel range; this freezes numbers for historical comparison and prevents quota overruns (API free tier = 100 calls/day).
Lay links on a Notion page. Thumbnail each at 400 × 300 px, .webp, <70 kB. Title it "Quick Look – 5 Builds" and embed a Calendly widget. Share the URL across ten niche subreddits; 3 % click-through equals three booked calls within two days.
Above the fold: bar sits 16 px below navigation, z-index 999 so scrolling content glides under, not over.
After each objection: insert bar inside a
with 72 px padding-top; this spacing prevents Google CLS penalty.
Cap to five repeats; sixth exposure cut incremental sales 4 % in a Privy sample of 2.3 M sessions.
Link the bar to a checkout modal, not a separate page; every added hop leaked 12 % of users in Stripe’s 2022 checkout report.
2. Social ad: 1080 × 1350 motion graphic for a fictional café. 3-frame loop, 1.5 s cycle, CMYK #4a2c2a → #f5e1c3 gradient. Export as 800 kB MP4. Caption: "$0.08 CPC mock, 3 % CTR forecast." Drop in Google Drive, "anyone with link."
A is publish date, B = story, C = owner, E = target date, F = status. The bit E