Skip to content

Google Sheets

  • gspread - Python module for interacting with google spreadsheets


Conditional Formatting

Regex matching to color

Colorize rows with conditional formatting by using an expression like this:

=REGEXMATCH($E:$E, "some_regex")

This regex is not anchored, so there is no need to prepend or append .*

Cell references in this case are relative unless prepended by a \$. So, if you want to match the cell you are working on you would use A1:A1.

Color every other row


Import an RSS feed


Sum lines that match a string

This uses syntax similar to a glob search, but uses ~ instead of \


Automatically resolve the DOW from a date

=CHOOSE( weekday(A4), "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat")