Looping through Gsheets to generate individual tickets when a line matches today's date
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.
Page 1 / 1
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.
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!
Yep, I was trying to map variables from the gsheet inside my zendesk action, not from the looped action. Everything is working as needed
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!
@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?
@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
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!
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 
