Webhook to post to Google Space?

[Joe_Seiler]

Is there a way to use a bot to trigger a message in a google space?

been playing around with it, but am not sure about the webhook url

[dbaum · Accepted solution]

Maybe Use Apps Script to send an interactive chat message - AppSheet Help helps.

[Joe_Seiler]

Awesome, exactly what I’ve been searching for.  Thanks!

[Joe_Seiler]

Any clue on how to insert a column value?

In the task associated with the bot, I tried to insert different columns.

[Entered by] - Posts to the space as the correct persons name

[En Route Date/Time] - Appears to not be able to used, just returns "sample text" (which is default text that is part of the script)

In the task, I was trying to do this:

CONCATENATE("Entered by:     ", [Entered by], "     ", "En Route Date/Time:     ",[En Route Date Time],"     ","On Site Date/Time:     ",[On Site Date Time],"     ","Cleared Date/Time:     ",[Cleared Date Time],"     ")

The editor says it's good, but the google space post doesn't post the actual column values pulled.  Only the strings between " "

Any thoughts?

[dbaum]

It sounds like you're trying to reference columns from your app directly in the script. You can't do that--Apps Script has no awareness per se of your app or its schema. Instead, you need to define parameters in your script function and populate those parameter values in the Call a script automation task.