Best answer

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

  • 13 December 2020
  • 2 replies
  • 26 views

Userlevel 1

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!

icon

Best answer by Kazoo2 13 December 2020, 01:47

View original

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

Userlevel 1

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”. 

Userlevel 7
Badge +8

@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!