Hello! I have an app attached to a Google Sheet that contains a unique QR Code (png image) for each person in a list. I have made the QR code scannable and it works to bring up a profile.
I would like to automatically generate an email with the QR code image with text like, โYou are Approved. Here is your unique QR code that will be scanned upon entryโ based on a Yes/No action โCredential Approvedโ.
Here are the steps I have already complted:
- Person submits a form โCredentials Applicationโ (I already have that form generating a QR code and auto-responding that their application has been received).
- I have a column in my spreadsheet with data validation options Approved, NotApproved
- Person on my team reviews applications and selects โApprovedโ or โNotApprovedโ
Need to know:
Based on the Action โApprovedโ generate an email with their Unique QR Code image and some text.
Based on Action"NotApproved" generate an email with text, sorry your application was not approved.
I would welcome any suggestionsโฆ thanks!
LinkedIn
Twitter
