Skip to content

Instantly share code, notes, and snippets.

@oldwestaction
oldwestaction / Code.gs
Last active January 3, 2023 01:37
google apps script to populate a google sheet w/ fragrance notes from fragrantica
// full instructions on using this script are available here: https://gist.github.com/oldwestaction/68b5c3bedf6d8acb84ff5a846cd3d8f8
// edit these variables depending on how your sheet is set up
// 1 = column A, 2 = column B, and so on
var googleSheetMenuButton = 'Custom scripts';
var perfumerColumn = 1;
var titleColumn = 2;
var fragranceNotesColumn = 3;