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.

Hi,

We run weekly events and I need to record the amount of visits. We are currently using Eventbrite and excel or gsheet would be the logical choice.

 

Is it possible to create a zap that on check-in will reference the name in an existing spreadsheet located on either sharepoint\onedrive and increase the “visited” row by 1?

Thanks for any help.

Hey there, @Paukl! Thanks so much for reaching out. 🙂

Hmm, since we don’t currently offer a Sharepoint app and OneDrive wouldn’t support this workflow it sounds like the only way this would work is if you’re using Google Sheets or Excel.

A rough outline might look something like this though:

  1. Eventbrite - New Attendee Check-In trigger
  2. Google/Excel Sheets - Find Row (search on name of event or row which includes # of visits)
  3. Formatter - Perform math operation action (take # of visits from previous step + 1)
  4. Google/Excel Sheets - Update Row (update # of visits from output of Formatter step)

I hope this is helpful! Keep us posted how this works out for you! 

 

Thank you Christina. I will give it a shot.

 

Thanks again

 

Paul

Struggling to use this with excel.

Because Eventbrite saves First Name and Last Name, last name seems like the best column to lookup in excel. We have family members attending so there will be multiple exact last names. I can’t seem to find a way to lookup multiple columns. 

In its current format, Find Row simply finds the first matching row.

How can I perform an AND operation and lookup two columns to match Eventbrites First Name, Last Name fields.

Due to having no control over Eventbrite I have no other alternative for a unique identifier and ensuring the correct persons attendance counter is being updates.

Any help would be much appreciated

Paul

Hi @Paukl!

The Excel Find Row action only lets you search by one column, so I don’t think you’ll be able to do what you need using that. If you’re able to switch to Google Sheets, that allows you to search using two columns:

That would allow you to look up attendees based on a first and second name. Would that work for you? Thanks!

Hi,

This worked perfectly for me. 

Thanks

 

 

Yay, @Paukl! So glad you were able to get this sorted! Thanks for keeping us updated on your success.

I’ll pop the ultimate solution below in case it’s helpful to anyone following along. 🙂:

...we don’t currently offer a Sharepoint app and OneDrive wouldn’t support this workflow it sounds like the only way this would work is if you’re using Google Sheets or Excel.

A rough outline might look something like this though:

  1. Eventbrite - New Attendee Check-In trigger
  2. Google Sheets - Find Row (search on name of event or row which includes # of visits)
  3. Formatter - Perform math operation action (take # of visits from previous step + 1)
  4. Google Sheets - Update Row (update # of visits from output of Formatter step)

 

The Excel Find Row action only lets you search by one column, so I don’t think you’ll be able to do what you need using that. If you’re able to switch to Google Sheets, that allows you to search using two columns:

That would allow you to look up attendees based on a first and second name. 

 

Terms & Conditions