I want to automate the sending of to for my customers... i want a trigger immediately their service ends, which will be indicated through a calendar event ending... i dont know how i can include my customers emails even after the automation
Hi
Welcome to the Community!
To ensure I understand, could you elaborate more on the issue? If you can phrase it in the “When A happens in Service X, B should happen in Service Y” format, that’ll help me make sure I give you the best suggestion possible.
I want to ensure we’re on the same page to point you in the right direction.
Looking forward to your response!
Okay... thank you for the response... what I'm trying to make happen is that
"When a new google form is filled and automatically taken into a spreadsheet sheet, An email and sms should be sent to the email filled in through the Google form registration but the emails and sms should be sent after a while, indicated as well in the form registration"
For example: a customer fills the Google form with name, email and hours that an event/ service will end... an email and sms should be sent to the customer to leave a review on the service immediately the event ends.
Hi
- Use Google Forms to Google Sheets integration. Be sure to have a column labeled Email for mapping of fields purposes.
- Send an email using Gmail after Create Spreadsheet Row mapping the Email submitted in the Email Column I mentioned including above, over to the appropriate “To” column in the Gmail Zap setup.
As for SMS, I am not aware of an option that allows you to send out both an email and SMS at the same time, though someone else may be able to provide a way to do this. My workaround would be to set up a Zap that triggers after a new row is added to the same spreadsheet, and then use SMS by Zapier to complete the following:
Let me know if you have questions on this or if I need to come back and address anything I missed!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.