Bay Snaps

Stars over Lake Tahoe

Updated on Saturday, February 19, 2022

Timelapse of stars over Lake Tahoe, California

4K timelapse of stars and the Milky Way over Lake Tahoe, California.

(Related: Sugarloaf Stars and Milky Way; Lake Merced; Milky Way and stars over Redding)

(You might also like: Mariposa Loop; San Francisco Shoreline Timelapse; Lake Merritt)

(More Timelapses)

Email Alerts for new Referers in Google Analytics using Apps Script

Updated on Saturday, February 12, 2022

Referral Traffic in Google Analytics

It's useful to know when you have a new website referrer. Google Analytics is plagued with spam referral and you want to filter this out of reporting as quickly as possible to stop it from skewing your data. It's also helpful to be able to respond quickly to new referral traffic - maybe leave a comment or promote the new link on social media.

The script below will send you a daily email with links to any new referrers.

Start a new apps script project in Google Drive and paste in the code. At the top enter the view ID that you want to monitor and the email address that should receive reports.

Choose Advanced Google Services from the Resources menu and switch on the Google Analytics API. Then click the Google API Console link and enable the Google Analytics API there as well.

Finally pick Current project's triggers from the Edit menu and trigger the main function daily at a convenient time.

This script saves known referrers in script properties. For a site with lots of traffic this may run out of space in which case you might need to switch this out and write known referrers to a sheet instead.

More Google Apps Script Projects

(All Code Posts)

Reading and Writing Office 365 Excel from a Console app using the Microsoft.Graph C# Client API

Updated on Sunday, September 18, 2022

Read and Write Excel from Microsoft Graph

I needed a console app that reads some inputs from an online Excel workbook, does some processing and then writes back the results to a different worksheet. Because I enjoy pain I decided to use the thinly documented new Microsoft.Graph client library. The sample code below assumes that you have a work or education Office 365 subscription.

Paste the code into a new console project and then follow the instructions at the top to add the necessary NuGet packages. You'll also need to register an application at You want a Native application and you'll need the Application ID and the redirect URL (just make up some non-routable URL for this). Under Required Permissions for the app you should add read and write files delegated permissions for the Microsoft Graph API.

Hope this saves you a few hours. Comment below if you need a more detailed explanation for any of the above.

(Related: Using the Azure Monitor REST API from Google Apps Script; Monitor page index status with Google Sheets, Apps Script and the Google Search Console API; Automate Google PageSpeed Insights and Core Web Vitals Logging with Apps Script)

(You might also like: Stars over Pinnacles; Path; Nesting Ospreys)

(All Code Posts)

Point Reyes Deer

A deer at Point Reyes

A deer on a treacherous cliff-top path at Point Reyes.

(Related: Recent Wildlife; Point Reyes - Tomales Point; TLOTW #6)

(You might also like: Drones and Gun Control; Cable Car Museum; Sand on Great Highway)

(Recent Photos)

Host change

Updated on Wednesday, June 28, 2017

Point Reyes Lighthouse

Updated on Sunday, May 3, 2020

Summer Solstice 2017

Spherical Sunset

Updated on Saturday, February 19, 2022

Spherical sunset timelapse 360 degree video

An experimental spherical timelapse of a sunset looking west over the Pacific from West Portal, San Francisco.

In your browser use w, a, s, d to tilt and pan. Best viewed in a VR headset.

Shot on the Richo Theta S, post processed with Lightroom, LRTimelapse and FFmpeg.

(Related: Sunset #6; San Francisco Shoreline Timelapse; West Portal Mosaic Timelapse)

(You might also like: Pinnacles National Park; #Resist; Sod Searle And Sod His Sodding Room)

(More Timelapses)

Book reviews for May 2017

Change Agent by Daniel Suarez

Change Agent by Daniel Suarez


Stonking near future bio thriller.


(Related: Mission:Explore Food - Crowd Fund It!; #Resist; Full Outlook Web Access on Chromebook)

(You might also like: Coronavirus Hikes: Done; Procyon lotor; Finally Gmail)

(All Book Reviews)

I Thought He Came With You is Robert Ellison's blog.