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.

Hey All,

 

I am having an issue doing the following. I am trying to get a specific range of cells in column A and the data that representing data of that in column B from Google Sheets. 

 

I have tried “Lookup Spreadsheet Row in Google Sheets” with “Get Many Spreadsheet Rows (Advanced, With Line Item Support)” in Zapier but it is very difficult to get the data from Column B out individually. 

 

The date below starts in row 13 below a table which adds more difficulty to it. Is there a better way to do this?

 

Business Start Date 02/26/2019
Nature of Business

Emergency Medical Services
Credit Score 598
In DataMerch No
Court Records No
Business State TX
Default  
Tax Liens No
Bankruptcies No
Criminal Records No
Credit Utilization 0.00%
UCC's  
Website  

@MohSwellam have you done something similar to this with GoogleSheets? 

Hi @Liz_Roberts , 

 

I havent done something similar in Google Sheets before no, but its definitely doable. 

 

Off the top of my head, you can use the “Lookup Spreadsheet Row” action in Google Sheets, but this means that @4pillarfunding will need 13 actions to look up each of those rows individually. 

 

ALTERNATIVELY, I would suggest that you create those rows as columns so that they all come into 1 row and would be easily searched in one action. 

Thanks for the idea @MohSwellam!

@4pillarfunding do those suggestions help at all? This one is tricky because it doesn’t exactly line up with the typical functionality of Zapier. If not, would you be willing to share with us why you’re setting up this workflow in the first place? Why are you needing to grab that data in that way? Perhaps there are some other steps of your process we might be able to have happen differently to be able to make this part, possible. 

Let us know! 

Terms & Conditions