Hi @Nelson!
Generally speaking, I’m not sure I’d recommend storing license keys in Google Sheets, much like passwords, as it’s not the most secure way of doing it. But for the sake of helping you out with the workflow here’s how you could accomplish that in a Zap:
Trigger (when this thing happens): Stripe — New Charge or New Order
Action (then do this other thing): Google Sheets — Lookup Spreadsheet Row
Action: Send Email (not sure which email app you had in mind...here’s a list of transactional email apps: https://zapier.com/apps/categories/transactional-email or regular email: https://zapier.com/apps/categories/email)
Action: Zoho CRM — Create/Update Module Entry
What would you use for the lookup in Google Sheets, do you know? Is it a list of available keys and you want to go through them sequentially and then mark them as used? If so, you could use a column like Available with true or false in it and search by available. Then you’d need an Update Row step for Google Sheets to update the row you found and make the Available column false.
Does that help at all? Please let me know if you need help with anything!