Skip to main content

Task-saving Google Sheets functions you need to know

  • July 20, 2020
  • 1 reply
  • 246 views
Task-saving Google Sheets functions you need to know
Krystina Martinez
Forum|alt.badge.img

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

Did this topic help you find an answer to your question?

1 reply

Davidh88
Forum|alt.badge.img+2
  • Zapier Expert
  • 58 replies
  • July 29, 2020

My new favourite is the Query function