Skip to content
Dave Meindl
  • Home
  • Blog
  • About
    • Privacy Statement (US)
    • Cookie Policy (US)
    • Privacy Statement (UK)
    • Cookie Policy (UK)
    • Privacy Statement (ZA)
    • Cookie Policy (ZA)
    • Privacy Statement (AU)
    • Cookie Policy (AU)
    • Privacy Statement (EU)
    • Cookie Policy (EU)
  • Disclaimer
  • Contact Me
Dave Meindl
  • Home
  • Blog
  • About
    • Privacy Statement (US)
    • Cookie Policy (US)
    • Privacy Statement (UK)
    • Cookie Policy (UK)
    • Privacy Statement (ZA)
    • Cookie Policy (ZA)
    • Privacy Statement (AU)
    • Cookie Policy (AU)
    • Privacy Statement (EU)
    • Cookie Policy (EU)
  • Disclaimer
  • Contact Me

spreadsheets

Service invoked too many times in a short time: urlfetch

March 8, 2024 by Dave Meindl
codes on tilt shift lens

So, you’re working with Google Apps Script. Perhaps you’re working in Google Sheets. You’ve got a long list of URLs …

Read more

Google Sheets to BigQuery: Schedule a Daily Data Transfer for Free

May 3, 2023April 20, 2023 by Dave Meindl
Google Sheets to BigQuery

Suppose you’ve got new data coming in to Google Sheets each day. You want to automatically push this new data to BigQuery each day. How do you do it? I’ll show you.

Google Sheets Formula to Create a Right Outer Join

October 28, 2022 by Dave Meindl
Google Sheets Formula to Create a Right Outer Join

Step by step instructions for recreating the equivalent of a (SQL) right outer join in Google Sheets.

Google Sheets: VLOOKUP with key in any column (not necessarily the first column!)

April 19, 2023November 30, 2019 by Dave Meindl
VLOOKUP with key in any column

Ah, vlookup… So handy. Let’s you get a value from one column by searching for a specific “key” in another column. But you know there’s one thing about vlookup that has always annoyed the hell out of me. (It’s probably annoyed you, too.)

Read more

Google Sheets Formula to Get Column by Name / Label

October 5, 2020November 13, 2017 by Dave Meindl

So, you’re working with Google Sheets and you realize, “Hey, I need to get a specific column. But wait… I …

Read more

Query Google Sheets by Column Name

June 17, 2019April 26, 2016 by Dave Meindl

One of the most handy functions in Google Sheets is the QUERY function. Unfortunately, Google Sheets doesn’t have a feature …

Read more

Categories

  • Data
  • Digital Marketing
  • Facebook Ads
  • Google Analytics
  • Google Sheets
  • Philosophy
  • Search Ads 360

Tags

address adf ads advertising analytics append apps script array arrayformula basics column index column labels column letter column names conditional formatting counta crm data digital marketing facebook filter foundation fundamentals google google sheets index isp domain isp organization join life match multiple ranges network domain principles query sa360 search engine optimization seo service provider sheets spreadsheets sql substitute vlookup xml

Dave Meindl

David Meindl, as Featured in Search Engine Journal
© 2005 - 2025 Meindl Media, LLC