Overview

I investigated how to send notifications to GitHub when a Google Spreadsheet is updated using Google Apps Script. I also looked into how to send notifications from Strapi and Contentful to GitHub, so I am recording this as a reference.

Google Apps Script

By preparing a script like the following, I was able to send spreadsheet update notifications to GitHub.

ccccf}oooounnnnnc}v}v}Usssscoa)a;rtttttn"""re;rmhplisAACveeaFtoreotcuopertayeowevnctnanehdltknpehehtytqoeoceeonpepoel_udrahnrtoatrnote:sdA=_sd"itays,,p==tte:z-dpt'p"ySraTeOP.""zphs"ty=pOfgyzeeaiptSehyze=poeJiTtpy"=tpn"So'c_"C{l":On,hx"hi:Ns(xaac".`xana`as=h"agtBptt"eiepr{t(oalip)nrins/ecg:{vrai/ntf/d$iya.{o(pgtn{iio/.tkjghesiunotb}nh+`"uj,bs.ocno"m,/repos/${owner}/${repo}/dispatches`,requestOptions)

The following article was helpful for setting up triggers.

https://businesschatmaster.com/slack/spreadsheet-change-notification

Note that since notifications are sent to GitHub every time the Google Spreadsheet is updated, it is advisable to set up concurrency in GitHub Actions as shown below.

Alternatively, you could configure the trigger to fire only when specific cells (columns) are updated.

ncojaonrobmnc:ebuecaptsirs:unoy:lutrcsp-dne-Breie:spueltsu-snuin-o:po:aslcirdnmedynya:es:-_t::Tpdeueri_bcasoscuhctgponetrantciettukosce-onshnlus::tat/tctehrseutcekout@v3

Strapi

With Strapi webhooks, the body cannot be customized, so it appears that a proxy server like the following is needed.

https://github.com/badsyntax/strapi-webhook-actions-proxy

Contentful

Using webhooks with Contentful was straightforward. The following article was helpful.

https://qiita.com/akitkat/items/3adcbafc4eeabaa6470b

Summary

I hope this serves as a helpful reference for using webhooks with headless CMS platforms.