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 Everyone

I’m completely new to Zapier and just slowly learning how things sort of integrate into each other.
I’ve been trying to get event information as well as start date and time, number of attendees and total number of tickets to populate into google sheets in real time.

Please see screenshots of the zap I attempted to cobble together and the semi-decent result’s I’ve been getting as well as the issue’s I’ve been experiencing.

I thought maybe I could get details from the new order and populate it into a zap table first and then organise the data in sheets, however this method doesn’t seem to capture all of the details I want.

Please let me know if you require any more in-depth screenshots of any events.

Thanks

 

Zap

Google Sheets Event

 

 

Hi @nocodejay 

For us to have more info about the encountered error, post screenshots showing how the Zap step is configured in EDIT mode so we can see the field mappings.

The Legend Troy Tessone! (I hope to one day become an automation legend like you!)

Hi Troy, I went through a couple of tutorial videos last night on Zapier learning hub and managed to work out the import into google sheets.

I managed to get it to a point where it pulls the data in, however I need to perform a few arithmetic operations when it comes to calculating the total capacity of the event and subtracting attendees to display the total number of tickets left. (My maths is shocking so any input in this aspect would be greatly appreciated!)

Please see updated screenshots of version 4 of my zap as well as the input I now get into google sheets.

(Hopefully you can understand what I’m trying to achieve from the screenshots)

Thanks

 


 



 



 

 

@nocodejay 

Looks like instead of 3 GSheet steps you want to have 2 GSheet steps:

  • Action: GSheets - Lookup Row
    • Enable the checkbox to create row if not found
  • Action: GSheets - Update Row

 

That results in this logic: find/create row + update row

Hi Troy

I also need to it update the tickets left column and calculate the total amount of tickets as each ticket is sold until the last ticket.

So say for example I start of with 250 tickets in the total column and have 10 attendees. I then need to reflect this as 240 tickets left and import this as the total into the next column. I did some research and found that I need to use a loop statement and potentially get it to work as an array, that I’m not entirely familiar with and may need some help on.

Please see updated screenshots

Thanks

 


 

 
 
I entered these numbers in manually to reflect what I’m trying to achieve with the number formatter and loop.

 

@nocodejay 

Are you trying to always create a new row for every Order or find an existing row else create a new row + update an existing row (meaning the row that was found or created)?

I’m trying to create a new row for every order without overwriting the previous one.

Taking into account the new tickets left and total amount into the new row as well...

@nocodejay 

If you are trying to create a new row for each Order, then it seems like you only need 1 GSheet step to Create Row that has output variables mapped from the Formatter steps that perform the math calculations.

That actually makes sense I think.

I did put in the exact same inputs in the update row as well, so I guess I could save a step :)

Hi @nocodejay,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

Reply


Terms & Conditions