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?
