Use button to trigger Flow webhook

Use button to trigger Flow webhook

Hello,

I am wondering if it is possible to have a button on a sheet that when clicked would send a webhook to Flow?  

I know how I'd imagine it would work, but definitely don't know VBA well enough.  My thought was that when a user clicked the button, a macro would call a custom function.  In the function I would grab a range and send the payload to a webhook URL monitored by Flow. 

Once my data gets to Flow I know where to go from there, but any help with the VBA/Sheet side of things would be greatly appreciated!

Thanks!