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.
Best answer by Kazoo2View original
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”.