Michael DeRazon mderazon

Validate URL in a Google Spreadsheet

Formula to check if URL in cell A1 in a Google Spreadsheet is up, using the W3C HTML Checker API

=IF(A1<>"",IF(ISERROR(FIND("non-document-error", INDEX(IMPORTDATA("https://validator.w3.org/nu/?out=json&doc=" & A1),0,2))),"✓","✗"),"")

	const req = require('superagent');
	const writeFile = require('util').promisify(require('fs').writeFile);

	const apiToken = process.env.API_TOKEN;
	const baseUrl = 'https://dmarc.postmarkapp.com';

	(async function() {
	const reports = [];

	// get a list of all reports by id and create time

	var link = 'https://example.com';
	var textArea = document.createElement('textarea');

	textArea.style.position = 'fixed';
	textArea.style.top = 0;
	textArea.style.left = 0;

	textArea.style.width = '2em';
	textArea.style.height = '2em';

	# Use Dockerized infrastructure
	sudo: false

	# Use node_js environnement
	language: node_js
	node_js:
	- "6"

	# Cache Gcloud SDK between commands
	cache:

	var express = require('express')
	var multer = require('multer')

	var storage = multer.memoryStorage()
	var upload = multer({ storage: storage })

	var app = express()

	app.post('/upload', upload.single('users.csv'), function (req, res, next) {
	if (!req.file) {

	youtube-dl -f 140 --ffmpeg-location /usr/local/bin/ffmpeg [list of youtube urls]
	for f in *.m4a; do ffmpeg -i "$f" -acodec libmp3lame -ab 128k "${f%.m4a}.mp3"; done

	import React from 'react'
	import classNames from 'classnames'
	import request from 'superagent'

	export default class FileUploader extends React.Component {

	constructor (props) {
	super(props)
	this.state = {
	fileName: '',

	# file: .git/config

	# this pushes every branch that's already there, plus tags. It does not force push, and it does not push branch that we didn't push manually.

	[remote "origin"] # or whatever it is named
	url = ...
	push = :
	push = +refs/tags/:refs/tags/