How to

Writing to temporary storage in a Google Cloud Function using Node JS

Here’s a quick example on how to do this. I recently had to store an intermediary response before shipping the data off to another resource (API to BigQuery) and wanted to take advantage of BigQuery’s free loading versus streaming. From the Google docs, “The only writeable part of the filesystem is the /tmp directory, which …

Writing to temporary storage in a Google Cloud Function using Node JS Read More »

Did it update? Playing with Google’s new Indexing API and getting pages crawled immediately

Google’s new Indexing API support page say “it can only be used to crawl pages with either job posting or livestream structured data”, but of course I was curious and it turns out that we can get regular pages crawled as well, and damn fast. Google’s indexing API for livestream and job postings (posted Dec …

Did it update? Playing with Google’s new Indexing API and getting pages crawled immediately Read More »

How to check if value is in range of cells – Solution – Google Sheets

One of the most useful formulas for me was being able to find if a cell contained a value from a list of items, this excellent Excel formula https://exceljet.net/formula/cell-contains-one-of-many-things was exactly what I needed. The formula: =SUMPRODUCT(–ISNUMBER(SEARCH(things,A1)))>0 also works in Google docs, provided that you created a named range. Here is the spreadsheet for you to look …

How to check if value is in range of cells – Solution – Google Sheets Read More »

How to get Google’s cached copy of a page and text version with parameters

If you can’t get the cached version the good old fashioned way by typing cache:www.example.com into Google search for some reason (other than the page not being indexed or having the noarchive tag), use this URL: https://webcache.googleusercontent.com/search?q=cache:https://www.example.com If you want the text version of the cache, add &strip=1 to the end like so: https://webcache.googleusercontent.com/search?q=cache:https://www.example.com&strip=1 

How to combine server logs (all files) using Windows command prompt

For SEO purposes, we typically have to analyze server logs to understand what the heck robots are actually doing on our site – sometimes, you’ll get a bunch of individual files from your hosting company, which makes getting all of the data needlessly laborious. For those of you Windows fans, this is how you can …

How to combine server logs (all files) using Windows command prompt Read More »

Google Language & Country code reference sheet

This post is in addition to my previous post on Distilled and simply provides an online Google Docs version of Google CCTLDs and language codes used by Google. If you see any errors, please let me know in the comments and I’ll happily credit you with a link 🙂 The sheet URL is here.  

Count characters in a cell without spaces – Excel & Google docs

By using =Len() you’re going to return the character count including spaces by default. Example: =len(“hey there”) This formula will return 9, this is because there’s a space between “hey” and “there”. Here’s the formula to get character count without spaces: =len(SUBSTITUTE(“hey there”,” “,””)) This will return: 8 How does this work? By nesting the …

Count characters in a cell without spaces – Excel & Google docs Read More »

Scroll to Top