How can I automate adding new users to a Google Sheet, sending them a product key, and updating the database?

  • 25 July 2023
  • 2 replies

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? 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @saltyseabeard 

Good question.

Check out this help topic:


Userlevel 7
Badge +14


You can search all the public Zap apps here:

Each Zap app has a profile page that lists the available triggers/actions.

e.g. GSheets: