Finding a way to automate sending text upon google form results are in

Hello. Total newbie here.
I am trying to set up a automated texting(in which I have set of texts readied) upon when people are sent their google forms results.
I have managed to work it so that I can use sms77io to fetch phone numbers and send the wanted messages
The major issue is… this is not automated. I have to press run once button and then it reads the google sheets and runs the module…
If anyone can help me out to automatically sends out *Hey your results are submitted * once the applicants press the submit button…
My module is simple
Google forms → sms77io
I know I have to fiddle with something but i just can’t do atm…
Thank you

Hey @Sam_Park

Welcome to Make community!

Google form is polling trigger that works on a schedule. You need to turn on the scenario and set the timer for the time span you want. In that time span if there will be some data, it will process. If not, then it will give no output.

image

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel

1 Like

Hi! Welcome to the Make community!

For this to work, you can use the Google Forms / Watch Responses module. When this module executes, it only grabs the new responses, and not the old ones.

Then you configure how many times you want the scenario to execute and find the new form responses
image
You may not need to grab responses too often. You could set Every hours, or every 3 hours, etc. If you click on the “Every 15 minutes”, you will be able to set your scheduling.

And then, you turn your scenario ON. It will start execute regularly according to your scheduling configuration.
image

I suggest that you try and follow the Academy training here: Make Academy

Benjamin

1 Like

I was looking at the scheuling part. Just wanted if it was rather possible automatically.
One more questions: Would the module send texts repeatedly unless I get rid of the numbers from the sheets manually or is there away to find out how to exclude sending texts to those who alreadty recieved.

Hey @Sam_Park

This depends on input data. As I understand your requirement is sending an acknowledgement message to the user. Hence, you can use webhook response module to show the message. That won’t send out repeatedly.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel

2 Likes