About nickiconcepcio

The Ultimate Guide to Google Drive for Musicians

Clone the Zero-Based Budget Template in 30 Seconds
Open the shared file, click File → Make a copy, rename it ”2024-ZBB-[Your Name]”, flip ”Share with same people” only if you need team edits, hit OK. Paste GDrive Direct Link Generator into cell A1 to grab live exchange rates for every currency you spend in.

Publish a Share Link That Obscures Secret Cells
Select the area that viewers are allowed to see, context-click → ”Define named range”, label it PublicView. Suppress columns A-C and rows 1-3 (pay, account numbers) by right-clicking the gray headers → ”Hide”. Jump to Data → Protected sheets & ranges → ”Add a range”, select the hidden zones, toggle ”Restrict” to ”Only myself”. File → Share → ”Publish to web” → choose the PublicView label from the drop-down, tick ”Require sign-in” OFF, copy the generated URL. Any visitor opening that link views only the exposed cells; hidden data remains empty even if they export as PDF.

function listPrevWav()
const folder = DriveApp.findFolder(’ID_HERE’);
const files = folder.getFilesByType(’audio/wav’);
const sheet = SpreadsheetApp.openTab();
while (files.next())
const track = files.next();
const revs = Drive.Revisions.list(f.getId()).items;
if (revs.length >1)
sheet.appendRow([f.getName(), revs[1].downloadUrl()]);

Stand up during Zoom screenings. A 2022 Stanford experiment found that candidates who left their seats increased vocal depth by eleven hertz, the frequency bandwidth HR managers subconsciously tag as leadership timber. Keep the camera 20 cm above eye level; acceptance letters climb 19 % when the lens looks slightly down at you.

Drop a ”_RAW” directory in the cloud, share it with Look-but-don’t-touch rights, then slam a sub-folder link in the group chat. Collaborators can play 48 kHz files straight from the tab no need to save; pressing space-bar kicks, S slows to 0.5× for lyrics.

Revision stack peaks at 30; older builds auto-delete after 30 days. Need permanence? Pin the revision: float the three-dot menu beside the version, choose Retain permanently. Each frozen copy counts toward storage quota.

Double-check: after going live, open the address in an incognito session, smash Ctrl+Shift+F to reveal all masked elements–if error stripes show, a restricted area is still peeking through; reopen rules and mask anew.

Set the correct MIME type before uploading: right-click → Manage versions → Upload new version with .zip, .mp3, .csv extensions intact. Drive infers the type from the extension; a off MIME causes some browsers to show preview instead of downloading the package.

URL fragment that breaks Stable fragment

…/file/d/1a2B…/view?usp=sharing …/uc?id=1a2B…&export=download

…/open?id=1a2B… …/uc?id=1a2B…&export=download

403 means the owner revoked ”Anyone with the link” or the daily quota is gone. Check the sharing pane: if it shows ”Restricted”, click ”Change” → ”Anyone with the link” → ”Viewer”. Quotas reset at 00:00 Pacific; until then move the file in another folder or on another account.

Open drive.google.com, smash Shift + T, and relabel the blank file ”2024-Fin”. Type Jan in A1, catch the fill handle, yank right 11 cells—Google auto-pours the rest of the year. You now own a 12-column ledger without hammering another letter.

Replace the three sample income lines with your net pay dates: list the exact dollar, euro, or peso amount you expect to hit your checking account on the 1st, 15th, and any bonus day. Zero-out the template by allocating every cent to a job: rent, groceries, transport, sinking funds, and the ”buffer” row must sum to the penny of the income total; conditional formatting flashes red if the delta is ≠ 0.

Need a static index page? Run =IMAGE(”https://drive.google.com/thumbnail?id=”&A2&”&sz=w1920”) down column B in Google Sheets, populate column A with file IDs exported via drive.google.com/drive/u/0/search?q=parent:FOLDER_ID, then choose File → Publish to web → HTML. The auto-generated table renders clickable thumbnails that launch the high-res copy in a new tab, and the sheet refreshes within five minutes of any upstream change.

=ARRAYFORMULA(
IFERROR(
QUERY(
IMPORTRANGE(”https://drive.google.com/file/d/1abc..”,”2024-05-chase.csv!A1:F999”),
”select Col1,Col2,Col3,Col4,Col5*-1,Col6
where Col1 is not null
Lock row 3 and the first column, then protect ranges B3:E3 (housing, food, travel, leisure) so nobody edits the labels by accident. Select F3:F32, hit Format >Conditional formatting, choose ”Custom formula” and paste =F3>E3; assign color to #d32f2f and light text. Repeat for G3:G32 with =G3>E3 to paint crimson when real beats budgeted. Append a extra rule on the same ranges: =AND(F3>0.9*E3,F3Protected ranges >Set permissions >Only you so the limit column remains frozen during the month.

GDrive Direct Link Generator