Hello!  

I am developing an online platform. I want to limit access to this platform through the distribution of access codes. I’ve generated 1000 unique codes to distribute to customers. They are documented on a google sheet. Each row in this sheet has the code itself, that status of the code (distributed v non-distributed), the contact of the customer who received that specific access code, and the date it was distributed. Here’s the automation I’m hoping to create:

1. Customer triggers automation by purchasing the access code item in my wix store
2. From the google sheet, an access code from a row that is marked as un-distributed is emailed to the customer.
3. After email is sent, the row that this access code came form is updated to say “distributed”
4. In this same row, the email of the customer and the date it was distributed is now documented in the appropriate cell in this row.
5. An email is sent to me, notifying me that said customer received the specific access code. 

I’m not sure how to set up an automation that searches for a specific cell in the sheet, inserts it into an email, and then sends it to the customer, all while updating the info of the row it just took the code from with the customers contact information and purchase date.

Can anyone help me? 

Thanks!