Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How to search for a specific column in Google Sheets given a successfully found row?

Hi all, 

I have a Zap that submits a student’s homework from Typeform given the custom fields: Full Name and Week #. 

For example, a student Jessica (in cell A18) sends in a homework assignment with the title: Jessica - Week 3. i want the Zap to find Jessica’s row (which it does successfully with the Lookup Row function) and then based on the submission, mark down the Week #  as “DONE” for that particular row. So in this example, Jessica would be marked down as DONE for I18 cell. 

I can successfully find the Google Sheet Row with Jessica’s name on it, however, I cannot dynamically find the column in Zapier to mark down the cell as “DONE”. Does anyone have a workaround for this ?

Thank you! 

 

 

Hey @jarednguyen2000, welcome to the Community! 🎉 

Hmm, perhaps you could use Formatter by Zapier to extract the week number and then use Paths by Zapier to run a update to the specific column based on the week number that was extracted?

I’m thinking that if the assignments always follow the same format of Name - Week Number then you could use a Formatter (Text > Split Text) action to split on the - and return the week and it’s number. Check out our: Split text fields in Zaps for details on how to set up that type of Formatter action. And if you’re not familiar with paths you can learn more about it here: Add branching logic to Zaps with paths

Do you think that sort of approach could work for your needs here? 

Terms & Conditions