This is an automation I’ve been struggling with for 5+ years, wonder if anyone has any insight.
Here’s the flow (with an example):
My users fill a gravity form denoting their favourite dessert, which then gets updated in a Google Sheet.
I’ve been trying for years to get either a Zapier zap or a Make scenario to do the following:
- Use “Search Rows” to find the person, for example “Mother In Law”
- Then search the column headers to find “Dog Treat”
- Then update the corresponding cell, as marked in the screenshot
Of course, finding the “person” in column A is no problem at all, but I am stymied with searching the column. I attempted to create a data store in the sheet that says “Dog Treat = Column F” but I still can’t update it.
I feel like I might be missing something really small and stupid, anyone have any insight?