About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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
  • Using lookup rows to pull X data from one Google Sheet, mark those rows as complete and put that data in a single cell on another sheet
Best answer

Using lookup rows to pull X data from one Google Sheet, mark those rows as complete and put that data in a single cell on another sheet

  • 14 January 2023
  • 6 replies
  • 83 views
J

Hey Community,

I have a client who is selling tickets for a raffle, because of legal reasons he is given codes associated with each ticket and the purchaser needs to recieve those codes.

Essentially so far I am using a CRM connected to stripe for the purchasing of the tickets, I am then wanting to pass that data to a single row in spreadsheet 1 (name, phone, email, address AND MOST IMPORTANTLY - QTY of Tickets).

I am then wanting to use the QTY of tickets value to select X rows from spreadsheet 2 (the spreadsheet that contains the codes). I then want to pass all of this data (name, phone, email, address, QTY of Tickets) to spreadsheet 3 along with a newly updated SINGLE cell that contains all of the ticket codes.

From here I can pass that to our CRM as a custom field and have it sent to the purchaser.

Question 1. how would I achieve grabbing X qantity of rows and passing it to a single cell on spreadsheet 3
Question 2. how would I then mark those codes as complete to ensure the zap doesn’t grab the same codes?

Any help would be appreciated.

icon

Best answer by Troy Tessalone 15 January 2023, 01:28

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Jpehrson 

Good question.

Try using one of these Zap actions for GSheets for the search:

 

 

Try using this Zap action for GSheets for the update:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

Thanks Troy, still having a bit of trouble - maybe it will help if you took a look at this Loom recording.
https://www.loom.com/share/a289756137df408d9b712bb3e848f571

Troy Tessalone
Userlevel 7
Badge +14

@Jpehrson 

You’ll need another column on this GSheet worksheet that indicates if the Ticket Code has been used or not.

For example: Used with a default value of NO, then it would be updated by the Zap to YES.

That way you can use the GSheet Lookup Rows action and search by NO to get the # of desired codes.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

You are a god, it worked! One final question, is there anyway I can pass the following data to include a space after each comma?

 

J

I am trying to use this but the final result isn’t quite working out.

 

Troy Tessalone
Userlevel 7
Badge +14

@Jpehrson 

Try first using a Formatter > Utilities > Line Items to Text

Then you can replace the , with a [:space:]

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions