Skip to content

Instantly share code, notes, and snippets.

@JustinByrne
JustinByrne / laravel-ci-cd-workflow.yml
Last active May 29, 2024 21:09
Github Action to test laravel and then compile the assets to a production branch
name: CI/CD workflow
on:
push:
branches:
- main
pull_request:
branches:
- main
jobs:
testing:
// get queue number
function getQueueNum() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var range = sheet.getRange(1,getColByName('status'),sheet.getLastRow());
var values = range.getValues();
var queue = 1;
var statuses = ['Pending','pending','In Progress','in progress','In progress','in Progress'];
// send email
function email(subject, body, col = "email") {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var selection = ss.getActiveRange();
var currRow = selection.getRowIndex();
var emailCol = getColByName(col);
var email = sheet.getRange(currRow, emailCol).getValue();
// get column by the content in it - first row only
function getColByName(columnName) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var range = sheet.getRange(1, 1, 1, sheet.getLastColumn());
var values = range.getValues();
for (var row in values) {
for (var col in values[row]) {
if (values[row][col] == columnName) {

Keybase proof

I hereby claim:

  • I am justinbyrne on github.
  • I am justinbtechguy (https://keybase.io/justinbtechguy) on keybase.
  • I have a public key ASDDO5PWn_efQXTT8vdePYaL3z8SGGx6ZocdDDJoVoWNKAo

To claim this, I am signing this object: