Skip to main content
Best answer

Get a piece of data from a spreadsheet to use in a Zap

  • December 13, 2020
  • 2 replies
  • 35 views

Hi! This is my first post and I’m a total Zapier newbie. Hope this isn’t an extremely dumb question!

I’m using Zapier & Google Sheets to automate my kid’s allowance tracking. He gets a certain amount each week, and I’m using Zapier to add a row to a sheet w/ that amount. BUT I’d rather not hard-code the amount in Zapier, but rather grab it from a cell in a different sheet. 

I can’t figure out how to grab a piece of data from a sheet and then use it in my “add row” action.

Thank you!

Best answer by Kazoo2

Never mind! I figured it out! I used the “Lookup row” function and am then able to use the data from that row in my “add row”. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

  • Author
  • Beginner
  • Answer
  • December 13, 2020

Never mind! I figured it out! I used the “Lookup row” function and am then able to use the data from that row in my “add row”. 


Liz_Roberts
Forum|alt.badge.img+8
  • Zapier Staff
  • December 14, 2020

@Kazoo2 welcome to Community! No dumb questions at all- we’re all here to learn :slight_smile: Glad you figured this one out and thanks for sharing the solution!