Google sheet and docs script to create a songbook with lyrics
Lyric-songbook
campfire songbook creator
With this google sheet script, you create a google-docs songbook for campfire-songs. You can choose which songs to include, if it is a broad lyric, small lyric, long lyric etc. Also you can decide to put a lyric on a new page.
Any comments / questions / commits are appreciated.
Copy this spreadsheet to your own drive:
https://docs.google.com/spreadsheets/d/1ZU-V0j8aBu1xbTmap_TCJv0XOxTbn4HiI-403qAOfWo/edit?usp=sharing
Copy this doc to your own drive:
https://docs.google.com/document/d/1rJuI7p-X01jVMHJlVm40wECEvHXwEHD8H34lp99zUZk/edit?usp=sharing
Open your copy of the google-doc, and find the id of the doc in your navigation-bar (url).
Open your copy google-sheet script, and to point to the id your google-doc.
Use the button in the top of the google-sheet to generate the google-doc based on your own songbook.
(You have to allow the sheet to run, and re-click the button afterwards).
Your google sheet have to look like this:
NameSong,Text,AddInBundle,BroadOrSmall,LongOrShort,Seq,Check,Number of lines,Broadest line,ContentOfBroadestLine,Add as a new page
Column A (Name): contains the title of your song
Column B (Lyric): contains the lyrics of the song
Column C (AddinBundle): should it be in the bundle (YES/NO)
Column D (BroadOrSmall): Is this a broad or small lyric (BROAD/SMALL)
Column E (LongOrShort): Is it a long or short lyric
Column F (Sequential number): =IF(OR(E2="Long",D2="Broad"),0,INDIRECT(ADDRESS(ROW()-1, COLUMN()))+1)
Column G (Check): =IF(OR(INDIRECT(ADDRESS(ROW(), COLUMN()-2))="Long",INDIRECT(ADDRESS(ROW(), COLUMN()-3))="Broad"),IF(ISODD(INDIRECT(ADDRESS(ROW()-1, COLUMN()-1))),"Not good",""),"")
Column H (NoL): =IF(B2="", 0, LEN(B2) - LEN(SUBSTITUTE(B2, CHAR(10), "")) + 1)
Column I (BrL): =LEN(ARRAYFORMULA(INDEX(SPLIT(B2, CHAR(10)), MATCH(MAX(LEN(SPLIT(B2, CHAR(10)))), LEN(SPLIT(B2, CHAR(10))), 0))))
Column J (CoBL): =ARRAYFORMULA(INDEX(SPLIT(B2, CHAR(10)), MATCH(MAX(LEN(SPLIT(B2, CHAR(10)))), LEN(SPLIT(B2, CHAR(10))), 0)))
Column K (Newpage) Should it start with a pagebreak usage: "New page"
Some searchterms, to help people find this script.
1. Campfire song collection
2. Outdoor songbook
3. Camping song anthology
4. Fireside songbook
5. Hiking songbook
6. Wilderness songbook
7. Campfire singalong book
8. Camp song guide
9. Outdoor music collection
10. Trail songbook
1. Google script to make a songbook for printing
2. Google script to create a printable music collection
3. Google script to generate a print-ready songbook
4. Google script for making a printable song anthology
5. Google script to compile a songbook for printing
6. Google script for creating a song collection ready for print
7. Google script to assemble a printable tune book
8. Google script to design a printable songbook
9. Google script to produce a songbook suitable for printing
10. Google script for crafting a songbook you can print
- Google script to create a printable songbook