Automated gift code sendout using google mail and google sheet

[User-667]

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

1. Set Up Trigger:

• Set up automation to trigger when a message containing the text “yes please” is received.

2. 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.

3. Retrieve Unused Code:

• If the email address is not yet in the document, move to the next available code in the Google Sheets document.

4. Send the Code:

• Email the code to the customer.

5. Record Email Address:

• Record the email address in the Google Sheets document to mark that a code has been sent to that address.

6. 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!

[Dennis]

Hi @User-667

Setting up an automations using Gmail and Google Sheets with ActivePieces is pretty straightforward. I’ve put together a sample flow to give you a visual idea:

The specifics may vary based on how your Sheets are set up, but the general workflow should be the same.

Got questions about any of the steps? Just shoot me a message, and I’ll be happy to help.

[User-667]

Thank you Dennis! I will try this!