Hi,
I need help making an automation for our displays that go offline. We are going to have a google sheet that will be getting updated every 3 hours. We would like to create an automated email that goes through our ticketing system (Zendesk) that will send the email to the end user notifying that the display is offline and then if the endpoint is not in the updated google sheet it will automatically close out the ticket in Zendesk. 1. I created a google sheet that will get regularly updated every three hours on when a display goes offline. I have it filtered to pull through the column name “Device Name” that has our device name which is the endpoint ID that we use in Airtable. 2. I added a find my record for Airtable trigger in the zap that with sync the device name to the end point ID in Airtable. 3. I added a Zendesk trigger that creates an offline ticket for the end user to receive an email that their display is offline. I am having problems trying to figure out how to close out these tickets automatically if the device name is no longer on the updated google sheet.
