Task-saving Google Sheets functions you need to know

  • 20 July 2020
  • 1 reply
Task-saving Google Sheets functions you need to know
Userlevel 2

Hi y’all! I’m Krystina, a content writer for the Zapier blog. I write about automation tips and tricks using our product.

I know we’ve got quite a few Google Sheets power users in the house, so I wanted to share some helpful in-app functions you can use to save yourself a Zap step. 

I must confess, I am bad at formulas, so anytime I can use something like Formatter to handle something in a spreadsheet, I’ll go for it.

However, if you’re trying to be economical with your tasks, or just want to simplify a complex Zap a little, my colleague Justin wrote about six functions that already exist in Google Sheets. From fixing capitalization errors to fetching data from other Google Sheets, check out these handy functions: 

6 Google Sheets functions that do more than math

1 reply

Userlevel 3
Badge +2

My new favourite is the Query function