Pro Tips

Open Google Docs/Sheets, etc. without owner knowing you’ve done so.

If you want to open a shared Google Drive file without the owner seeing that you’re in the doc, you can just make a copy of it rather than opening the actual doc. To do this, copy the link of the shared file, paste it into your browser’s address bar, and change the “/edit?…” part at the end to “/copy”.

Replace everything after the last slash with “/copy”

Google will prompt you with a blue “Make a Copy” button. Click it, and you’ve got your own copy of the file that you can peruse without the owner knowing you’ve accessed it.


Link to a cell or range in Google Sheets

You can link to a cell or range by selecting the range, right-clicking, select “More cell actions” and select “Link to this range.” Alternatively, just add “&rangeA3:B7” to the end of the sheet’s URL:

https://docs.google.com/spreadsheets/d/19Cw1wEVH9jQtSiFjEhq-6jEfH7Jkk6kN14cynI2ZSk4/edit#gid=0&range=A3:B7

Mount a remote ssh folder locally

You can mount the remote directory with sshfs which gives you easy access to all the files. E.g.:

sshfs user@server:/directoryToMount /localDirectory

Find all triggers set up for your Google Apps Scripts

It took me the longest time to figure out how to locate all the Google Apps Script triggers I had attached to various sheets, docs, and forms. Turns out it’s the simps; you just visit:

https://script.google.com/home/triggers

Leave a Reply

Your email address will not be published. Required fields are marked *