{"product_id":"coinsentry-bitcoin-webhook-alerts-to-google-sheets-gmail","title":"Coinsentry Bitcoin Webhook Alerts to Google Sheets \u0026 Gmail","description":"\u003ch3\u003eInstant Bitcoin indicator alerts in Google Sheets + Gmail (with HMAC security)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives signed Bitcoin \u003cstrong\u003ecoinsentry\u003c\/strong\u003e webhook alerts, verifies the \u003cstrong\u003eHMAC-SHA256\u003c\/strong\u003e signature, then logs crossing events to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and sends an email notification via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives webhook events\u003c\/strong\u003e via a POST endpoint from \u003cstrong\u003ecoinsentry\u003c\/strong\u003e, including the event payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies request authenticity\u003c\/strong\u003e by recomputing the \u003cstrong\u003eHMAC-SHA256\u003c\/strong\u003e signature from the raw request body and comparing it to the \u003ccode\u003ex-coinsentry-signature\u003c\/code\u003e header. Requests that don’t match are dropped.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters for relevant events\u003c\/strong\u003e, processing only events of type \u003ccode\u003eindicator_alert\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and formats alert details\u003c\/strong\u003e such as day, indicator name, direction, threshold, current value, previous value, and BTC close; then prepares an email subject.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a new row\u003c\/strong\u003e to a specified worksheet in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, storing: \u003ccode\u003eday, indicator, direction, threshold, value, previous_value, btc_close\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Gmail notification\u003c\/strong\u003e to your configured recipient with the crossing details.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack BTC indicator crossings automatically for trading review and audit trails.\u003c\/li\u003e\n  \u003cli\u003eNotify your team the moment a coinsentry indicator crosses a threshold—while keeping a historical log in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eBuild a lightweight monitoring layer for SaaS operations that rely on crypto market signals.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ tools:\u003c\/strong\u003e \u003ccode\u003ewebhook\u003c\/code\u003e, \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003eno op\u003c\/code\u003e, \u003ccode\u003ecrypto\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecurity:\u003c\/strong\u003e HMAC-SHA256 verification using the configured signing secret.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003ecoinsentry\u003c\/strong\u003e webhooks → \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e + \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup (high level)\u003c\/h3\u003e\n\u003cp\u003eCreate a coinsentry indicator webhook channel with a signing secret, configure matching n8n \u003cstrong\u003eCrypto\u003c\/strong\u003e credentials, connect \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (ensure the required columns exist), and connect \u003cstrong\u003eGmail\u003c\/strong\u003e with your recipient address.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46203575599283,"sku":"N8N-20736","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/hSjsj9o95dliPeeLPvRMv_RkstAXZf.png?v=1791710036","url":"https:\/\/buyflowscripts.com\/products\/coinsentry-bitcoin-webhook-alerts-to-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}