Interested to know if I can do this with Activepieces and is it hard for non-techie like me:
Automated gift code sendout using google mail and google sheet
- Set Up Trigger:
- Set up automation to trigger when a message containing the text “yes please” is received.
- Check Email Address:
- Upon activation, first check if the email address is already recorded in the Google Sheets document. If it is, terminate the automation and send a message notifying that a code cannot be sent multiple times to the same address.
- Retrieve Unused Code:
- If the email address is not yet in the document, move to the next available code in the Google Sheets document.
- Send the Code:
- Email the code to the customer.
- Record Email Address:
- Record the email address in the Google Sheets document to mark that a code has been sent to that address.
- Mark Code as Used:
- Mark the code as used in the Google Sheets document so it isn’t sent out again.
Thank you for your time!