CodingDoug

Copying Data from a Google Sheet into Firebase Realtime Database in real time via Apps Script

If you're trying to do this, you came to the right place!

Watch this code work in real time: https://twitter.com/CodingDoug/status/942576182276497409

See also this gist for copying in the other direction: https://gist.github.com/CodingDoug/ffc4f050cc489a0280eb7f4cbe36af07

Setup

gist:120fd2dfc023c488b7824cbb60389bb3

let transporter = nodemailer.createTransport({
	service: 'Mailjet',
	auth: {
		user: '[LONG STRING FOR MY USER NAME FROM MAILJET]',
		pass: '[LONG STRING FOR MY PASSWORD FROM MAILJET]'
	}
});

let mailOptions = {
  from: '"Fred Foo 👻" <foo@blurdybloop.com>', // sender address

rwclarke

var cloudinary = require('cloudinary');

cloudinary.config({ 
  cloud_name: '', 
  api_key: '', 
  api_secret: '' 
});

module.exports = {