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.

Best answer

Looping through Gsheets to generate individual tickets when a line matches today's date

  • June 10, 2025
  • 8 replies
  • 75 views
M

I’m trying to loop through multiple data requests to generate individual Zendesk tickets only when the “Request Date” column matches today’s date. I’ve tried several approaches but haven’t been successful in creating separate tickets for each matching row.

 

I’ve chosen the “Lookup Spreadsheet Row” action because it allows me to define the content of each ticket. In contrast, using “Get Many Spreadsheet Rows (Advanced)” returns all rows with today’s date combined into a single ticket, which isn’t what I want.

I previously had a looping step before the zendesk step - but removed it so it doesn’t show in the image attached.

Best answer by Troy Tessalone

Hi ​@Michaelashley 

Try these Zap steps:

  1. Trigger: Schedule - Daily
  2. Action: Formatter > Date & Time > Format
  3. Action: GSheets - Lookup Rows
  4. Action: Looping - Create Loop from Line Items
    1. Map variables from the GSheet step
    2. Help: https://zapier.com/apps/looping/integrations#help
  5. Action: Zendesk - Create Ticket
    1. Map variables from the Looping step

 

If you need help, there is a directory of Certified Zapier Experts: https://zapier.com/experts

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

8 replies

A
Forum|alt.badge.img+2
  • Adil WaqasBeginner
  • Beginner
  • 58 replies
  • June 10, 2025

I can absolutely help with this. I’ll set up a loop that checks each row in your spreadsheet for today’s date and creates a separate Zendesk ticket for each match, exactly as you need. I’ll make sure the content is mapped correctly from each row, and that the process runs cleanly without combining the data into a single ticket.

Let’s get this working the way you intended!

Let’s connect for a quick call to finalize the details:
📅 --Details removed by moderator--

You can also review my Upwork profile and client feedback here:
🔗 --Details removed by moderator--

This post has been edited by a moderator to remove self-promotional links that direct members to external websites. To ensure transparency and promote knowledge sharing, we encourage all discussions and resources to stay directly within the community.

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34072 replies
  • Answer
  • June 10, 2025

Hi ​@Michaelashley 

Try these Zap steps:

  1. Trigger: Schedule - Daily
  2. Action: Formatter > Date & Time > Format
  3. Action: GSheets - Lookup Rows
  4. Action: Looping - Create Loop from Line Items
    1. Map variables from the GSheet step
    2. Help: https://zapier.com/apps/looping/integrations#help
  5. Action: Zendesk - Create Ticket
    1. Map variables from the Looping step

 

If you need help, there is a directory of Certified Zapier Experts: https://zapier.com/experts

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9736 replies
  • June 17, 2025

Hey there, ​@Michaelashley 👋

How did you get on with the setup Troy suggested? Did it do the trick, or did you get things solved by reaching out to a Zapier Expert?

Keen to make sure you’re all set, so please keep us posted on how it’s going! 🙂

M
  • MichaelashleyBeginner
  • Author
  • Beginner
  • 3 replies
  • June 17, 2025

Yep, I was trying to map variables from the gsheet inside my zendesk action, not from the looped action. Everything is working as needed 🙏🏻

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 9736 replies
  • June 18, 2025

Yay! That’s awesome news, ​@Michaelashley! 🎉 So glad everything is working now. Thanks so much for circling back in here to confirm what the solution was. And big thank you to ​@Troy Tessalone for helping out here! 🙌

Please do reach back out if we can help with anything else. In the meantime, happy Zapping! ⚡

M
  • MichaelashleyBeginner
  • Author
  • Beginner
  • 3 replies
  • June 23, 2025

​@Troy Tessalone Hopefully you can help again!

My zap went live ready for today, however, it only returned the first line that matched today's date, rather than looping back through the sheet to return the rest (around 50 lines).

Did I miss something in my set-up to ensure that all lines with today’s date creates a new ticket?

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • 34072 replies
  • June 23, 2025

​@Michaelashley 

For us to have full context we would need to see screenshots with how the Zap step are configured in EDIT mode with the field mappings visible.

 

Zap action: GSheets - Lookup Spreadsheet Row

Field: If multiple search results are found

Value: Return all results as line items

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Authorized Zapier Solution Partner | #1 Zapier Community Contributor
M
  • MichaelashleyBeginner
  • Author
  • Beginner
  • 3 replies
  • June 23, 2025

I think this might be it! I was sure I’d updated this already, but must have removed it when editing the zap. Hopefully this work for tomorrow!

🙏🏻

Terms & ConditionsAccessibility statement