Skip to main content

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!

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


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