Can you show all your blocks
hmm, so where is the block to send text.
Like This :
i fetch the phone number from google sheets don't entred in input field
ooo, i got it
I think the script is wrong, can you share the script
where did you get the script?
from script editor of google sheets
check this :
https://ai2.metricrat.co.uk/guides/howto-create-a-google-apps-script-web-app-bound-to-a-spreadsheet
yes i used this
yes i seen him but it used a input field
You are using GET in your blocks and POST in your web app script.
I would recommend you break things down.
-
First a simple app that sends an sms. Get this working first.
-
Decide what data you want to send to google sheets, and which HTTP method you want to use
-
Decide what data you want back from the google sheet.
-
Adjust the web app script accordingly, and re-publish to new version.
-
Combine the two parts together.
its divised
1- i fetch all phone number from google sheets
2- i send a text message to phone number