I thought you’ve figured out extra possibilities for exploring. No issues.
Hi Purvang, can you please share the script which is alternate to Autocrat? I will have a look at it if I can really understand and implement it. Thanks
Hey, Let me know your exact use case. I’m using it in many ways so that I can deliver you the best.
Do you require sheets-only solutions or You want to integrate with glide webhook action as well?
I have google doc template which I want to be populated based on user input data from Glide, upon its creation, it should be sent via email to User. This is exactly I am doing using Autocrat (except the difference is that, data are being populated from Google Sheet using Google form submission).
As I understand, using Integromat, I can achieve this in two ways, One is using Google Sheet Module (New Row) and using Glide Webhook. However, I would also like to know if Appscript can entirely handle the part, it would be best (thought need to check if I can really understand it or not).
Would be helpful if you can provide both the solution (probably a learning lesson for me as well).
Thank you for all your help.
Yes, that can be done with Apps Script.
Hi Robert! A good low-code place to process these webhooks, if you want to look into it, is Podio + Globiflow.
Check it out
Thank you Purvang.
Hello Robert, first of all thank you very much for all your contributions without which I would never have started on Glide.
I have a quick question about using the Webhook.
The Webhook recognizes only 4 data fields in the data structure out of the 6 passed by Glide.
Are you aware of a limitation?. I tried to modify the structure and redetermine it but it nerver display more than 4 fields.
Thanks you
Hola,
Who is receiving your Webhook’s data: Zapier, Integromat, etc?
What kind of Glide column (value) are you sending as parameter?
Any screenshot to help and see better your issue?
Saludos
Hola Gustavo. Muchas Gracias por contestar (te voy a contestar en español porque lo escribo mejor que el ingles ),
Yo encontré cuando ocurre el problema.
Todo se comporta normalmente cuando no uso el “Order sheet”!?. Cuando me lo puse “Backwards” (en un Inline List) Glide no transmite ni la mitad de las informaciones, y cuando me quito el “Backwards” todo funciona de nuevo. Parece ser un fallo de Glide no?
A ti que te parece?
Gracias por todo
Saludos
Jeje… que cómo me parece? Una locura!
Creo que tienes unas filas (registros) en blanco y cuando la lista está ordenada en forma Ascendente, Glide encuentra datos en las primeras líneas para enviar pero cuando el orden cambia, esas filas en blanco están ahora de primero y por eso no se envía nada.
Revisa o elimina todas las filas nulas (vacías) y prueba de nuevo mi teoría para ver.
Saludos
Es la primera cosa que compruebe, puedes pensarlo .
Que no, que tengo datos en todas las filas (hay solo 4 !)…
Wao… más curioso aún con solo 4 registros!
Sólo para rechequear:
- estás usando una GS o una Glide Table?
- seguro no tienes un filtro activado en el componente sin querer?
- puedes poner una imagen de la GS/GT para ver mejor?
Saludos de nuevo
Hi, I do something similar with doPost, the execution log register the webhook call from glide but nothing happends. Mi method just do Logger.log(“Here!”); but there are not message in the log.
If I take the URL and put it on the navigator everything is fine and the log show the message, but the same URL from Glideapp, nothing
Do you configure or parametrize something else to run your doPost?
Regards