Hi folks, brand new to Zapier but I can’t wait to see it work its magic! 

I have the following situation I’m hoping to automate:
- I have a spreadsheet for new users that is auto-filled by a Google Form (first name, last name, etc). When a user’s details appear as a new row, there is a blank column for product key.

- In another worksheet (inside the same Google Sheet), there is a list of product keys

- When we add a user to the database, we cut a product key from that worksheet and paste it into the main worksheet in the product key column

- We then compose an email to the user with their first/last name, the product key, and redemption instructions. 

- Finally we add their user account details to our database with an SQL insert query.

What I’d like to do here is automate the above workflow (if possible) as follows:
New row appears in spreadsheet → Cut the last product key in the column from the product keys worksheet → Paste that key into the correct column in the main worksheet → Compose an email using data from that user row → Send an SQL insert command → Update the “product key sent” column with “Y" in the main worksheet

Is all that possible?