You can create a bot in your AppSheet app that will post a JSON payload to a PHP service that you created.
To do this:
- Call a webhook from a bot in your AppSheet app.
- Add a JSON Body Template.
- The template controls the format of the JSON data sent in the body of the webhook post.
- Your PHP code that is invoked by the webhook post can retrieve the post body data by specifying:
$postdata = json_decode(file_get_contents("php://input"));
- After successfully processing the webhook request, your PHP code should return a JSON object containing:
{"Status":"Success"}