This topic was automatically generated from Slack. You can find the original thread here.
Hi all. I need a bit of assistance with a workflow I am trying to achieve please. I am working with a company who are a Shopify application and have been tasked with monitoring install/uninstall events by Users. I have recorded a Loom to try and better capture what I am trying to achieve. I hope it makes sense but please let me know if clarity is needed. Thanks so much in advance 
Hi Max, regarding your data enrichment question - Shopify Partners Events API does not include more information.
Youâll need to query your clientâs transactional database to retrieve more details based on the **.[myshopify.com](http://myshopify.com) domain.
You can do this within workflow as well, by performing a MySQL, MongoDb, or whichever database your clientâs app is using.
Regarding your question about install/uninstall state, that is a design choice. You can use a Google Sheet action to update or create a row if none exists, that way the latest event will overwrite the *Status column value.
Alternatively, you can simply append all events to that sheet, then in a separate sheet within the same book, simply grab the last event as the source of truth.
Hey Pierce. Thanks for the speedy response! Thank you for the advice on the data enrichment part, thatâs good to know and I will query that.
I was slightly confused on your design choice explanation however I hopped back into Pipedream and using your explainer I managed to solve the problem - I think.
I used Shopify App Uninstalls as the trigger. From there I used the âFind rowâ event for G Sheets, looking up entries based on their myshopify.com domain.
I then used an âUpdate cellâ event in order to update that last column âEvent typeâ, whilst using the information retrieved from âFind rowâ whcih gave me the G Sheet row number of the User.
You can see from the screenshot, it shows âZmokieâ installed our application 14th February 2023. However they actually uninstalled 1 hour after hence them being shown in the Uninstalled trigger and now the sheet reflects they uninstalled 
Thanks so much for prompting my brain to discover that solution, I was going round in circles for some reason
I will then do the same, but for date too in a new column (I havenât done this in the screenshot yet)
Great sounds like you found a solution that works for your case. Hopefully it scales with your needs.
I would also recommend reducing the workflows events processing to just a few per minute. You might hit the Google Sheets rate limit quickly with a burst of app events.
